Home Our Courses One Day CoursesDatabase / Access Training

Database / Access Training

Introduction to Databases ( 1 Course ) See Dates / Register

Purpose

INTRODUCTION TO DATABASES (MICROSOFT ACCESS)

The objective of this Microsoft Access training course is to be able to plan, design, create, manipulate and query databases.
Once completed you will be capable of using Microsoft Access to generate reports, understand terminology and produce input user forms.

Course Details

Database Terms Prebuilt database templates An explanation of database terminology Plan your Database (Tables, Queries, Forms, Reports, Macros, Pages, Modules) Plan a database structure. (tables) Create a new database file	Working with Tables Design a Table, Conventions for entering, Naming objects and fields (Design View) Select data types, enter field descriptions Set a Primary Key/Remove a Primary Key Field Properties Insert, Delete, Move and Rename Fields Create a Table with a Wizard
Entering & Editing Data Accessing objects through the navigation pane Switch Views in Access (design, layout and data entry) Entering/Editing Data (Records/Fields) Navigating the datasheet Sorting Data, Finding & Replacing Data Hiding and Un hiding Fields	Relationships Relationships explained? Different types of relationships (one to many etc) Conditions needed for setting up a relationship Ensuring Referential Integrity Printing Relationships in a Report Enter data in related tables
Queries & Filters Create a filter by selection Create a filter by form Creating a query using a wizard Build a query using Query Design Add/Remove fields in a query Sort data in a select query Enter Text, numeric, date, logic criteria Rename, edit or delete a query	Multi Table Queries Build a query across more than one table Joining Tables for a query (more relationships) Setting Join Properties - Inner and Outer Joins Find Unmatched records Query Wizard Find Duplicate records Query Wizard
Creating Forms Create a Form using Auto Form tool Create a Form using the Form Wizard Form design view/layout view The Field List, Resizing Forms Format Painter and AutoFormat Set basic form properties Data Entry in Forms Add, edit, delete a record in form view	Reports Standard Reports using Wizard Insert, Move, Size and delete controls Editing record source Page setup Print your report

Advanced Databases ( 1 Course ) See Dates / Register

Purpose

access2

Advanced Databases (Microsoft Access)

The aim of this Advanced Microsoft Access training course is to acquire a more indepth knowledge of Access, including relational databases, complex queries, macros and integration with other MS Office applications.
This course is designed for existing users of Microsoft Access who have a good working knowledge.