Microsoft Access - Introduction 2 Day
   

Duration:

 Two days
   

Aim:

 This course aims to provide users with the skills required to design their own database effectively and efficiently and to manipulate the data through searching, filtering, querying and printing using multiple tables. Understanding and creating links. 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 establish links between one or more tables
  4. To enter and edit records
  5. To search specific data and printout the results
  6. To interrogate one or more tables using filters and "queries"
  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
  • Establishing Links between Tables
    • Creating two or more tables
  • 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 using Filter by Selection
    • Filtering 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
    • Setting up Queries on Multiple Tables
  • Reports
    • What is a Report?
    • Types of Reports
    • Using the Report Wizard
    • Understanding Controls
    • Editing the Reports briefly through Design Tools

 
Related courses -
Tircoed Foelgastell Cross Hands Carmarthenshire SA14 7EL
Tel: 01269 832399 Mobile: 07909 785900 Email: info@ace-training.co.uk www.ace-training.co.uk