Advanced Microsoft Access

Course

Online

£ 59 VAT inc.

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Online

  • Class hours

    8h

  • Duration

    Flexible

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Dive deeper into Microsoft access with our Advanced Microsoft Access course. With our advanced course you’ll learn how to automate tasks to save you time, how to apply advanced techniques such as macros and VBAs and overall Access best practice.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

Microsoft Access is a database program that allows you to manage your data in the most efficient way possible. From creating custom web apps and tracking assets to organising contacts and managing inventory, the incredible range of functions will transform how you manage data.

Best of all, it is easily accessible to anyone with just a basic knowledge of spreadsheets.

We’ll make you an advanced user of this video training course. Add Microsoft Access to your skillset to become more effective at work, stand out and get ahead.
How to effectively link to other data sources.
How to split a database by splitting the frontend and backend.
To create and maintain macros.
The use of Visual Basic for Applications (VBA).
Advanced options for the use of forms.
Packaging your application for distribution.

CPD UK

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Access
  • Microsoft Access
  • Datasheet
  • SQL
  • Databases
  • Splitting a Database
  • Database
  • Splitting
  • VBA
  • Web Apps
  • Application

Course programme

Syllabus:

Section 1: Introduction
  • Unit 1.1 - Introduction
  • Unit 1.2 - Datasheet View
Section 2: Databases and SQL
  • Unit 2.1 - Linking to Other Access Databases
  • Unit 2.2 - Multi-user Aspects and Splitting a Database
Section 3: Macros, VBA and Customizing the Interface
  • Unit 3.1 - Macros
  • Unit 3.2 - The Ribbon
  • Unit 3.3 - Visual Basic for Applications
Section 4: Events, Forms, SQLs and more
  • Unit 4.1 - Events
  • Unit 4.2 - Forms▸
  • Unit 4.3 - SQL and Joins
  • Unit 4.4 - Action Queries
  • Unit 4.5 - Packaging your Application
  • Unit 4.6 - Web Apps
Section 5: Closure
  • Unit 5.1 - Conclusion

Advanced Microsoft Access

£ 59 VAT inc.