Introduction  Intermediate  Advanced

Access 2010 Introduction

Days of training: 1

COURSE DESCRIPTION

This ILT Series course covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.

PREREQUISITES

To ensure successful completion of this course, we recommend that you have experience in both Microsoft Word and Microsoft Excel.

Getting Started

  • Topic A: Database concepts
  • Topic B: Exploring the Access environment
  • Topic C: Getting help

Database and tables

  • Topic A: Planning and designing databases
  • Topic B: Exploring tables
  • Topic C: Creating tables

Fields and records

  • Topic A: Changing the design of a table
  • Topic B: Finding and editing records
  • Topic C: Organizing records

Data entry rules

  • Topic A: Setting field properties
  • Topic B: Working with input masks
  • Topic C: Setting validation rules

Basic queries

  • Topic A: Creating and using queries
  • Topic B: Modifying query results and queries
  • Topic C: Performing operations in queries

Using forms

  • Topic A: Creating forms
  • Topic B: Using Design view
  • Topic C: Sorting and filtering records

Working with reports

  • Topic A: Creating reports
  • Topic B: Modifying and printing reports

 

Access 2010 Intermediate

Days of training: 1

COURSE DESCRIPTION

This ILT Series course builds on the skills and concepts taught in Access 2010: Introduction. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

PREREQUISITES

A student must have an understanding of the concepts of defining field data types and properties, creating simple criteria queries and creating sorting queries. Students should also have completed Access Introduction.

Relational databases

  • Topic A: Database normalization
  • Topic B: Table relationships
  • Topic C: Referential integrity

Related Tables

  • Topic A: Creating lookup fields
  • Topic B: Modifying lookup fields
  • Topic C: Subdatasheets

Complex Queries

  • Topic A: Joining tables in queries
  • Topic B: Using calculated fields
  • Topic C: Summarizing and grouping values

Advanced form design

  • Topic A: Adding unbound controls
  • Topic B: Graphics
  • Topic C: Adding combo boxes
  • Topic E: Advanced form types

Reports and printing

  • Topic A: Customized headers and footers
  • Topic B: Calculated values
  • Topic C: Printing
  • Topic D: Labels

Charts

  • Topic A: Charts in forms
  • Topic B: Charts in reports

PivotTables and PivotCharts

  • Topic A: PivotTables
  • Topic B: Modifying PivotTables
  • Topic C: PivotCharts
  • Topic D: PivotTable forms

 

Access 2010 Advanced

Days of training: 1

COURSE DESCRIPTION

This ILT Series course builds on the skills and concepts taught in Access 2010: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.

PREREQUISITES

A student must have an understanding of the concepts of modifying and analyzing tables, using controls and layouts, manipulating form controls in design view, using editing tools and advanced report design. Students should also have completed Access Introduction and Intermediate.

Querying with SQL

  • Topic A: SQL and Access
  • Topic B: Writing SQL statements
  • Topic C: Attaching SQL queries to controls

Advanced queries

  • Topic A: Creating crosstab queries
  • Topic B: Creating parameter queries
  • Topic C: Using action queries

Macros

  • Topic A: Creating, running, and modifying macros
  • Topic B: Attaching macros to the events of database objects

Advanced macros

  • Topic A: Creating macros to provide user interaction
  • Topic B: Creating macros that require user input
  • Topic C: Creating AutoKeys and AutoExec macros
  • Topic D: Creating macros for data transfer

Importing, exporting, and linking objects

  • Topic A: Importing objects
  • Topic B: Exporting objects
  • Topic C: Working with XML documents
  • Topic D: Linking Access objects
  • Topic E: Using hyperlink fields

Database management

  • Topic A: Optimizing resources
  • Topic B: Protecting databases
  • Topic C: Setting options and properties