Course Length
Full day
Course Description
This course is for the individual, whose job responsibilities include the need to use Access features such as database management, advanced form design, encrypting a database, preparing a database for multi-user access, and more.
Course Topics
Learn Advanced Form Design
- Add controls to forms
- Create Subforms
- Organize information with Tab pages
- Enhance Navigation forms
- Apply Conditional formatting
Use Data Validation
- Field Validation
- Form and record validation
Use Macros to Improve User Interface Design
- Create a macro
- Restrict records using a condition
- Validate data using a macro
- Automate data entry using a macro
- Convert a macro to VBA
Use Advanced Database Management
- Link tables to external data sources
- Manage a database
- Determine Object Dependency
- Document a database
- Analyze the performance of a database
Securing a Database
- Split a database for multiple user access
- Implement security
- Set passwords
- Convert an Access database to an ACCDE file
Manage Switchboards
- Create a database switchboard
- Modify a database switchboard
- Set Startup options
What Participants Receive
Each participant receives a guide containing step-by-step instructions.
