logo
Home

Microsoft Access Advanced Training Course | CourseMonster

  • CMDBID 1217
  • Course Code MACADVC
  • Duration 2 Days
Scroll

Microsoft Modern Workplace Course

course overview

download outline

Select Country and City to View dates & book now

Overview

Microsoft Access Advancedis a practical training course for teams that need structured, instructor-led skills in Microsoft Access Advanced Module, Advanced Table Design Advanced, Field Properties Table Properties. CourseMonster has rewritten this summary to make the page clearer for learners, managers and search engines while preserving the key learning outcomes.

This course is applicable to users of 2010, 2013, 2016, and 2019/365 - and is for users of Microsoft Access who are looking to obtain skills at an advanced level working behind the scenes of relational databases. If you’re attending at a QA location, the course will be delivered on Access 2016.

Target Audience

The course is aimed at users who wish to obtain skills in advanced table, query, form and report design, and manage their databases, as well as users who are looking to provide some levels of automation. These can be users who have already designed databases, have inherited databases or are looking to create databases.

. Explore more Microsoft traininghere

Useful links: Microsoft Learn training | Cyber Security training at CourseMonster | CourseMonster course page

CourseMonster SEO course note: Microsoft Access Advanced Training Course | CourseMonster has been positioned as a practical Microsoft learning pathway for teams that need searchable, role-based training outcomes rather than a generic course description. The page now highlights Microsoft, Access, CourseMonster, certification readiness, workplace application and visible next-step links so learners can compare this course with related CourseMonster programmes.The course is listed as 2 day(s), making it suitable for structured team scheduling.It is especially relevant for use advanced features in the design of all major objects. you will learn how to apply simple automation to database objects using macros, how to use built in database tools to manage a database and also work with externa

Related CourseMonster courses: Microsoft 365 Mobility and Security MS-101T00-A Training Course | CourseMonster | AZ-104 Microsoft Azure Administrator | Microsoft AZ-301 Azure Solutions Architect Design

Browse the vendor/category pathway: Microsoft training courses on CourseMonster

Audience

Use advanced features in the design of all major objects.

You will learn how to apply simple automation to database objects using macros, how to use built in database tools to manage a database and also work with external data to import, export and link data in a database.

Skills Gained

By completing the Microsoft Access Advanced QAACADVC course participants will gain practical knowledge, configuration skills, implementation techniques and best practice understanding relevant to real enterprise environments.

Useful links: Microsoft Learn training | Cyber Security training at CourseMonster | CourseMonster course page

Additional workplace outcomes: Participants can explain where Microsoft Access Advanced Training Course | CourseMonster fits in a wider Microsoft skills roadmap, identify related certifications or follow-on courses, and apply the concepts to real project, operations or service delivery scenarios.

Prerequisites

Before attending this course, students should have attended QA courses QAACINTC or DAC10L1 or similar.

Equivalent skills that would see students be able to create simple tables, forms, reports and queries, make modifications in the design view of database objects and have a good understanding or relational database concepts such as table relationships are also appropriate.

Please Note: If you attend a course and do not meet the prerequisites you may be asked to leave.

Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.

Outline

Module 1 - Advanced Table Design

  • Advanced Field Properties
  • Table Properties

Module 2 - Advanced Query Design

  • Advanced Naming Conventions
  • Join Tables in Queries
  • Manage Query Joins
  • Use Self-Joins in Queries
  • Summarise Data in Queries
  • Parameter Queries
  • Action Queries
  • Crosstab Queries

Module 3 - Advanced Form Design

  • Create Subforms and Linked Forms
  • Form Controls
  • Command Buttons
  • Form Properties
  • Interface, Start-Up and Navigations Forms

Module 4 - Working with Macros

  • Create Single Macros
  • Run Macros
  • Work with Sub Macros
  • Use Conditional Macros
  • Run Macros from Buttons
  • Assign Macros to Events

Module 5 - Extending Data Reach

  • Import Data
  • Export Data
  • Work with Linked Tables

Module 6 - Managing Databases

  • Object Dependencies
  • Database Documenter
  • Performance Analyzers
  • Regular Management of a Database
  • Access Database Security
  • Appendix 1 - Importing Access Objects
  • Appendix 2 - Using Forms with Parameter Queries
  • Appendix 3 - Create Union Queries
  • Appendix 4 - Custom Web Apps
  • Appendix 5 - Relationships (as reference)
. Explore more Microsoft traininghere

Useful links: Microsoft Learn training | Cyber Security training at CourseMonster | CourseMonster course page

Suggested learning path: After this course, compare related options via the links in the overview and the Microsoft training category.

Certification

For customers attending remotely via Virtual Classroom or ‘Attend From Anywhere’, an additional screen is required for this course to work through remote desktop labs and view training information.

For learners without access to the software required for this event, a remote PC can be provided using GoToMyPC. If you have any questions, contact our Virtual team.

What will I learn in the Microsoft Access Advanced training course?

You will learn the core concepts of Microsoft Access Advanced Module, Advanced Table Design Advanced, Field Properties Table Properties, how they apply in real workplace situations, and how to use the course outcomes to improve team capability.

Is Microsoft Access Advanced suitable for beginners or experienced professionals?

It is suitable for learners who need structured training in Microsoft Access Advanced Module, with prerequisites depending on the course level, vendor pathway and any certification requirements.

Does the Microsoft Access Advanced course help with certification or exam preparation?

The course includes exam-focused guidance where the vendor certification is applicable; check the exam section and the visible official vendor link for the latest exam code, format and syllabus.

What should I study after Microsoft Access Advanced Training Course | CourseMonster?

A common next step is to compare related CourseMonster courses in the Microsoft pathway. See visible links on this page, including https://www.coursemonster.com/training-courses/microsoft, to choose the most relevant follow-on course.

Talk to an expert

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes

Trusted by over 1/2 million students in 15 countries

Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.