Follow Us :

Introduction To Microsoft Access

Course_Reference: 
REEITA
Manufacturer: 
0
Training_Provider: 
35
Summary: 

This course aims to develop your skills and confidence in using MS Access, by starting you off with a solid grounding in the basic techniques.

Audience: 

Those new to Access and those who are self taught and would like to consolidate or check their understanding.

Objectives: 

You will acquire the confidence and ability to manage the establishment and maintenance of Access databases.

Unit1: Database concepts

  • Database concepts and terminology
  • Starting with Access
  • The Access environment
  • Planning and designing databases
  • Getting Help
  • Closing a database and exiting Access

Unit 2: Access basics

  • Exploring tables and forms
  • Exploring queries
  • Exploring reports

Unit 3: Creating databases

  • Creating a database
  • Using the Table Wizard
  • Working in Design view

Unit 4: Working with fields and records

  • Changing the design of a table
  • Adding and deleting records
  • Finding and editing records
  • Sorting and filtering records

Unit 5: Querying tables

  • Viewing specific fields
  • Modifying query results and queries
  • Calculations in queries

Unit 6: Creating and using forms

  • Creating forms by using AutoForm
  • Using Form Wizard
  • Using Design view

Unit 7: Creating and using reports

  • Using the Report Wizard
  • Using reports to perform calculations

Unit 8: Importing and exporting objects

  • Importing Access objects
  • Exporting Access objects

Unit 9: Creating Relational Databases

  • Analysing Table Relationships
  • Relating Tables
  • Testing Referential Integrity

Unit 10: Working with Related Tables

  • Using the Lookup Wizard
  • Modifying Lookup Fields
  • Adding Data to Related Tables

Unit 11: Defining Data Entry Rules

  • Working with Input Masks
  • Setting Required Properties
  • Setting Validation Rules
  • Setting Lookup Fields

Description: 

This course aims to develop your skills and confidence in using MS Access, by starting you off with a solid grounding in the basic techniques. You will acquire the confidence and ability to manage the establishment and maintenance of Access databases.

Keywords: 
Microsoft Access,develop skills,develop confidence,grounding in basic techniques,confidence with Access

Software Vendor

IT Technical

Business Skills