Microsoft Access Advanced Course – Virtual
Maximise the potential of Microsoft Access by creating structured databases, writing advanced queries, working with macros, and performing database maintenance.
- All Courses
- Microsoft Office
- Microsoft Access
- Microsoft Access Advanced Course – Virtual
Course Overview
You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.
This course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.
Price
Duration
1 Day
Training Options
Virtual
Microsoft Access Advanced Course Content:
- Lesson 1: Importing and Exporting Table Data
- Lesson 2: Using Queries to Manage Data
- Lesson 3: Creating Complex Reports and Forms
- Lesson 4: Creating Access Macros
- Lesson 5: Using VBA to Extend Database Capabilities
- Lesson 6: Managing a Database
- Lesson 7: Distributing and Securing a Database
Upon successful completion of this course, students will be able to:
- Share data across applications
- Use action, unmatched, and duplicate queries to manage data
- Create complex reports and forms
- Use macros to improve user interface design
- Use VBA to extend database capabilities
- Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting
- Implement security strategies and distribute a database to multiple users
Instructor led, group-paced, virtual classroom-delivery learning model with structured hands-on activities.
- Professional Microsoft Certified Trainer
- CPD Accredited Classroom training in Small Groups for Max Focus
- Only Microsoft Approved Courseware and Exercise Files are used
- Free Assessment of Skills prior to booking
- Certificate of Completion & Complementary 12 Months Post Course Support
- 100% Money Back Guarantee & Price Match Guarantee
- Bespoke Courses & Group Discounts from £89 per person
Students taking this course are database administrators or prospective database administrators who have experience working with Access and need to learn advanced skills.
To ensure your success in this course, you should have experience working with Access, including a working knowledge of database design and creation, form design and creation, report design and creation, and a working knowledge of database querying and the various table relationships.
To meet this prerequisite, you can take the following courses:
- Microsoft Access Introduction
- Microsoft Access Intermediate
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.
The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Choose Your Date & Location
Testimonials
Mark Meade Divisional Service Manager from Vaillant Group
Take Yourself Further With Infero
Top Microsoft Access FAQs
- Start: 9:00am
- Break: 11:00am
- Lunch: 1:00pm
- Break: 3:00pm
- Finish: 5:00pm