giving people the skills to succeed  
search our website
Courses > IT Courses > Microsoft Access 2003 Fundamentals
 
   
 
Microsoft Access 2003 Fundamentals
 
Target Audience:  

Users who need to design and create basic databases in Microsoft Access.

 
   
Objectives:  

By the end of the course, users will be familiar with the concepts of a relational database and be able to create a multi-table database.  They will be able to interrogate and present data using queries and reports and create simple Access Forms to view and input data on screen.

 
   
Prerequisites:  

Users must be proficient with a mouse and keyboard and be able to confidently work within a Windows environment - minimise, maximise, open, close. Familiarity of either Word or Excel is useful, but not essential.

 
   
 
       
     
  Duration: 2 Days
  Cost: £250 + VAT
     
 
  Course Date Location
  06/02/2012 Liverpool
  27/02/2012 Bradford
  29/05/2012 Liverpool
  07/06/2012 Bradford
  30/08/2012 Liverpool
  03/09/2012 Bradford
  05/11/2012 Liverpool
  20/12/2012 Bradford
     
         

Database Basics

  • The Access Objects
  • What is a Relational Database?
  • Database Design Techniques
  • Navigating the Database Window
 

Navigating & Data Entry

  • Opening Tables
  • Navigating in Datasheet View
  • Adding & Deleting Records
  • Selecting in a Table
 

Creating Databases & Defining Tables

  • Creating & Saving a Database

  • Creating Tables

  • Inserting, Deleting & Moving a Field

  • Changing the Data Type

  • Modifying Field Properties

 

Relationships & Look-Ups

  • Setting a Primary Key
  • Creating a Relationship
  • About Look-Ups
  • Referential Integrity
 

Working with Data in Tables

  • Changing the Look of Data
  • Sorting in Tables
  • Formatting Datasheet View
  • Filtering Data
  • Searching Tables
 
   

Queries

  • Creating & Running Queries
  • Adding Criteria to Queries
  • Saving the Query – Creating a Dynaset
  • Creating Multi-Table Queries
  • Setting Field Properties
 

Forms

  • Creating Forms Using the Form Wizard
  • Multi-Table Forms
  • Designing & Formatting Forms
  • Control Properties
 

Reports

  • Creating Reports using Report Wizard
  • Creating Mailing Labels
  • Report Sections
  • Form Design vs Report Design
  • White Space
  • Summary Reports
 

Printing in Access

  • Printing from Tables & Queries
  • Printing a Form
  • Printing Reports