All Microsoft Access classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Microsoft Access Course - Advanced
Advanced Access course
Gain advanced Access skills and learn advanced database concepts in this advanced Microsoft Access course. Find out how to organize data more efficiently, develop advanced queries, analyze data, summarize data, apply security, create macros, and use VBA.
Why Microsoft Access classes at AGI are the best option for you
- Hands-on learning: Learn Microsoft Access quickly with our proven teaching methods.
- Exceptional curriculum: AGI has delivered Microsoft Access training to thousands over 25 years.
- Expert instructors: Our instructors are Microsoft Access experts and skilled educators.
- Small class sizes: Receive personalized attention with 10 or fewer participants per class.
- Repeat for Free: If you need a refresher or miss a class day, retake the Microsoft Access class at no cost.
Questions about this advanced Microsoft Access class? Interested in private or customized training? Call to speak with a training consultant: 781-376-6044.
Ways to attend this Microsoft Access Course
- Live Online classes from your office or home as a regularly scheduled small group class.
- Live, in-person regularly scheduled Microsoft Access classes in Boston or Philadelphia with a live instructor in the same classroom.
- Private training customized to your specific needs delivered in-person or online. Call 781-376-6044 or complete the Private Microsoft Access Training form for more information.
Please call 800-851-9237 or 781-376-6044 to schedule a course.
Advanced Microsoft Access course: key topics
- Advanced form design
- Sharing data between Access and other applications
- Using Macros to improve efficiency
- Using VBA
- Advanced database management
- Sharing database access
- Implementing database security
- Managing switchboards
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
Custom and private Microsoft Access classes
This Microsoft Access course is available as a private class. Curriculum can be customized for your specific needs. Microsoft Access classes can be delivered at your location, online, or in our classrooms. For more information, call 781-376-6044 to speak with a training consultant or contact us.
We recommend that you have Microsoft Access installed on your computer before starting this class.
You will receive a comprehensive course manual for this Advanced Access class developed by the instructors at AGI. AGI instructors have created many of the official training guides and books for Microsoft.