Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
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
Shadowed
Change Font
Themes
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-Many
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 (25:12)
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
LACCDB Files

07. Review & What's Next (5:21)
Review of Topics
Coming Up Next...

 

 

Check out these other pages that may be of interest to you:

12/1/2022Load Faster
11/29/2022Date Buttons
11/29/2022Change Date Field
11/28/2022Top X
11/27/2022System Settings
11/25/2022Application Title
11/24/2022Full HTML Editor in Access
11/24/2022Change Database Title
11/23/2022Other Names
11/21/2022Check Icon File
 
 

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
amicron@gmail.com
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Page Tag: outline access 00 002  PermaLink  Access Beginner 2