Live Access Training

Course Topics

Introduction to database concepts 
• How a database can help me
• Tables, relationships & forms
• Working with the Access application window

Design Considerations
• Designing tables
• Defining your needs
• Understanding table relationships
• Creating a basic table
• Adding fields to an existing table
• Object Naming Conventions
• Understanding field properties
• When to use an input mask
• Setting the primary key
• Adding records to a table datasheet

Formatting a table
• Editing records
• Selecting records, fields and columns 
• Deleting records and fields
• Viewing or setting datasheet default values
• Re-ordering columns and fields
• Changing column width and row height
• Hiding and un-hiding columns
• Freezing columns
• Formatting datasheet cells
• Changing datasheet fonts
• Copying and moving fields and records
• Printing

All About Relationships
• Defining table relationships
• Opening the relationships window
• Adding tables to the relationships window
• Making relationships
• Referential integrity
• Editing relationships

Locating and replacing information
• Performing simple searches
• How to use wildcards
• Finding specific values
• Finding and replacing data
• Sorting records
• Working with data filters

Creating simple queries
• Creating queries from scratch
• Using expressions in query criteria
• Multiple criteria and alternative criteria
• Calculating new fields
• Summary queries
• Update, append, make-table, & delete queries
• Resolving null query results

Working with Forms
• Basic form layout types
• Creating a form using autoform
• Creating a form using the form wizard

More about creating forms
• Creating forms from scratch
• Modifying form design
• Working with controls
• Using the toolbox
• Creating a combo box control 
• Understanding form properties
• Creating subforms
• Assessing data input
• Changing tab order
• Adding command buttons

Reports
• Opening and viewing reports
• Printing single & multiple reports
• Creating a report using autoreports
• Creating reports using the report wizard
• Using the label wizard
• Using the chart wizard
• Grouping levels in reports
• Creating a report without a wizard
• Modifying report controls
• Changing report properties
• Using different data sources on a report