Microsoft Access - 3 Days

DAY 1

INTRODUCTION

GETTING STARTED

  • What is Access?

  • Starting Access

  • The Access Application Window

  • Working With Access Menus

  • Basic Access Terminology

  • Examining Access Objects

  • Resetting the Database Folder

  • Displaying Help Information

  • Exiting from Access

SETTING UP A NEW DATABASE

  • Designing a New Database

  • Creating a New Database

  • Creating a New Table

  • Entering Records in Datasheet View

  • Printing the Datasheet of a Table

  • Navigating Through Records in

  • Closing a Table / Closing a Database

CREATING A FORM / MANIPULATING DATA

  • Reopening a Database / Reopening

  • Creating a Form

  • Navigating Through Records in Closing a Form

  • Reopening a Form

  • Switching Between Form View View

  • Entering Records in Form View

  • Editing Records in Datasheet View View 

  •       / Using the Find Feature

  • Deleting Records in Datasheet View View

  • Modifying the Datasheet View of a Table

  • Sorting the Records in a Table

DISPLAYING SELECTED RECORDS

  • Creating and Applying a Filter

  • Creating and Running a Query

  • Modifying a Query

  • Including a Numeric Condition in a Query

  • Including a Calculated Field in a Query

CREATING A REPORT

  • Creating a Simple Tabular Report

  • Creating a Grouped Tabular Report

  • Modifying a Report

ADDITIONAL ACCESS FEATURES

  • Using the Spelling Checker

  • Copying, Renaming and Deleting Database Objects

  • Importing Spreadsheet Data into an Access Table

DAY 2

INTRODUCTION

MODIFYING THE DESIGN OF A TABLE

  • Displaying a Table in Design View

  • Specifying a Required Field / Defining a Default Field Value

  • Setting a Primary Key for a Table

  • Adding a Memo Field to a Table

  • Additional Table Design Topics

WORKING WITH MULTIPLE TABLES

  • Displaying Multiple Tables on the Access Desktop

  • Resizing and Repositioning the Table Window

RELATING TABLES

  • Creating a Relationship Between Two Tables

  • Displaying and Using a Subdatasheet

  • Creating a Report of Database Relationships

WORKING WITH A CUSTOM FORM

  • Introduction

  • Designing a Custom Form

  • Adding a Header and Footer to a Form

  • Adding a Calculated Control to a Form

  • Using a Custom Form to Enter Data

INTERMEDIATE QUERY TECHNIQUES

  • Extracting Information from Multiple Tables

INTERMEDIATE REPORT TECHNIQUES

  • Creating a Report of Information in Multiple Tables

  • Adding a Calculated Control to a Report

  • Adding a Cover Sheet to a Report

  • Creating a Mailing Label Report

USING ACCESS INTERNET FEATURES

  • Accessing the World Wide Web from the Access Application Window

  • Linking an Access Object to a Web Page

  • Exporting an Access Object to an HTML File

ADDITIONAL INTERMEDIATE ACCESS FEATURES

  • Using a Database Wizard

  • Compacting and Repairing a Database

  • Backing Up and Restoring a Database

  • Using the Office Clipboard

Day 3

INTRODUCTION

ADVANCED TABLE DESIGN TECHNIQUES

  • Validating Field Entries

  • Creating a Lookup Field

  • Additional Table Design Topics

ADVANCED FORM TECHNIQUES

  • Creating a Master-Detail Form

  • Adding a Picture to a Form

  • Displaying the Current Date on a Form

  • Modifying Form Properties

REPRESENTING DATA IN A CHART

  • Creating a Chart

  • Modifying a Chart

ADVANCED QUERY TECHNIQUES

  • Including Multiple Conditions in a Query

  • Creating a Parameter Query

  • Creating a Query to Generate Summary Info

  • Creating an Action Query

  • Changing the Join Type in a Query

  • Modifying Query Properties

  • Optimizing Query Performance with Indexes

ADVANCED REPORT TECHNIQUES

  • Creating a Master-Detail Report

  • Completing the Report

  • Modifying Report Properties

  • Adding a Picture to a Report

WORKING WITH DATA ACCESS PAGES

  • What is a Data Access Page?

  • Creating a Data Access Page

  • Adding a Grouping Level to a Data Access Page

  • Adding a Hyperlink to a Data Access Page

TRANSFERRING DATA BETWEEN ACCESS AND OTHER APPLICATIONS

  • Exporting an Access Datasheet to Excel

  • Linking or Embedding External Data in an Access Form or Report

WORKING WITH MACROS

  • What is a Macro?

  • Creating a Database Macro

  • Running a Database Macro

  • Creating and Running a Command Button Macro

USING TOOLS MENU OPTIONS

  • Using the Table Analyzer Wizard and the Performance Analyzer

  • Using the Database Splitter Wizard and the Linked Table Manager

  • Setting Database Startup Options     

  • Setting a Database Password

  • Additional Tools Menu Options

ADDITIONAL ADVANCED ACCESS FEATURES

  • Creating a Many-to-Many Relationship

  • Creating a One-to-One Relationship

  • Creating a Switchboard