I think there's just a little confusion over the terminology here. The "System Defaults" aren't special fields that Microsoft Access creates for you.
Back in Expert 9, we created a table called DefaultT to store values that apply to the whole database. At that point, it contained the SalesTaxRate. In Expert 10, we continue working with that same table and add things like the company name, address, city, state, postal code, country, and company logo.
So look in your Navigation Pane under Tables for DefaultT. That's the System Defaults table I'm referring to in the lessons.
In Lesson 1 of Expert 10, we add the additional company information to DefaultT. Then in Lesson 2, we create DefaultF to make it easier to edit those values, and we start using DLookup to retrieve them directly from DefaultT without needing the form open.
Also remember that DefaultT is intentionally designed to contain just one record. These are database-wide settings, not records that you add for each customer, order, etc.
If you're following along with the class, make sure you've completed Expert 9 first, since Expert 10 continues directly from the database we built there.
Khayhin KweeOP
@Reply 4 hours ago
Hi Richard, I really appreciate you took the time to response given you are the only one servicing us. Thank you. I just want to clarify that what I meant was that in the Main Menu form, the green color System Defaults panel was on it in expert 9, but not in expert 10 database. That's all. I was just worried that I am missing something. That's all.
Ah, gotcha. You're right - the downloaded Expert 10 database already has the System Defaults panel removed from the Main Menu. In Lesson 2, we move those settings off the Main Menu and into their own form, DefaultF.
So you're not missing anything. The sample file is the completed database for the whole class, whereas the video starts from the end of Expert 9, where that green panel was still on the Main Menu.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.