Access Intermediate 2003 & 2007

Short course

In Stratford-Upon-Avon

£ 99 + VAT

Description

  • Type

    Short course

  • Level

    Intermediate

  • Location

    Stratford-upon-avon

  • Duration

    1 Day

Course Outcome: Participants will understand the design principles of an Access database. Have designed and created a multi-table database; Participants are encouraged to bring their own databases or proposals to work on during the second half of the day.

Facilities

Location

Start date

Stratford-Upon-Avon (Warwickshire)
See map
The Willows North, Alcester Road, CV37 9QR

Start date

On request

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

Course programme


Access Intermediate 2003 & 2007

About the Course

Who is the course for?
Users who want to set up a relational database. Previous use of databases or attendance of Access Essentials required.
Study Mode
Short Course

Introduction Course Outcome:
Participants will understand the design principles of an Access database.
Have designed and created a multi-table database; Participants are encouraged to bring their own databases or proposals to work on during the second half of the day.

Key Objectives To understand relational database design and functionality; be able to design and test a customised database without the use of Wizards.

Course Units
· Create a multi table databases
· The importance of the Primary Key
· Linking tables with one to one and one to Many relationships;
· Using the Relationship Window
· Creating: Tables, Forms, Queries, Reports without using Wizards and templates
· Form Design Controls. Creating select queries from multiple tables
· Calculate controls in Queries
· Using MailMerge from Access
· Formatting Forms and Reports
· Create sub-forms and sub-reports

Duration 1 day

Tuition Fees(Cost) £99

Progression Route Access Advanced

Access Intermediate 2003 & 2007

£ 99 + VAT