"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

Microsoft Access L1 & L2 Duration: 2 Days

Course Overview

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

Customising 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