Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 

< Previous: Access Beginner 6

Next: Access Beginner 8 >

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 2010 Beginner Level 7
Description: Access 2010 Beginner Level 7
Versions: Microsoft Office Access 2010
Lesson 1 is only for Access 2010 and 2013 users. Beyond that, users of any Access version after 2003 should be able to follow along fine.
Pre-Requisites: Access 2010 Beginner Level 6
Running Time: 1 Hour, 31 Minutes
Cost: $14.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 2010 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 2010 tutorial, microsoft access 2010 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
 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP