© Middlesex ITeC Ltd 2020  Registered in England No. 1707396    Charity No. 1015309

Microsoft Access 2010

Course Overview

The typical candidate for the course works as a user support professional, trainer, teacher, professor, database user, or database creator who needs to create or maintain a basic Access database. Users can create, modify, and extend functionality of basic database objects, including tables, queries, forms, and reports. Users can also construct and modify basic relationships among database entities and can instruct others in basic Access functionality and usage. candidate for the course works as a user support professional, trainer, teacher, professor, database user, or database creator who needs to create or maintain a basic Access database. Users can create, modify, and extend functionality of basic database objects, including tables, queries, forms, and reports. Users can also construct and modify basic relationships among database entities and can instruct others in basic Access functionality and usage.

Managing the Access Environment

Create and manage a database

Configure the Navigation Pane

Apply Application Parts

Building Tables

Create tables

Create and modify fields

Sort and filter records

Set relationships

Import data from a single data file

Building Forms

Create forms

Apply Form Design Tab and arrange tab options

Apply Form Format Tab options

Creating and Managing Queries

Construct queries

Manage source tables and relationships

Manipulate fields

Calculate totals

Generate calculated fields

Designing Reports

Create reports

Apply Report Design Tab options

Apply Report Arrange Tab options

Apply Report Page Setup Tab options

Sort and filter records for reporting