Course Outline

Microsoft Access 2019 Advanced

Overview

Who is this course for?

With basic skills and some experience of Microsoft Access, the topics covered on this course will help you to enhance your relational database.

 

How long is this course?

1 Day 

 

What do I need to know before attending?

It is assumed that you have a skill level equivalent to that gained through attending the intermediate Access training. 

 

What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:

  • Understand the 'languages' behind the scenes -including SQL and VBA.
  • Automate actions using macros and simple Visual Basic procedures.
  • Manipulate data for reports, either within Access or by outputting to other Office applications.
  • Understand the Access security model and the implications for protecting your data and application.

 

Price Band:

 Specialised

Content

Database Structure
Review of the elements of an Access database and the importance of table relationships.


Advanced Querying
Grouping in queries.
Creating cross-tab queries.
An introduction to the SQL (Structured Query Language) behind queries.
Creating & using Union queries.


Linking Tables/Importing & Exporting
Importing data and structures from other database applications.
Linking data to other database applications.
Exporting data to Microsoft Word and Excel.
Exporting linked data source information to Excel


An Overview of Macros & Modules
Explaining the differences and benefits of Macros and VBA Modules.
Creating macros to assist users with navigation through an application and other routines.
Assigning macros to buttons and designing end-user forms.
An introduction to the VBA programming power within Access modules.
Reading and writing simple procedures with and without Wizards.


Database Security
Database passwords.
Understanding the limitations of Access 2013 security.
Concepts of creating your own user management.

call us on 01270 765500

www.vtl.co.uk
IIP