Home >
Microsoft Office >
Advanced MS Access
Advanced MS Access
| Course Code: |
OFFAC2 |
| Duration: |
2 days |
| Prerequisites: |
Completion of our course Introduction to Access or
equivalent knowledge.
|
| Objectives: |
Upon completion of this presentation, the participant should
be able to perform complex queries, create efficient forms and reports and create and use macros.
In addition, the student will learn about security issues and creating a user-friendly interface.
|
| Core Topics: |
Refining Table Design
- Lookup Wizard
- Input Mask Wizard
- Set a default property
- Customise AutoNumbers
Advanced Form Design
- Create a form with a subform
- Add a calculated field
- Add control buttons
- Add an Option Group
- Using Combo Boxes
- Control properties
- Create a Switchboard
Queries
- Parameter queries
- Crosstab queries
- Action queries
- Totals queries
- Find top 10
Reports
- Add an expression to a report
- Add subtotals
- Subreports
Macros
- Create a macro
- Modify a macro
- Assign macros to command buttons
Import, Export & Link Data
- Import from/export to Excel
- Import from a text file
- Import from/export to another Access database
- Link tables
Security
- Protect the database
- Set a password
- Hide the database
- Create a user-friendly interface
|
