DURATION
3 Days
Target Group
The Microsoft Access 2002 (For Non-Programmers) course is targeted at IT Manager, IT Executive, HR Officer, HR Manager, IT Consultant, IT Assistant, Secretary, Training Officer, Administrator, MIS Officer, MIS Manager, and Information Technologist.
Prerequisites
With basic knowledge of Windows is required with the following pre-requisites:
Able to maneuver with the mouse – Point, Click, Drag and Double Click.
Able to configure the desktop
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-Word, MS-Excel and MS- PowerPoint).
Able to surf the Net will be an added advantage
Course Objectives
At the end of the course, students will be able to create and maintain databases; generate common office solutions like mailing labels, mail-merge; extract information from databases; and generating reports. This course is meant for end users as there will not be any design concepts covered
Course Contents
Basic Topic: Day 1
Chapter 1: Getting to Know Access 2002
What is a Databases
What’s Special About Access?
Opening an Existing Database
Exploring Tables
Exploring Queries
Exploring Forms
Exploring Reports
Exploring Other Access Objects
Chapter 2: Creating a New Database
Creating a Database Structure the Simple Way
Checking the Work of a Wizard
Creating Tables the Simple Way
Refining How Data Is Displayed
Manipulating Table Columns and Rows
Chapter 3: Getting Information Into and Out of a Database
Importing Information from Excel
Importing Information from a Delimited Text File
Importing Information from a Fixed-Width Text File
Importing Information from an Access Database
Importing Information from Other Databases
Importing Information from an HTML File
Importing XML Data
Exporting Information to Other Applications
Linking a Database to Information in Another Database
Other Ways to Share Access Data
Intermediate Topic: Day 2
Chapter 4: Simplifying Data Entry with Forms
Creating a Form Using a Wizard
Refining Form Properties
Refining Form Layout
Adding Controls to a Form
Using VBA to enter Data in a Form
Creating a Form Using an AutoForm
Adding a Subform to a Form
Chapter 5: Locating Specific Information
Sorting Information
Filtering Information in a Table
Filtering by Form
Locating Information that Matches Multiple Criteria
Creating a Query in Design View
Creating a Query with a Wizard
Performing Calculations in a Query
Chapter 6: Keeping Your Information Accurate
Using Data Type Settings to Restrict Data
Using Field Size Properties to Restrict Data
Using Input Mask to Restrict Data
Using Validation Rules to Restrict Data
Using Lookup Lists to Restrict Data
Updating Information in a Table
Deleting Information from a Table
Chapter 7: Working with Reports
Creating a Report by Using a Wizard
Modifying a Report
Creating a Report from Scratch
Adding a Subreport to a Report
Previewing and Printing a Report
Advance Topic: Day 3
Chapter 8: Making It Easy for Others to Use Your Database
Creating a Switchboard by Using Switchboard Manager
Creating Splash Screen
Setting Startup Options
Keeping Your Application Healthy
Chapter 9: Keeping your Information Secure
Hiding Database Content from Prying Eyes
Controlling Who Can Open Your Database
Sharing a Database
Replicating a Database
Splitting a Database
Setting Up a Workgroup
Maintaining a Workgroup
Preventing Changes to VBA Code
Securing a Database That Will Be Publicly Distributed
Chapter 10: Working with Pages and Modules
Creating Static Web Pages
Exploring Visual Basic for Application
Using VBA to Create a Web Page
Creating a Data Access Page with AutoPage
Creating a Data Access Page with the Page Wizard
Allowing Others to Analyze Data via the Web
Programme scope, delivery arrangements and suitability are confirmed during enquiry.