Duration
3 days
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
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
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.