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.
:: Course ACS03I ::
Module 1: 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 2: 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.