| |
| |
Access
Introduction |
|
| |
- Overview
of relational databases
- Planning
a database
- Creating
& editing tables
- Working
with tables
- Data
types
- Queries
- finding the information you want
- Forms
- designing forms for the end user
- Reports
- producing reports for successful presentation of information
- Relationships
|
|
| |
|
Duration: |
| |
|
2
or 3 days |
| |
Access
Intermediate |
|
| |
- Creating
more flexible databases
- Advanced
queries
- Advanced
work with forms
- Advanced
work with reports
- Relationships
- Creating
macros
- Making
more efficient databases
- Integrating
the many elements in Access
- Maintenance
of your database
|
|
| |
|
Duration: |
| |
|
2
days |
| |
Access
Programming |
|
| |
- Overview
of Access Visual Basic
- Visual
Basic vs macros
- Understanding
essential programming concepts
- Variables
- Control
Structures
- Operators
- Arrays
- Handling
errors
- Recordsets
|
|
| |
|
Duration: |
| |
|
2
or 3 days |
|