Access Advanced

Access Advanced

Duration:
2 Days
Aims:

This course is designed to provide attendees with an understanding of the data analysis and reporting functionality with Access. It will benefit individuals who wish to create queries, build forms reports and macros.

Objectives:

On completion of this course, attendees will be able to create select, multi table, calculative and action queries. Attendees will also learn how to present this data by designing professional reports and forms and create macros.

Pre-Requistites

Attendees need to have attended the Access Foundation course or have equivalent knowledge.

Versions

Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
Structuring Existing Data
  • - Analyse tables
  • - Create a junction table for many to many relationships
  • - Improve the table structure
Action Queries
  • - Make table queries
  • - Delete queries
  • - Append queries
  • - Update queries
Creating Advanced Queries
  • - Create Parameter queries
  • - Inner and outer joins
  • - Group and summarise records using criteria
  • - Create Unmatched and Duplicate Queries
  • - Calculated queries
  • - Summarize data using a Crosstab query
Improving Forms
  • - Working with properties
  • - Using unbound and bound controls
  • - Restrict Data Entry in Forms
  • -
  • - Organize Information with Tab Pages
  • - Add a Command Button to a Form
  • - Create a Subform
  • - Display a Summary of Data in a Form
  • - Change the Display of Data Conditionally
Customising Reports
  • - Organize Report Information
  • - Format Reports
  • - Control Report Pagination
  • - Summarize Report Information
  • - Add a Subreport to an Existing Report
  • - Create a Mailing Label Report
  • - Include a Chart in a Report
  • - Publish Reports as PDF
Introduction to Macros
  • - Create a Macro
  • - Attach a Macro
  • - Restrict Reports Using a Condition
  • - Validate Data Using a Macro
  • - Automate Data Entry Using a Macro
Maintaining an Access Database
  • - Link Tables to External Data Sources
  • - Manage a Database
  • - Determine Object Dependency
  • - Document a Database
  • - Analyse the Performance of a Database
Integrating Access into your Business
  • - Import XML Data into an Access Database
  • - Export Access Data to the XML Format
  • - Integrating Access with Email - broad concepts
Managing Switchboards
  • - Create a Database Switchboard
  • - Modify a Database Switchboard
  • - Set the Startup Options
Distributing and Securing Databases
  • - Split a Database
  • - Locating Front and Back End components
  • - Maintaining a Split Database
  • - Implement Security
Related courses
Run this
course at
your offices
Request a quote
Speak to a friendly advisor

call

0333 344 6630

or visit our

Online Chat
Trustpilot