Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
 
 

< 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 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
 
 

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2023 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 12/4/2023 10:31:54 PM.