0345 4506120

Microsoft Access Intermediate (2007, 2010, 2013 & 2016)

The Intermediate course is for individuals whose job responsibilities include maintaining data integrity, handling complex queries, forms, and reports, and sharing data between Access and other applications.

Your training and experience using Microsoft Access will give you basic database management skills such as creating tables, designing forms and reports, and building queries.

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customise reports.

 

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

 

Reset

Learning Objectives

Delegates will learn how to:

  • Design a relational database
  • Join tables to retrieve data from unrelated tables
  • Streamline data entry and maintain data integrity
  • Share data across applications
  • Customise reports to organise and format the displayed information

Course Content

Advanced File Tasks
• Using Windows Explorer within Access  • Database Management  • Saving Your Files  • Exporting Files  • Linking Files 
Working with Tables
• Customising Tables  • Table Properties: Formatting  • More Table Properties  • Data Validation and Lookup Wizard 
Working with Forms
• Basic Form Controls  • Advanced Form Controls  • Formatting Your Form  • Formatting Controls  • Using Themes 
Working with Reports
• Organizing Report Data  • Formatting Reports  • Common Report Tasks 
Working with Queries
• Basic Queries  • Doing More with Queries  • Creating Advanced Queries  • Creating Management (Action) Queries 

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.

 

Our Customers Include