Microsoft Access Introduction

(1)

For further details on this course or any SureSkills training related query, contact us at: | Dublin, +353 1 240 2262 | Austin, +1 855 278 7555 | Belfast, +44 28 9093 5565 |

Microsoft Access Introduction

SSA400: Two Days; Instructorled

Aims

Access is an exciting new database management system from Microsoft designed specifically for a modern graphical environment. The SureSkills.Com Introduction Access course is designed to quickly develop the fundamental skills required to start using Access to a level of competence sufficient for participants to design and construct their own database applications; to be able to view data, extract information and to generate reports.

It is important to note that here at SureSkills the course starts from first principles and leads through the use of the Access package itself but also through the vital database design activities necessary before the construction activity can begin.

Audience

New, recent or intended users of Microsoft Access who have little or no existing database knowledge. The focus of the course is more for those who will be designing and constructing the database rather than those who will be using the developing system.

Prerequisites

A working knowledge of PC’S, Windows and a mouse is assumed. Course Outline

Please click below for a detailed outline for each Access version Access 2000 Introduction

Access XP Introduction Access 2003 Introduction

(2)

Introduction to Access Overview of: • Tables • Queries • Forms • Reports Creating a Database • The Database Window Table Design

• Inserting Fields • Setting a Primary Key • Identify Data Types • Field Properties • Saving a Table Table Datasheet View • Entering Records

• Editing / Deleting Records • Finding Records • Sorting Records Relating Tables • Relationships • Referential Integrity Queries • Select Queries • Setting Criteria • Totals Queries • Saving Queries Forms

• Using the AutoForm • Working in a Form • Changing the Form Design

Reports

• Using the Report Wizard • AutoReport

• Tabular Reports • Groups / Totals Reports Review & Close

(3)

• Introduction to Access • Overview of : -Tables -Queries -Forms -Reports • Creating a Database

• The Database Window

• Table Design

-Inserting Fields -Setting a Primary Key -Identify Data Types -Field Properties -Saving a Table

• Table Datasheet View

-Entering Records -Editing / Deleting Records -Finding Records -Sorting Records

• Relating Tables -Relationships -Referential Integrity • Queries -Select Queries -Setting Criteria -Totals Queries -Saving Queries

• Forms -Using the AutoForm

-Working in a Form -Changing the Form Design

• Reports -Using the Report Wizard

-AutoReport -Tabular Reports

-Groups / Totals Reports • Review & Close

(4)

Introduction to Access Overview of: • Tables • Queries • Forms • Reports Creating a Database

• The Database Window • Table Design

• Inserting Fields • Setting a Primary Key • Identify Data Types • Field Properties • Saving a Table

Table Datasheet View • Entering Records

• Editing / Deleting Records • Finding Records • Sorting Records Relating Tables • Relationships • Referential Integrity Queries • Select Queries • Setting Criteria • Totals Queries • Saving Queries Forms

• Using the AutoForm • Working in a Form • Changing the Form Design

Reports

• Using the Report Wizard • AutoReport

• Tabular Reports • Groups / Totals Reports Review & Close

(5)

• New Features • Introduction to Access • • Overview of: • o Tables • o Queries • o Forms • o Reports • • Creating a Database • o The Database Window • o Table Design • o Inserting Fields • o Setting a Primary Key • o Identify Data Types • o Field Properties • o Saving a Table •

• Table Datasheet View

• o Entering Records • o Editing / Deleting Records • o Finding Records • o Sorting Records • Relating Tables • o Relationships • o Referential Integrity • • Queries • o Select Queries • o Setting Criteria • o Totals Queries • o Saving Queries • • Forms

• o Using the AutoForm • o Working in a Form

• o Changing the Form Design • • Reports • o Using the Report Wizard • o AutoRep ort • o Tabular Reports • o Groups / Totals Reports • Revi ew & Close