DURATION
3 Days
Target Group
The Microsoft Access 2007 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
Module 1: Exploring Access 2007
Working in Access 2007
Understanding Database Concepts
Opening an Existing Database
Sidebar: Enabling Macros and Other Database Content
Exploring Tables
Exploring Queries
Exploring Forms
Exploring Reports
Exploring Other Access Objects
Previewing and Printing Access Objects
Module 2: Creating a Database
Creating a Database from a Template
Creating a Table Manually
Creating a Table from a Template
Manipulating Table Columns and Rows
Module 3: Populating a Database
Importing Information from Another Access Database
Sidebar: migrating a Database from a Previous Version of Access
Importing Information from an Excel Worksheet
Linking to Information
Importing or Linking to a SharePoint List
Collecting Data Through E-Mail
Importing Information from a Text File
Importing Information from Other Sources
Importing Information from an XML File
Importing Information from an HTML File
Importing Information from an Outlook Folder
Importing Information from a dBASE File
Module 4: Sharing and Reusing Information
Exporting Information to Another Access Database
Exporting Information to Excel
Exporting Information to a SharePoint List
Exporting Information to Word
Exporting Information to PDF and XPS Files
Exporting Information to a Text File
Exporting Information to an XML File
Exporting Information to an HTML File
Copying Information to Other Office Programs
Module 5: Simplifying Data Entry by Using Forms
Creating a Form by Using the Form Tool
Sidebar: Relationships
Refining Form Properties
Changing the Arrangements of a Form
Adding Controls to a Form
Entering Data in Form by Using VBA
Creating a Form by Using an AutoForm
Sidebar: Simultaneously Creating Forms and Subforms
Adding a Subform to a Form
Module 6: Locating Specific Information
Sorting Information in a Table
Sidebar: How Access Sorts
Filtering Information in a Table
Sidebar: Wildcards
Sidebar: Expressions
Filtering Information by Using a Form
Locating Information That Matches Multiple Criteria
Creating a Query Manually
Sidebar: Filters and Sorts vs. Queries
Sidebar: Expressions Builder
Creating a Query by Using a Wizard
Performing Calculations by Using a Query
Module 7: Keeping Your Information Accurate
Restricting the Type of Data in a Field
Restricting the Amount of Data in a Field
Specifying the Format of Data in a Field
Restricting Data by Using Validation Rules
Creating a Simple Lookup List
Updating Information in a Table
Deleting Information from a Table
Preventing Database Problems
Module 8: Working with Reports
Sidebar: Forms vs. Reports
Creating a Report by Using a Wizard
Modifying Report Design
Modifying Report Content
Adding a Subreport to a Report
Previewing and Printing a Report
Module 9: Making Your Database Easy to Use
Creating a Switchboard
Creating Custom Categories
Controlling the Features Available to Database Users
Making Favorite Access Commands Quickly Available
Module 10: Securing and Sharing Information
Assigning a Password to a Database
Sidebar: Creating a Secure Password
Sidebar: Database Encrypting
Preventing Changes to Database Code
Securing a Database for Distribution
Collaborating Through SharePoint
Programme scope, delivery arrangements and suitability are confirmed during enquiry.