"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

ACCESS LEVEL 1 & 2

Course Overview

To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level.

 

Course Title  Microsoft Access  Level 1 & 2

 

         

Course Duration 2 Days

 

 Course Objective

To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level.

 

Target student

People who intend to design databases from scratch or improve existing Access databases also covers conversion of databases made in other applications and spreadsheet (flat file) databases. The training also cover the Conversion of databases made in other applications and spreadsheet (flat file) databases.

 

Prerequisites

This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.

 

Day 1.

 

Introduction to Databases

Database concepts

Database layout

Launching Access.

The access menu system

Dialog boxes

Getting help

Creating a new database

Closing a database (vs. exit access)

Opening a database  

 

Working with Tables

Adding/Editing Records

Pasting Records

Sorting the Table

Deleting a Table

Table Layout Changes

Find

Replace

Wildcards

Using Filters

 

Queries

The Simple Query Wizard

The Design View

Modifying the Query

Using Basic Criteria

Additional Criteria

Parameters

Multiple Object Queries

Custom Calculations in a Query

Calculating Fields continued

 

Forms and Reports

Creating a Basic Form

Creating a Basic Report

 
 
 
 
 
 
 
Day 2.
 
Creating a Database
Database Design.
Creating Tables using the Table Wizard
Creating Tables in The Datasheet View
Creating Tables in the Design View
Data Types
Field Properties
Data Display Format Vs Input Mask
The Input Mask
Data Entry Problems
Moving and Copying Records
 
Managing Relational Databases
Types of Relationship
Creating Table Links
Referential Integrity
 
Action Queries
Types of Query
The Crosstab Query
The Make Table Query
The Append Query
The Delete Query
The Update Query
 
Forms
Manipulating Data in the Form
Creating a New Form
Using the Form Wizard
Creating a Form with a Subform
Modifying and Redesigning the Form.
Modifying and Redesigning the Form continued
 
Reports
The Report Wizard
Creating a Report with Calculated Totals
Using the Chart Wizard
Altering the Chart
Using the Label Wizard
Modifying and Redesigning the Report.
Publishing Access Data on the Web