Course Overview

This Access course enables delegates to progress from the one level databases associated with holding data in Microsoft Excel, to multiple table relational databases, covering all the basics including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.

Prerequisites

• • Delegates should be familiar with using a computer and have used a mouse and keyboard. Familiarity with the list-related tools in Microsoft Excel such as sorting and filtering would be beneficial.
    

Course Content

• Database theory

  Explanation of the components that make up a database
  

• Tables

  Table creation methods
  Primary Keys
  Choosing data types
  Field properties and Validation options
  Adding a Lookup field to a table, exploring different methods
  

• Relationships

  Understanding Normalisation and Table structure
  Deciding on the correct Relationship type and understanding the options available
  Creating links between Tables
  When to use Referential Integrity and cascade / delete related records

• Queries

  Creating a selection query using the Query-By-Example Window (QBE)
  Specifying criteria with wildcards, how to filter the data to show just what you want
  Sorting the results of a query by one or more fields
  Using multiple criteria with And and Or
  Changing the join type of the relationship between tables of a query
  Parameter queries, supplying the criteria for a query at run time
  Calculations in queries
  Joining/Editing fields in queries

• Forms

  Understanding the use of Forms
  Methods for Form creation
  Exploring the Form properties
  Setting data sources. How to change where a form gets its data from.
  Controlling layout using Tables
  Adding a Form header or footer
  Drop down list boxes in a form
  Option boxes and Yes / No boxes
  Adding text boxes and Pictures
  Tab order. Controls which text box will get the focus when the user presses the TAB key on the keyboard.
  Creating a Sub Form. A sub form allows the user to see records related to the main form that are held in another table
  Creating Tabbed Forms. Split your form into overlapping sections, to make it easier to use.
  Viewing and changing data in your database using forms
  Adding buttons using the wizard

• Reports

  Creating reports from your database using the report Wizard
  Portrait or Landscape layout
  Editing the layout of a Report once created
  Printing Reports
  

Included with this course

• • Comprehensive course materials and exercises
  • Telephone and Email Support
  • Lunch and refreshments when training is delivered at our training venues