Advanced Access 2013 Training Provisional Course Outline

Aims of the Advanced Access 2013 Training course

This Advanced Access 2013 training course aims to give delegates an insight into some of the more advanced features in MS Access 2013.

Course Objectives

On completion of the course delegates will have added to their skills in using Microsoft Access. They will be able to:

  • Normalise data tables
  • Use advanced forms features
  • Use Access in conjunction with the Internet
  • Create advanced queries
  • Produce reports
  • Record and assign macros

The Microsoft Advanced Access 2013 training course is of one day’s duration.

How the course is run – This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites – Familiarity with the Windows environment, and a reasonable knowledge of Access 2013. Prior attendance of the Intermediate Access 2013 course would be an advantage.

Course Outline

Database Design

  • Concepts of Normalisation
  • Junction Tables
  • Microsoft Access naming conventions
  • Indexes
  • Multiple Field Primary keys
  • Data Validation
  • Table Level Validation
  • Field types
  • Join types
  • Lookup fields

Query Types

  • Parameter queries
  • Summary queries
  • Joining tables in queries
  • Cross Products
  • Creating reverse outer joins
  • Concatenation
  • Creating and using a query to update data in a table
  • Creating and using a query to delete records in a table
  • Creating and using a query to save the selected information as a table
  • Appending records to a table using a query

Refining Queries

  • Backing up your database
  • Showing duplicates
  • Showing unmatched values
  • Showing the highest or lowest range of values in a query
  • Parameter queries – allowing query input from a data prompt
  • Refining queries using Null and NOT values
  • IIF Functions
  • Calculating with Dates
  • Querying multivalue fields

Advanced Forms

  • Creating arithmetic and logical expression controls on a form
  • Adding graphics to forms
  • Setting sequential order of controls on a form
  • Creating a subform and linking it to parent
  • Modifying the subform to change records displayed
  • Split forms
  • Creating a Switchboard form

Access 2013 and the Internet

  • How Access 2013 works with the Web
  • Hyperlinks
  • Exporting database object to HTML
  • Importing or linking to an HTML file

Calculations in Reports

  • Applying sorting and grouping to reports
  • Creating arithmetic and logical expression controls in a report
  • Calculating percentages in a report
  • Using formulas and expressions in a report such as sum, count, average, max, min, concatenate
  • Creating running summaries in a report

Macros

  • Recording a simple macro
  • Running a macro
  • Assigning or attaching a macro to a form, report, control
  • Creating an Autoexec macro

Database Management

  • Analysing Performance
  • Compacting and Repairing Databases
  • The Database documenter
  • The Database splitter