Microsoft Access - Introduction
   

Duration:

 One Day
   

Aim:

 This is aimed at providing users with the skills required to design their own database effectively and efficiently and to manipulate the data through searching, filtering, querying and printing. Users will gain an introduction to Form Design and Report Design as a lead up to the next stage of database development.
   

Who Should Attend:

 Users who have no knowledge or basic knowledge of databases
   

Objectives:
  1. To define a Relational Database
  2. To create a database and define fields and field properties
  3. To enter and edit records
  4. To search specific data and printout the results
  5. To filter information
  6. To create Queries to extract information
  7. To introduce users to Form Design
  8. To introduce users to Report Design
   

Course Topics
  • A Definition of a Relational Database
  • An Introduction to Microsoft Access
    • The Screen Layout
    • The Database Window
    • Access Wizards
  • How to Design a Database
    • Define fields, data types and field properties
    • Define records
    • Define tables and table relationships
  • Creating a Table
    • Creating a database table and entering fields
    • Modifying the table structure
    • Setting a Primary Key
    • Validating and Formatting Fields
  • Adding and Editing Data
    • Using Datasheet View
    • Using Forms
    • Editing the Views
    • Controlling the views e.g. freezing columns, hiding
  • Searching and Manipulating the data
    • Find and Replace
    • Sort
    • Filtering
  • Filtering
    • Filtering data using Filter by Selection
    • Filtering data using Filter by Form
  • Printing
    • Editing the Page Setup
  • Forms
    • What is a Form?
    • Types of Forms
    • Using the Form Wizard
    • Understanding Controls
    • Editing the Form briefly through Design Tools
  • Queries
    • What is a Query?
    • Using Simple Select Queries
    • Using Logical Operators and Wildcards
  • Reports
    • What is a Report?
    • Types of Reports
    • Using the Report Wizard
    • Understanding Controls
    • Editing the Reports briefly through Design Tool
Related courses - Microsoft Access Intermediate | Microsoft Access Advanced | One-to-one training course
Tircoed Foelgastell Cross Hands Carmarthenshire SA14 7EL
Tel: 01269 832399 Mobile: 07909 785900 Email: info@ace-training.co.uk www.ace-training.co.uk