Microsoft Access Training, Tutorials
 |
Microsoft Access 103
Using Microsoft Access 2
Build a Main Menu, command
buttons, form properties, customer list form, continuous forms, track lead
sources. 84 Minutes. |
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
properties.
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.
We'll
update our Main Menu with the new buttons, and additional
features. 
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.
Microsoft Access Training, Tutorials
Access 103 Course Outline
l. Introduction
Objectives
Pre-requisites
Versions used
How to learn
Included files
2. Main Menu, Part 1
Creating a form with no data
Command button to open a form and show all records
Form properties
Form caption
Record selectors
Navigation buttons
Scroll bars
3. Main Menu, Part 2
Form background color
Label control
Label properties (font, size, bold, effects, etc.)
Resizing a label
Putting an image on a command button
Button properties
Send to back / bring to front
Format painter
Setting a database startup form
Application title
Hiding the database window
Unhiding your database window
Creating a shortcut to your database on your desktop
4. Customer List Form
Query: sorted list of customers
Building a form based on a query
Lining fields up horizontally
Continuous forms v. single form
Optimizing form space
Form header & footer
Using the rulerbars to select across/down
Cleaning up your labels
Command button to open a form and show specific records
Opening the selected customer record
Filtered results in your form
Removing a filter
Autoform: Tabular
Autoform: Columnar
5. Tracking Lead Sources
Adding a lead source field to the customer table
Combo box with static list of lead sources
Making at table to store a dynamic list of lead sources
Creating a combo box based on a table
Adding new valves to your table
Updating our Main Menu with the new buttons
Using the Form Wizard to create a quick form
Create a form for lead sources using the wizard
Renaming your form
Create a button to close the database
6. Review
Review topics
Skills check
What's next?
|
