Access Intermediate course content

Intermediate Microsoft Access 2010

Microsoft Office Access 2010 IntroductionInstructor-led Access Intermediate Outline

Duration:

Intended audience:

1 day

Anyone who is comfortable and familiar with using Access 2010 at Introduction level and wants to expand their knowledge

Aims:

To enlarge on an Introduction level of knowledge by the use of worked examples

Objectives:

 

By the end of the session delegates will be able to:·

  • Create user forms with advanced functionality
  • Use different types of joins between entities
  • Run various types of query
  • Run reports on multiple tables
  • Add calculated fields
  • Add summary fields
  • Record simple macros and assign them

Prerequisites:

A good knowledge of Access 2010 at Introduction Level

TABLES

Modifying fields

Lookup fields

Validation rules

Input masks

Default values

Mandatory fields

Creating a table

RELATIONSHIPS

Basics of relationships

Types of joins in a relationship

Creating relationships

Applying inner and outer joins

Applying and using referential integrity

Applying automatic deletion of related records

QUERIES

Query types

Grouping information in a query

Using arithmetic or logical expressions in a query

Refining a query

FORMS

Creating bound and unbound controls

Creating a combo box, list box, check box & option groups

Creating arithmetic / logical expression controls

Creating a form using the form wizard

Setting sequential order of controls on a form

Creating form headers or footers

Creating a subform and linking to the main form

Modifying the subform to change records displayed

REPORTS

Creating arithmetic / logical calculation controls

Using formulas and expressions

Creating running summaries

Presentation

Forcing page breaks for groups on report

USING MACROS

Macros

Running a macro

Attaching a macro to a form control

Attaching a macro to a report control

IMPORTING, EXPORTING AND LINKING DATA

Importing from a text file

Importing from an Excel spreadsheet

Exporting data to a text file

Exporting data as an Excel spreadsheet file

Linking to an Excel worksheet

Microsoft Access Intermediate Courses

We have versions for Microsoft Office 2007, Microsoft Office 2010 and Microsoft Office 2013

If you don’t have time to take one of our instructor-led courses, you might enjoy our Access 2010 online e Learning Access 2010 Tutorials instead

Looking for an Access 2010 Introduction course?

Or an Access 2010 Advanced course?