Access 2010 Course Overview

overview

Make more informed decisions by effectively tracking, reporting, and sharing information using Microsoft Access 2010. InterAction courses are packed with practical lessons and simulation that were developed in Australia - so yes you will be listening to Australian voices! Now you can access the same self-paced learning InterAction has been delivering to Corporate and Government organisations across the world for 25 years. Up to 85% of our screens are interactive, ensuring that you are constantly involved and thus motivated to learn. You can also start by completing an optional interactive pre-test which identifies any skills gaps you may have, and then recommends the most appropriate modules that you need to concentrate on to round off your knowledge. If you are an intermediate or advanced user, you will be directed to the specific topics that will supplement your existing knowledge.

Audience

You might be a new, intermediate or power user, or a user migrating from an earlier version. We assume that you also have the basics of operating your PC and Windows.

Learn To

Key Concepts

Key Concepts of Database Technology

What is a Database?

Data and Information

Types of Databases

Tables, Records and Fields

Common Database Uses

Database Organisation

Database Organisation

Field Data Types

Field Properties

Primary Keys

Database Relationships and Operation

Database Relationships and Operation

Table Relationships

Displaying Table Relationships

Selecting the Tables

Creating a Relationship

Relationship Types

Referential Integrity

Editing and Printing Relationships

Displaying Subdatasheets

Identifying Relationships

Operations

Database Administrators

Users

Working with Databases

Starting Access

Locate Templates

Online Templates

Open Recent Databases

Access Help Options

Creating a Database

The Office Menu

The Navigation Pane

Hiding the Navigation Pane

The Ribbon

Quick Access Toolbar

Contextual Tabs

The Status Bar

Opening Databases

Open List Button

Recently Opened Databases

Closing Access

Common Database Tasks

Common Database Tasks

The Navigation Pane and Access Objects

Database Tables

Table Navigation Buttons

Sorting the Table

Saving the Table

The Table in Design View

Using Forms

Form Navigation Buttons

Sorting in Forms

Changing View in Forms

Saving the Form

Closing a Form

Reports

Previewing a Report

Changing View in a Report

Sorting in a Report

Saving the Report

Queries

Queries In Design View

Sorting Data in Queries

Running a Query

Save and Close the Query

Deleting Objects

Customising the Navigation Bar

Creating Navigation Bar Categories

Assigning Objects

Closing Access

Working with Records

Working with Records

Adding Data into Records

Adding a New Record

Table Navigation Buttons

The Scroll Bars

Freeze Columns

Enhancing Tables

Changing Text Alignment

Changing Column Width and Row Height

Copy, Cut and Paste

Editing Records

Deleting Records

Table Design

Table Design

Creating a New Table

Saving and Naming the Table

Displaying the Table in Design View

Adding New Fields

Adding a Yes/No Field

Field Names

Changing the Primary Key

Setting the Data Type

The Description Column

Setting Field Properties

Format Properties

Input Mask

The Caption Field Property

Default Value Property

Validation Rule and Validation Text

Required and Allow Zero Length

Indexing a Field

The Lookup Wizard

Setting a Validation Rule

Adding a Field to a Table

Applying Field Properties to a Number Field

Create a Validation Rule using the Expression Builder

Setting a Field to Require an Entry

Adding a Date/Time Field to a Table

Applying Field Properties to a Date/Time Field

Creating a Validation Rule using Built in Functions

Saving the Design Changes

Changing Column Width and Row Height

Main Operations for Retrieving Information

Basics of Retrieving Information

Finding Records

Finding Numeric Data

Finding Dates

Filtering Data

Filter by Selection

Filtering using the Field list button

Filter by Form

Removing the Application of a Filter

Closing a Table

Filtering Data in Forms

Clearing All Filters

Queries

Creating a Select Query

Individually Adding Fields

Running a Query

Saving a Query

Closing a Query

Multiple Table Queries

Joining Tables in a Query

Adding Fields to the Grid

Running the Query

The Query in SQL View

Adding Selection Criteria

Using Logical Operators

Returning to Design View

Using the Or Operator

Using the Or Operator

The Like Operator and Wildcard Characters

Hiding Query Fields

Action and Crosstab Queries

Action and Crosstab Queries

The Make Table Query

Update Query

Append Query

Crosstab Query

Working with Forms

Working with Forms

Form Creation Options

The Form Wizard

Adding Fields

Selecting the Form Layout

Selecting the Form Style

Displaying the Form

Moving in a Record

Adding a New Record to a Form

Entering Data in a Form

Editing Records in a Form

Deleting Records

Modifying Forms

Form Design Screen Sections

Changing the Section Sizes

What are Controls on a Form?

Editing the Form Header

Editing the Form Footer

Formatting the Header and Footer

Changing a Label's Font

Changing the Font Size

Label Formatting

Saving the Form

Personalising Forms

Personalising Forms

Form Design Screen Sections

Changing the Section Sizes

What are Controls on a Form?

Selecting Controls

Unstacking Fields

Re-sizing a Text Box

Moving a Field

The Undo Button

Selecting Several Controls

De-selecting a Control

Adding a Field to the Form

Deleting Controls

Calculated Controls

Changing a Label Name

Displaying the Field Properties

Changing the Tab Order

Applying AutoFormats

Using the Format Painter

Changing to Form View

AutoFormat

Fine Tuning the Form

Reporting and Data Export

Reporting and Data Export

Creating a Report

Selecting a Table or Query

Adding Fields to a Report

Grouping Report Records

Sort and Summary Options

Layout and Orientation

Selecting a Report Style and Report Title

Displaying the Report

Design View

Numeric Formatting

Group Header and Footer

Page Header and Footer

Report Header and Footer

Arrange Data Fields and Headings

Adding Functions

The Count Function

Exporting Data to Excel

Exporting Data to XML

Exporting Data to a Text File

Printing

Previewing Queries

Printing Queries

Previewing Forms

Printing Forms

Previewing Tables

Printing Tables

Moving Around the Report

Zoom Options

The Page Setup Box

Changing Margins

Changing Page Orientation

Printing the Report