|
|
DATABASES
| Level |
Course Coverage |
Office
Versions |
 |
| Introduction |
- Building New Databases and Tables from scratch
- Table Field types and properties
- Entering and Importing information
- Moving, finding, filtering, editing and deleting data
- Creating and running queries
- Calculatiing and statistics from Queries
- Creating, using and designing Forms
- Creating, using and Designing Reports
|
All Versions |
| Intermediate |
- Designing multi Table relationships
- Multi-Table Queries
- Action Queries
- Pivot Table View and Charting
- Query Parameters
- Multi-table Forms and reports
- Form and Report design
- Using Word for Mail Merging content
|
|
| Advanced |
- Relating Tables usign Referential Integrity
- Advanced Database design techniques
- Building Multi-Table Forms and Reports
- Adding form controls
- Automatiing Access via Macros
- Macro Actions, Arguments and Events
- Building front end Switchboards
- Automating Database startup
|
|
| Programming |
- Visual Basic for Applications environment
- Visual Basic Language elements
- Creating Modules and Inserting Procedures
- Access Objects
- Declaring Variables and Constants
- Handling user input and output
- Event Procedures in Forms and Reports
- Accessing tables and Queries via ADO
- Automating other applications from Access
|
|
|
