Duration
3 days
Target Group
The Microsoft Access 2003 (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
Chapter 1: Getting to Know Access 2003
- Understanding Databases
- Discovering What’s Special About Access
- Opening an Existing Database
- Exploring Tables
- Exploring Queries
- Exploring Forms
- Exploring Reports
- Exploring Other Access Objects
- Previewing and Printing 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 Information from an XML File
- Exporting Information to Other Programs
- Linking a Database to Information in Another Database
- Other Ways to Share Access Data
Chapter 4: Simplifying Data Entry with Forms
- Creating a Form by Using a Wizard
- Refining Form Properties
- Refining Form Layout
- Adding Controls to a Form
- Using Visual Basic for Applications to Enter Data in a Form
- Creating a Form by 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 Masks 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
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
- Encrypting and Decrypting a Database
- Assigning a Password to a Database
- Sharing a Database
- Replicating a Database
- Splitting a Database
- Setting Up a Workgroup
- Maintaining a Workgroup
- Preventing Changes to a Database
- Securing a Database for Distribution
Chapter 10: Working with Pages and Modules
- Creating Static Web Pages
- Exploring Visual Basic for Application (VBA)
- Using VBA to Create a Web Page
- Creating a Data Access Page with AutoPage
- Creating a Data Access Page Using the Page Wizard
- Allowing Others to Analyze Data on the Web
Programme scope, delivery arrangements and suitability are confirmed during enquiry.