Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Beginner > B2 > B2 Outline < B1 Outline
Access Beginner 2

01. Getting Started (9:01)
Download sample database
Unzip the database file
Don't run Access from inside a ZIP file
Security Warning - Active Content Disabled
Enable Content button
Setting up a trusted location
Set up a Databases Folder
Database shortcut on Desktop
Quick Review of Level 1

02. Form Design 1 (12:51)
Building forms from scratch
Build a user-friendly interface
Form design is more art than science
Rebuild customer form
Expand / collapse Ribbon
Record Source Property for a Form
Bind Form to CustomerT
Delete order by and filtering
Add existing fields, Field List
Switch to Form View
Switch to Design View
Adding fields to form
Deleting a field
Click and drag method
Add multiple fields
Shift-click method
Ctrl-click method
Move text box without label
Move label without text box
Using keyboard to move objects
Delete just the label
Resize text box or label
Select multiple objects
Resize, move multiple objects
Edit the text of a label
Move last name next to first name
Close the Field List
Align Controls Left
Size Controls To Widest
Selecting Objects with Ruler Bar
Foreground, Background Colors

03. Form Design 2 (12:52)
Double-click to add field
The Grid dots
Grid dots v. lines
Sizing objects on the Grid
Size to Grid
Resize the Form itself
Format Painter
Quick Launch Toolbar
Change Form background color
Textbox background color
Label foreground color
Select using the rulerbar
Align Left, Center, Right
Ctrl-Click to select objects
Special Effect Property
Change Font
Standard Color vs Theme Color
More Colors
Full Color Palette
Shape Outline
Line Color, Thickness, Type

04. Intro to Relationships (15:53)
Why Relationships
Relationship Types
One-to-One, Many-to-Many
Primary Key, Foreign Key
AppointmentT Table
Default Value
Date() Now()
Multiple Appointments per Customer

05. Appointment Form (20:25)
Create AppointmentF
Add Fields
Format Align Left
Undo (Ctrl-Z)
Customer Combo Box
Relational Combo Boxes
Combo Box Wizard
Store Value in CustomerID
Name Property
Control Source Property
Forms Save Position
Tab Order (Auto Only)
Command Button Wizard
Open Form Show Specific Records
Find Records

06. Q&A From Students (xxxx)
Customize the Ribbon
Can’t See Text
Print Form in Design View
Start AutoNumber >1
Combo Box Always Open
Maximum Database Size
Maximum Number of Fields
Access on a Mac
Restore Deleted Textbox
Green Triangle
#Name? Error
Unrecognized Database
Checkbox Background Color
Multiple Tables on a Form
Thumbtacks on File List

07. Review & What's Next (xxxx)
Review of Topics
Coming Up Next...



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

1/22/2022Next Appointment
1/18/2022Access B2 Upgrade
1/17/2022Access Beginner 2 Links
1/17/2022Access Beginner 2
1/17/2022New Record on Top
1/13/2022Missing References
1/13/2022Access Beginner 1 Links
1/11/2022Access Fast Tips
1/11/2022System Defaults

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Page Tag: outline access 00 002  PermaLink