Microsoft Access 2007 - Intermediate

Short course

In Carlisle

Price on request

Description

  • Type

    Short course

  • Location

    Carlisle

  • Duration

    1 Day

Facilities

Location

Start date

Carlisle (Cumbria)
See map
1b South Mill, Warwick Mill, Warwick Bridge, CA4 8RR

Start date

On request

About this course

Course delegates would be expected to have basic IT skills and have used Access at least in a data input role. They would also need to understand the basic concepts of a database i.e. tables, records and fields.

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

  • Microsoft Access

Course programme

Course Content

This one day course covers the following topics:-

Advanced queries:
Sum, Count, Group By, Average Values, Maximum and Minimum Values, Calculated Fields in Queries and Parameter queries

Relationships:
Applying a Primary Key, Applying Relationships, Referential Integrity, Updating and Deleting records and Viewing a Subdatasheet

Table Field Properties:
Lookup fields, Format Field Properties, Default Values, Validation Rules and Text, Input Masks, Other Field Properties and Autonumber

Advanced Forms:
Main/Subforms Form Wizard, Main/Subform Subform Wizard and Multiple Table Forms

Microsoft Access 2007 - Intermediate

Price on request