giving people the skills to succeed  
search our website
Courses > IT Courses > Microsoft Access XP Fundamentals
 
   
 
Microsoft Access XP 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
     
Demand led
Call to request dates
     
     
         

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 New Databases & Tables

  • Creating & Saving a Database
  • Creating Tables
 

Modifying Tables & Field Properties

  • 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
 
   

Queries

  • Creating & Running Queries
  • Adding Criteria to Queries
  • Saving the Query – Creating a Dynaset
  • Creating Multi-Table Queries
  • 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
  • Working with Report Sections
  • Form Design vs Report Design
  • White Space
  • Summary Reports
 

Printing in Access

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