Tools
You are here: Home » Microsoft » Access » Microsoft Access 2013 » Microsoft Access v2013 Advanced
Friday, 20 Apr 2018

Microsoft Access v2013 Advanced

Course Objectives

This course will cover most of the advanced commands including advanced queries, forms and reports. An overview of macros will be shown. Access Basic will not be covered.

Who Should Attend?

Those who have used Access and who require a review of Access advanced facilities. Previous experience of using Access at an introductory level will be assumed. Delegates with no previous experience of Access should first attend our "Introduction to Microsoft Office Access 2013" Course.

Course Contents

A review of basics.

Queries.

  • Parameters
  • Calculated fields
  • Cross tabs
  • Summaries
  • Action Queries
  • Linking tables

Forms.

  • Using the form toolbox
  • Advanced Form Design
  • One to Many Forms

Relationships.

  • Theory
  • Practical Applications
  • Referential Integrity

Reports.

  • Advanced Design
  • Using linked tables
  • Using parameter queries

Macros.

  • Buttons and Forms
  • Utility macros
  • Introduction to "Front Ends"

Microsoft Access 2013 Course DetailsDownload Course Details

Event Properties

Event date: 10-04-2018 09:30 AM
Event end date: 10-04-2018 05:00 PM
Individual Price £150.00
Location AJP IT Services
Please phone us on 0117 929 1509 to book this course