DURATION
2 Days
Training Time: 9.00 am – 5.00pm
Break Time: 10.15 am – 1030 am & 3.15 pm – 3.30 pm
Lunch Time: 12.30 pm – 1.30 pm
.600ft to customernts attending on the same scheudule.
Target Group
Microsoft Access 2003 is a database program. It is designed for users who will need of create and maintain a database, manipulating and extracting information from a database and generating reports. This course is targeted at the at Manager, Executive, HR Officer, HR Manager, IT Consultant, IT Assistant, Secretary, Training Officer, Administrator, MIS Officer, MIS Manager, and Information Technologist.
Prerequisites
With knowledge of Windows is required with the following pre-requisites:
- Able to maneuver with the mouse – Point, Click, Drag and Double Click.
- Able to change/customized the desktop items
- Able to use the Control Panel
- Able to switch between task applications
- Able to maneuver with Microsoft Office or current user of Microsoft Office (MS-Excel and MS-Word).
- Able to surf the Net will be an added advantage
Course Objectives
At the end of the course, users will be able to create and maintain databases; generate common office solutions like mailing labels; extract information from databases; and generating reports. This course is meant for end users as there will not be any programming involve.
Module 1: Introduction to Database
- What is a Database?
- Database Terms
- Problems with Bad Database Design
- Database Design Steps
Module 2: Using Microsoft Access
- Starting Microsoft Access
- Quick Tour through Microsoft Access
- Viewing Objects in the Database Window
- Using Database Wizard
Module 3: Planning and Creating Tables
- Introduction to Tables
- Creating a New Database
- Creating a Table using the Table Wizard
- Creating Tables by Entering Data
- Getting Data from other Access Tables
- Creating Tables in Design View
- Working with Fields and Data Type
- Field Properties
- Manipulating Tables in the Database Window
- Establish Table Relationships
- Understanding Referential Integrity
Module 4: Working with Tables
- Navigating Inside a Database
- Importing Tables
- Exporting Tables
- Linking Tables
- Linking to Excel
- Linking to another Access database table
Module 5: Querying a Database
- Understanding Queries
- Types of Queries
- Creating a Select Query
- Setting Criteria in a Query
- Creating Calculated Field
- Using the Expression Builder
- Creating a Parameter Query
- Creating a Total Query
- Extracting Top Values
- CrossTab Query
- Creating Cross Tab Query using Wizard
- Creating Cross Tab Query in Design View
Module 6: Creating Forms
- Creating Forms
- Working with Forms Controls
- Creating Forms using AutoForm
- Creating Forms using Form Wizards
- Formatting Forms
- Creating a SubForms
Module 7: Reports
- Creating Reports
- Exploring Different ways to Create Report
- Creating report using the AutoReport
- Creating report using the Report Wizard
- Customizing Report
- Grouping a Report
- Printing Reports
- Creating Mailing Labels
Programme scope, delivery arrangements and suitability are confirmed during enquiry.