0345 4506120

Microsoft Access Advanced

At the end of this course you will have a complete understanding of the higher functions of Access.

 

Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details

 

Reset

Learning Objectives

  • You will learn to automate functions by creating simple and then very advanced macros.
  • You will advance your querying ability and then to use SQL statements in your queries.
  • You will discover how to work with objects, and the fundamentals of database management.
  • Finally you will be taught how to protect your valuable data sources.

Pre-Requisites

A good working knowledge of Access is required

Course Content

Advanced Data Management
• Referential Integrity  • Table Relationships  • An Introduction to SQL  • Modal Dialog Boxes 
Advanced Form Tasks
• Using Subforms  • Creating a Navigation Form  • Advanced Form Controls  • Exporting a Form  • Other Form Tasks 
Pivoting Data
• Creating a PivotTable  • Using PivotTables  • Advanced PivotTable Tasks  • Creating a PivotChart  • More on PivotCharts 
SQL and Microsoft Access
• Understanding SQL  • Using the SELECT Statement  • Using Subqueries  • Using SQL Joins 
Macros and Visual Basic for Applications (VBA)
• Macro Basics  • More about Macros  • Access and VBA  • Building Advanced Procedures  • Using VBA in a Database 

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include