giving people the skills to succeed  
search our website
Courses > IT Courses > Microsoft Access 2010 Fundamentals
 
   
 
Microsoft Access 2010 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 with either Word or Excel would be useful, but is not essential.

 
   
 
       
     
  Duration: 2 Days
  Cost: £250 + VAT
     
 
  Course Date Location
  16/04/2012 Liverpool
  23/04/2012 Bradford
  09/07/2012 Liverpool
  12/07/2012 Bradford
  22/10/2012 Bradford
  25/10/2012 Liverpool
     
 
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
  • Relationships Explained
  • 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
  • Multi-Table Queries
  • Setting Field Properties
 
Forms
  • Creating Forms Using the Form Wizard
  • Multi-Table Forms
  • Designing Forms
  • Formatting Controls
  • 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