Intermediate Microsoft Access 2010 Training Courses

Short course

In Twickenham

£ 295 + VAT

Description

  • Type

    Short course

  • Location

    Twickenham

  • Duration

    1 Day

  • Start date

    Different dates available

This course aims to give delegates a greater understanding of MS Access 2010.

                              

Facilities

Location

Start date

Twickenham (Middlesex)
12 Northcote Road, TW1 1PA

Start date

Different dates availableEnrolment now open

About this course

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

Use field properties for protection
Understand table relationships and referential integrity
Create multi-table queries
Use calculations in a query
Design custom entry forms
Design custom reports

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

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 14 years

Subjects

  • Access
  • Design
  • Database training
  • Database
  • Report Design
  • Form Design
  • Microsoft Access
  • Query Design
  • Table Relationships
  • Fields
  • Hyperlink
  • Currency
  • Editing
  • Multiple values<br /> <br /> <br /> <br />

Course programme

Displaying the Access 2010 database

The Navigation pane, customising the Navigation pane
Database display
Table design - fields

Applying and modifying data types such as text, memo, hyperlink, currency, date and time in a field
Understanding the consequences of modifying data types such as text, memo, hyperlink, currency, date and time in a field
Creating and editing a lookup in a field
Creating and editing a validation rule in a field
Creating and editing an input mask in a field
Applying and modifying default values in a field
Setting a mandatory field
Fields with multiple values
Table Relationships

Understanding the basis for creating a valid relationship
Creating a one-to-one or a one-to-may relationship between tables
Understanding and modifying a many-to-many relationship between tables
Applying inner, outer and self joins
Applying and using referential integrity
Applying automatic deletion of related records
Relating or joining data when designing records
Adding fields to tables
Field templates
Microsoft Access Query design

Grouping information in a query
Using a crosstab query
Using wildcards in a query
Using arithmetic and logical expressions in a query
Form design

Using bound and unbound controls
Creating and editing a combo box, list box, check box and option groups
Inserting a data field to appear within form header or footer on the first page or all pages
Stacked and tabular layout controls
Report design

Inserting a data field to appear within report header or on footers on the first page or all pages
Forcing page breaks for groups on reports
Importing, exporting and linking data

Importing text, Excel, csv, dBASE or Paradox documents into an Access 2010 database
Exporting data in Excel, txt, dBASE and Paradox formats
Linking external data to an Access 2010 database

Additional information

Course Type Cost per day
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT

Intermediate Microsoft Access 2010 Training Courses

£ 295 + VAT