Microsoft Access Course - Advanced

Advanced Access course: complete class topics

Advanced form design in Access

• Adding controls to forms
• Enhancing form navigation
• Improving form organization
• Applying conditional formatting

Sharing Data Across Applications

• Importing data into Access
• Exporting Access data
• Linking tables to external data sources
• Creating mail merges

Using macros to improve user interface design

• Creating macros
• Restricting records using conditions
• Validating data using macros
• Automating data entry using macros

Using VBA

• Understanding VBA and when it is used
• Enhancing Access using VBA

Using advanced database management

• Manage databases
• Determining object dependency
• Documenting databases

Distributing and securing access to databases

• Splitting databases for multiple-user access
• Implement security
• Converting an Access database to an ACCDE file
• Packaging a database with a digital signature

Managing switchboards

• Creating database switchboard
• Modifying database switchboard
• Set Access database startup Options