Training Program Details
Overview
What is a Database?
Database Objects in Access
Creating / Opening Databases
Tables (Design View)
Creating a Table
Adding Fields
Field Data Types
Saving
Insert Fields
Moving Fields
Change Field Name
Change Field Data Type
Field Size
Format & Decimal Places
Default Value
Caption
Validation Rule/Text
Required
Allow Zero Length
Indexed
Input Mask
Tables (Datasheet View)
Entering Data
Adding Pictures
Zoom and Line Breaks
Column Widths/Row Height
Navigating Records
Formatting Cells
Hiding Columns
Freezing Columns
Cut, Copy & Paste
Deleting Records
AutoNumbers
Sorting
Finding
Filter by Selection
Filter by Form
Save Filter as Query
Queries
Creating Queries
Adding Fields to Grid
Entering Criteria
Running a Query
Sorting and Hiding
Saving a Query
Moving Columns
Performing Calculations
Formatting Columns
Parameter Queries
Totals Queries
Forms
AutoForms
Design & Form Views
Moving/Sizing Controls
Edit Text Labels
The Form Header/Footer
Entering Data in the Form
Reports
AutoReports
Report Bands
Adjusting Controls
Merging Fields
Previewing and Printing
Database Objects
Rename Objects
Making a Copy
Deleting Objects