Microsoft Access 103
Using Microsoft Access
Build a Main Menu, command
buttons, form properties, customer list form, continuous forms, track lead
sources. 84 Minutes.
AC103 Major Topics
- Create a Main Menu Form
- Continuous Forms
- Form Header & Footer
- Combo Box With Data
In this class, we'll pick up where
we left off in Access 102. First, we'll start by creating a
Main Menu form to provide our users with a clean and easy interface
for navigating through the different forms in our database. We'll use
command buttons to open up other forms. We'll learn
how to adjust various form properties such as captions,
navigation buttons, record selectors, scroll bars, and such.
We'll learn how to make this Main Menu open up
automatically when our database is opened. We'll see how we can
hide the main database window from our users - so they can't have
direct and easy access to our tables and queries. We'll also learn how
to make a shortcut to our database on the desktop.
Next, we'll build a Customer List Form. On
this form, we'll have a sorted list of customers. Our user will be able
to click on one of the customers in the list, and click on a command
button to open up that specific customer's record. This makes
navigating through your customer records much easier, and it will teach
us how to create command buttons to open forms and display a specific
set of records. In creating this form, we'll learn about single v.
continuous forms, the form header/footer, and more form
Although we don't spend a whole lot of time with
them, we'll also learn how some of the Autoforms work, and we'll
work briefly with the Form Wizard. Of course, we prefer to teach
you how to build forms manually, but the wizards can sometimes come in
handy if you're in a pinch and need a quick form built.
Finally, we'll track lead sources for our
customers. A lead source is essentially where the customer found out
about us (radio, TV, etc.) We'll create a separate table for our list of
lead sources, and we'll see how we can create a combo box on the
customer form to select a lead source - and how to dynamically change
this list using a lead source form.
We'll also look briefly at another one of
the form wizards to construct a quick form for our lead sources - so
that our users can add and remove options from the list.
update our Main Menu with the new buttons, and additional
In this lesson our database starts to become more of
a real working database. We're starting to add features that make
it real user-friendly - such as the Main Menu. You'll start to see this
database evolve into something you could actually use in a real
production (work) environment.