0845 450 6120

Microsoft Access 2013 Advanced

You've covered many of the basic functions of Microsoft Access and now you're ready to learn advanced Access features such as: database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.


Target audience

Your training in and use of Microsoft Access 2013 has provided you with a solid foundation in the basic and intermediate skills. You have worked with the various Access objects, such as tables, queries, forms and reports.

 

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

 

We don't currently have any courses listed for Microsoft Access 2013 Advanced, would you like to view all courses for Microsoft Office?

Learning Objectives

  • Restructure data into appropriate tables to ensure data dependency and minimise redundancy
  • Write advanced queries to analyse and summarise data
  • Create and revise Access 2013 macros
  • Customise reports by using various Access 2013 features
  • Maintain their databases using tools provided by Access 2013

Pre-Requisites

  • Understand the steps required to properly design a database
  • Create a database
  • Create tables and table relationships
  • Control data entry with field properties
  • Create queries and understand query joins
  • Create reports and subreports
  • Add and format controls on forms and reports
  • Import and export data

Course Content

Lesson 1: Structuring Existing Data

  • Topic 1A: Restructure the Data in a Table
  • Topic 1B: Create a Junction Table
  • Topic 1C: Improve the Table Structure

Lesson 2: Writing Advanced Queries

  • Topic 2A: Create SubQueries
  • Topic 2B: Create Unmatched and Duplicate Queries
  • Topic 2C: Group and Summarise Records Using Criteria
  • Topic 2D: Summarise Data Using a Crosstab Query
  • Topic 2E: Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros

  • Topic 3A: Create a Macro
  • Topic 3B: Attach a Macro
  • Topic 3C: Restrict Records Using a Condition
  • Topic 3D: Validate Data Using a Macro
  • Topic 3E: Automate Data Entry Using a Macro

Lesson 4: Creating Effective Reports

  • Topic 4A: Include a Chart in a Report
  • Topic 4B: Print Data in Columns
  • Topic 4C: Cancel Printing of a Blank Report
  • Topic 4D: Publish Reports as PDF

Lesson 5: Maintaining an Access Database

  • Topic 5A: Link Tables to External Data Sources
  • Topic 5B: Manage a Database
  • Topic 5C: Determine Object Dependency
  • Topic 5D: Document a Database
  • Topic 5E: Analyse the Performance of a Database
One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include