Microsoft Access Intermediate (Level 2) 2003 2007 2010 2013 2016 & 365

Training

In Newcastle Upon Tyne

£ 165 VAT exempt

Description

  • Type

    Training

  • Level

    Intermediate

  • Location

    Newcastle upon tyne

  • Duration

    1 Day

Become proficient with Microsoft Access by completing this one day course. Individuals will learn more techniques to use with Microsoft Access. These include linking tables, update queries and simple macros.

Important information

Documents

  • Course content

Facilities

Location

Start date

Newcastle Upon Tyne (Tyne and Wear)
See map
The Quadrus Centre, Woodstock Way, Boldon, NE35 9PF

Start date

On request

About this course

Learn all the functions that Microsoft Access has to offer at intermediate level.

The course is intended for individuals who have some previous experience in Microsoft Access.

Some previous Microsoft Access experience is required.

Certificate of participation can be obtained if required.

On receiving your request we will contact you to explain course content, including course dates and payment options.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Access
  • Microsoft Access
  • Datasheets
  • Custom Reports
  • Action Queries
  • Macro Design
  • Tables
  • Macros
  • Forms
  • Custom Forms
  • Sorting and Grouping

Teachers and trainers (1)

Chris Edmondson

Chris Edmondson

IT Trainer

Course programme

Course review:

1 Revision

  • Topics from the Introduction day
  • Revision Exercise

2 More about Datasheets

  • Finding Information in a Datasheet
  • Replacing Information
  • Sorting in a Datasheet
  • Filtering for Ad-hoc enquiries

3 Relationships between Tables

  • The Northwind Sample Database
  • Understanding Links
  • Multi-Table Queries
  • Creating the Relationships

4 Custom Forms

  • Starting from Scratch
  • Control Properties
  • Using List / Combo Boxes
  • Check Boxes / Option Buttons
  • Calculations on a Form

5 Custom Reports

  • Starting from Scratch
  • Sorting and Grouping
  • The Control Types to be Used

6 Action Queries

  • Make Table Queries
  • Append Queries
  • Delete Queries
  • Update Queries

7 Macro Design

  • Creating a Macro
  • The Macro Design Window
  • Saving and Running the Macro

Microsoft Access Intermediate (Level 2) 2003 2007 2010 2013 2016 & 365

£ 165 VAT exempt