|
|
|
Access
Beginner Level 7
Beginner Microsoft
Access Tutorial - 1 Hour, 31 Minutes |
|
|
|
This Microsoft
Access video tutorial picks up where
Level 6
left off. This class covers building a navigation system for your
database. We'll start out with a simple Navigation Form, then
we'll build a custom Main Menu interface. We'll finish off by
building a Customer List Form where you can pick a customer from a
list to open directly to that record. Topics include:
 |
-
Navigation Forms
- Custom Main Menu Form
- Sorted Customer List Form
- Command Button Open Form & Report -
Form Record Source Property -
Creating Continuous Forms - Form Header & Footer
- Open Form to a Specific Record
- Allow Edits, Deletions, Additions |

Order Now |
If you would like a preview of what's covered in this class,
click here to watch the first lesson of
this course (free of charge), or scroll down for more information.


|
Access Beginner Level 7 |
Description: |
Access
Beginner Level 7 |
Versions: |
This class was recorded with Microsoft
Access 2010. The material is valid for Access 2007 up to 2021. |
Pre-Requisites: |
Access
Beginner Level 6 |
Running Time: |
1 Hour,
31 Minutes |
Cost: |
$12.99 |
|
|
This class
picks up where
Level 6 left off. We will begin be learning how to create
Navigation Forms, which are a simple way to provide a way to move
between the different forms and reports in your database. You will learn
about single- and multi-level navigation forms. You will learn how to
set a form as your Startup Form so that the database opens up
right to it. You will learn how to hide the Navigation Pane so
your end-users can't poke around in your forms and reports. You will
also learn how to bypass the startup options so you (the developer) can
get into your database without restrictions.

Navigation Forms have
several limitations (which we'll discuss in class). Next, we'll create a
Custom Main Menu Form. This gives you complete control over the
look, feel, and function of the menu interface for your database. You'll
learn how to use a Command Button to open a form and show all records.

Once we've got the Main
Menu Form working, we'll take some time to format it properly. A
well-designed menu interface makes your database more efficient. You'll
learn about form properties, the form caption, and how to
turn off record selectors, navigation buttons, and scroll bars. You'll
learn how to use Label objects to create groups for your buttons.
You'll learn about the Send to Back command to structure the
"stacking" of objects on your form. We'll make buttons to open all of
the reports in our database in Print Preview mode.

Next we'll build a
Sorted Customer List Form. This will be a form that will show us a
list of customers, sorted alphabetically by name. We will be able to
select a specific customer and then click a button to open that
customer's record up directly in the CustomerF form. You'll start by
making a sorted customer query, then creating a new blank form.
We'll then change the
form's Record Source Property to get its values from a query
instead of a table. We'll change the form from a Single Form to a
Continuous Form so you can see all of the records on one screen.
Then we'll activate the Form Header & Footer so you can move the
labels to the top, and have room for a button on the bottom.

Next we'll create a button to open another form (the CustomerF form) and
show a specific record only (the customer that was selected).
You'll also learn a bunch of tricks in this lesson, like making a button
transparent, setting scrollbars to "vertical only," and preventing users
from editing the values on a form using the Allow Edits, Allow
Additions, and Allow Deletions properties.
Of
course, if you have any questions about whether or not this class is
for you, please contact me.

Complete Outline - Access
Beginner Level 7
00. Introduction (7:09)
01. Navigation Forms (16:46)
Getting around in your database
Switchboards, discussion of
Navigation Form Pros and Cons
Create Simple Horizontal Nav Form
Add Forms to Nav Form
Add Reports to Nav Form
Rename Tabs
Change Form Caption
Rearrange / Move Tabs
Delete Tab
Horizontal Tabs, 2 Levels
Multi-Level Menu Tabs
Tabs by Object Type
Tabs by Data Type
Changing Colors
Display Navigation Form on Startup
Hide Navigation Pane on Startup
Bypassing Startup Options
Nesting Navigation Forms, discussion of
02. Main Menu Form 1 (12:01)
Create a Blank Unbound Form
Command Button Wizard
Form Operations > Open Form
Button Text (Caption)
Open Form Show All Records
Make Forms Remember Startup Position
Command Button Wizard not starting
Use Control Wizards Option
Why Use Command Buttons
Button to Close Form
03. Main Menu Form 2 (18:07)
Change Form Background Color
Form Properties
Form Caption Property
Form Property Sheet
Turn Off Record Selectors
Turn Off Navigation Buttons
Turn Off Scroll Bars
Main Menu Label
Formatting Label Options
Shape Outline
Special Effect
Shadowed Labels
Use Labels to Group Buttons
Position > Send to Back
Report Operations > Preview Report
Copy Logo to Main Menu Form |
04. Customer List Form 1 (11:54)
Sorted List of Customers
NOT Using a Multiple Items Form
Create a Sorted Query for Customers
Form Design View with Blank Form
Setting a Form's Record Source Property
Query as a Record Source
Show Only Fields from Current Record Source
Form Properties
Default View > Continuous Forms
05. Customer List Form 2 (18:59)
Rearrange Fields into Columns
Put Labels in a Row Over Text Boxes
Form Header & Footer
Page Header & Footer, discussion of
Move Labels to Form Header
Access Should Save Form Position and Size
Command Button to Open Customer Form
Open the Form
Find Specific Data to Display
Which Fields Contain Matching Data
Making a Button Transparent
Turn off Navigation Buttons
Turn off Record Selectors
Set Scroll Bars to Vertical Only
Allow Additions
Allow Deletions
Allow Edits
06. Review (5:46) |

|
|
Keywords:
Navigation Forms, Custom Main Menu Form, Customer List Form, microsoft access tutorial, microsoft access tutorial, microsoft access training, switchboards, form caption, 2 levels, startup form, bypassing startup options, unbound form, command button wizard, form operations, open form, button caption text, show all records, startup position, wizard not starting, use control wizards, close form, form properties, send to back, bring to front, preview report, multiple items form, continuous forms, record source, Show Only Fields from Current Record Source, form header, form footer, page header, page footer, Open the Form and Find Specific Data to Display, which fields contain matching data, transparent button, vertical scrollbars only, allow additions, allow deletions, allow edits |
|
|
|