Microsoft Access 2003 Foundation
Training Course Outline

1-day course

This course includes the following topics:

Getting started

Database concepts

A-1: Identifying database components

A-2: Identifying the advantages of relational databases

 

Exploring the Access environment

B-1: Starting Access and examining the Access window

B-2: Opening a database

B-3: Examining the Database window

B-4: Examining a database table

Getting help

C-1: Using the Type a question for help box

C-2: Using the Office Assistant

Closing a database and Access

D-1: Closing a database and Access

 

Databases and tables

Planning and designing databases

A-1: Planning a database

A-2: Using the Database Wizard

A-3: Creating a blank database

Exploring tables

B-1: Discussing views

B-2: Examining a table in Datasheet view

B-3: Navigating in a table in Datasheet view

B-4: Examining a table in Design view

Creating tables

C-1: Creating a table by using the Table Wizard

C-2: Creating a table in Design view

C-3: Adding fields and descriptions to a table

C-4: Setting the primary key

C-5: Saving the design and viewing the table

C-6: Adding a record

 

Fields and records

Topic A: Changing the design of a table

A-1: Modifying field names

A-2: Deleting and inserting fields

A-3: Moving a field

Topic B: Finding and editing records

B-1: Finding and replacing a value

B-2: Undoing changes

B-3: Using the spelling checker

Topic C:Organizing records

C-1: Sorting records by a single field

C-2: Sorting records by multiple fields

C-3: Using Filter By Selection

C-4: Using Filter By Form

C-5: Using Filter Excluding Selection

C-6: Using Advanced Filter/Sort

C-7: Deleting a record

 

Data entry rules

Topic A: Setting field properties

A-1: Setting the Required property

A-2: Using the AllowZeroLength property

A-3: Setting the FieldSize property

A-4: Setting the SmartTags property

Topic B:Working with input masks

B-1: Creating an input mask

B-2: Working with the Input Mask Wizard

Topic C Setting validation rules

C-1: Setting default values

C-2: Creating validation rules

C-3: Setting validation text

Topic D:Using indexes

D-1: Creating a single-field index

D-2: Creating a multiple-field index

 

Simple queries

Topic A: Creating and using queries

A-1: Planning a query

A-2: Using the Simple Query Wizard

A-3: Creating a query in Design view

A-4: Saving and running the query

A-5: Sorting query results

A-6: Filtering query results

Topic B: Modifying query results and queries

B-1: Editing query results

B-2: Adding fields to a query

B-3: Removing fields from a query

B-4: Finding records with empty fields

Topic C: Performing operations in queries

C-1: Using comparison operators

C-2: Using the OR condition

C-3: Using the AND condition

C-4: Using the * wildcard

C-5: Using calculations in a query

C-6: Totaling a group of records

C-7: Using the Avg and Count functions

 

Unit 6 : Using forms

Topic A: Creating forms

A-1: Examining a form

A-2: Creating a form by using AutoForm

A-3: Using the navigation bar

A-4: Using a form for data entry

Topic B: Using the Form Wizard

B-1: Creating a form by using the Form Wizard

Topic C: Using Design view

C-1: Creating a form in Design view

C-2: Adding a title to a form

C-3: Adding controls

C-4: Modifying properties

C-5: Inheriting properties

Topic D:Finding, sorting, and filtering records

D-1: Using a form to find records

D-2: Using a form to sort records

D-3: Using a form to filter records

 

Unit 7 : Working with reports

Topic A: Creating reports

A-1: Examining a report

A-2: Creating reports by using AutoReport

A-3: Creating reports by using the Report Wizard

A-4: Creating a report by using Design view

A-5: Creating a report by using a query

Topic B: 0 Modifying and printing reports

B-1: Modifying a report in Design view

B-2: Grouping information in a report

B-3: Checking errors in reports

B-4: Adding summary fields by using the Report Wizard

B-5: Modifying the layout and style of a report

B-6: Changing field properties

B-7: Printing a report

   

 

For further details, or to book a course, please contact us:
email:        training@ictwizard.com
telephone:  01382 453447
 

Our Access courses include:

Microsoft Access 2010 Foundation
 
Microsoft Access 2010 Intermediate
 
Microsoft Access 2010 Advanced
 
Microsoft Access 2007 Foundation
 
Microsoft Access 2007 Intermediate
 
Microsoft Access 2007 Advanced
 
Microsoft Access 2003 Foundation
 
Microsoft Access 2003 Intermediate
 
Microsoft Access 2003 Advanced
 
Access VBA

 

Microsoft Access Training Courses in Edinburgh

Microsoft Access Training Courses in Glasgow

Microsoft Access Training Courses in Dundee

Microsoft Access Training Courses in Perth

Microsoft Access Training Courses in Aberdeen

Microsoft Access Training Courses in Inverness

Microsoft Access Training Courses in Fife

Microsoft Access Training Courses London

... and at many more locations throughout the UK

ICT Wizard courses:

Other ICT Wizard courses:

Excel Courses
Microsoft Office 2010
VBA
Visio Courses
Microsoft Office - all versions
Microsoft Outlook
SharePoint
Microsoft Project
Presentations
Microsoft PowerPoint
Internet
Word Courses
Introduction to Computing
Microsoft Publisher
Windows
Adobe Acrobat
Expression Web
InfoPath
OneNote
... and others

 

• on your site or locations throughout the UK
• Computer training courses in Aberdeen, Dundee, Glasgow, Edinburgh and London
• delivered by Certified Master Instructors.