Microsoft Access Introduction (2 days)
Fundamentals
Basic database concepts
Designing a basic database
Overview of MS Access
Opening an existing database
The Access environment
Access Objects
Editing an Access table
Navigating through a table
Deleting records
Adding new records
Finding and sorting
Creating tables
Creating tables in design view
Using the Table Wizard
Setting field attributes
Setting a primary key
Datasheet view
Filtering and sorting
Finding records
Filtering records
Filtering with forms
Sorting records
Working with forms
Using the Form Wizard
AutoForms
Bound and unbound forms
Data validation
Adding records via a form
Relationships
Creating key fields
Creating relationships
About referential integrity
Using subdatasheets
Queries
Design view queries
Setting criteria
Using the query wizard
Sorting queries
Modifying and updating queries
Querying multiple tables
Creating reports
The Reports Wizard
Formatting a report
Linking reports to queries
Generating groupings
Creating custom headers
Adding your logo
Printing reports
View Basket
Recover Basket