Microsoft Access 2010: A Case Approach, Complete / Edition 1

Table of Contents

Access 2010 Complete

Lab 1 Creating a Database

Designing a New Database

Creating a New Database

Creating a Table

Modifying Field Properties

Entering and Editing Records

Changing Column Width

Navigating Among Records

Deleting Records

Creating a Table in Design View

Creating Relationships

Setting Database and Object Properties

Previewing and Printing a Table

Closing and Opening a Database

Exiting Access

Lab 2 Modifying and Filtering a Table and Creating a Form Customising Fields

Hiding and Redisplaying Fields

Creating a Lookup Field

Searching, Finding and Replacing Data

Sorting Records

Formatting the Datasheet

Filtering a Table

Creating a Simple Form

Modifying a Form

Using a Form

Organising the Navigation Pane

Previewing and Printing a Form

Identiying Object Dependencies

Lab 3 Querying Tables and Creating Reports

Refining the Database Design

Defining and Modifying Relationships

Creating a Query

Displaying a Totals Row

Creating Reports

Preparing Reports for Printing

Compacting and Backing Up the Database

Working Together 1 Exporting Data

Exporting Data

Lab 4 Importing and Querying Tables

Importing Data

Controlling Field Input

Using Action Queries

Using Memo Fields

Adding a Multivalued Field

Using Calculations in Tables and Queries

Creating a Top-Values Query

Creating a Crosstab Query

Lab 5 Creating Custom Forms

Creating a Split Form

Creating a Datasheet Form and Subform

Creating a Form for Multiple Tables

Changing Control Properties

Adding Label Controls

Enhancing Form Controls

Aligning and Spacing Controls

Adding Subforms

Setting Tab Order

Using Command Buttons

Creating Page Headers and Footers

Previewing a Form

Deleting a Form

Lab 6 Creating Custom Reports, Charts, Pivot Charts and Mailing Lables

Creating a Grouped Report

Using the Report Wizard to Create a Grouped Report

Customising the Report Layout

Enhancing the Report

Changing the Record Source

Using Calculated Controls in a Report

Applying Conditional Formatting

Printing a Grouped Report

Creating a Chart in a Report

Using Pivot Chart View

Creating Mailing Labels

Creating a Startup Display Form

Securing a Database

Working Together 2: Linking and Splitting Databases

Linking to External Data Sources

Splitting a Database

Read More