|
Beginner Lessons |
|
|
|
|
|
Database Terminology & Benefits
Planning Your Database
The Access Interface & Ribbon
Building a Customer Table
Entering & Editing Data
Sorting and Filtering Records
Constructing Customer Queries
Designing a Customer Form Interface
Developing Reports & Mailing Labels |
|
|
|
|
|
|
|
|
|
Setup a Trusted Location
Working in Form Design View
Manually Adding Fields
Manipulating Form Objects
Lining up Objects on The Grid
Formatting Your Form
Using Themes, Fonts, & Colors
Working in Layout View
Using Overlapping Windows |
|
|
|
|
|
|
|
|
|
What are Field Properties
Field Size
Caption & Description
Format Property
Decimal Places
Input Masks
Setting a Default Value
Validation Rule & Text
Using Inequalities |
|
|
|
|
|
|
|
|
|
More Field Properties
Required & Allow Zero Length
Text Align & Format
HTML Encoded Rich Text
Indexing Fields
Compact & Repair
Backing Up Your Database
Find & Replace
Questions From Students |
|
|
|
|
|
|
|
|
|
Query Criteria
Multiple AND, OR Conditions
Inequalities
Records Between Two Dates
Dealing with Null Values
Wildcards and LIKE
Parameter Queries
Top X Values
Formatting Query Field Output |
|
|
|
|
|
|
|
|
|
Missing Address Info
Is Null and Is Not Null Scenarios
OLE Objects
Storing Pictures in a Database
Align / Size to Grid
Stretch, Clip, Zoom Images
Employee Name Badges
Adding a Company Logo
Bound v. Unbound Image Controls |
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
Value List Combo Box
Table-Based Combo Box
Multi-Column Combo Box
Combo Box to Search Records
List Boxes
Limit to List, Edit List Items Properties
Add, Edit the Combo Box Items
Tab Order, Tab Stop
Form Cycle Property |
|
|
|
|
|
|
|
|
|
Tracking Contact History
Data Integrity
Report Design From Scratch
String Concatenation
Report vs. Page Header & Footer
Can Grow / Can Shrink Properties
Records from a Specific Date
Explicit Query Parameters
Report Formatting |
|
|
|
|
|
Expert Lessons |
|
|
|
|
|
Relational Database Concepts
Primary & Foreign Key Fields
Types of Relationships
Focus on One-to-Many Relationships
Ad Hoc Query Joins
Left Joins to Show All Records
Relational Combo Boxes
Fixing Lead Source & Shipping Combos
Select a Customer on the Contact Form |
|
|
|
|
|
|
|
|
|
Database Table Normalization
Global Relationships
Working with the Relationships Window
Referential Integrity
Preventing Orphaned Records
Cascade Update & Delete
Table Subdatasheets
Setting Values Across Different Forms
Forms ! FormName ! FieldName |
|
|
|
|
|
|
|
|
|
SQL Basics
Future Callbacks for Customers
Default Value to Tomorrow at 9 AM
Creating Subforms
Link Master & Child Fields
Using SQL in Form Record Source
Form Footer Totals
Sum, Avg, Max, Min, Count
Modifying Embedded Macros |
|
|
|
|
|
|
|
|
|
Additional Form Controls
Option Groups, Tab Control
Toggle Buttons, Enhanced Formatting
List Box, Image Control
Display Image Without Storing
One-to-One Relationships
Extended Customer Details
More One-to-Many Relationships
Track multiple family members |
|
|
|
|
|
|
|
|
|
Print a Letter Report
Edit Embedded Macros
Dealing with Dirty Form Records
RefreshRecord Command
Export to Word, Excel, PDF, more
Email Report via Outlook
HyperlinkPart Function
EmailDatabaseObject Command
Customize the Ribbon |
|
|
|
|
