Microsoft Access Advanced – Classroom

Maximise the potential of Microsoft Access by creating structured databases, writing advanced queries, working with macros, and performing database maintenance.

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

£218.00

+ VAT

Duration

1 Day

Training Options

Classroom

 View Course Details

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, 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.

Don’t know which level you need to enrol?

Testimonials

Our Clients

X clients choose to train with Infero

Top Access FAQs

How do I know which Access level is right for me?

If you are unsure about which level suits you best we recommend to give us a call and one of our telephone experts or trainers will be able to advise you.

Will I receive a certificate upon completion?

Yes, all of our courses come with certificate of completion. After you finish the course, we will send you your certificate through e-mail in 2-3 working days.

Can I ask questions or seek clarification during the course?

Of course, we design our courses in interactive and hands-on manner, so questions are welcome and encouraged during the course.

Is there ongoing support after completing the Access course?

Yes, after the course we provide a variety of post-course support documents so you may revisit the content in your own time, as well as providing 12 months support via e-mail.

How experienced are your tutors?

Our company prides itself on quality of our courses, and that would not be possible with exceptional trainers! We employ tutors with both practical and teaching experiences, making sure they have specialist knowledge. We are happy to provide references and their profiles on demand.

Do I need any equipment for the Live Virtual courses?

For Microsoft Office courses you would need a computer with full version of the software you are training in. We also strongly recommend having access to a second screen for the training. This will allow you to do the exercises on your primary laptop or computer and see the virtual whiteboard on a secondary device. That device can be anything from a separate computer screen, to something like a tablet or phone.