About this Course
This one-day instructor-led course provides students with an overview of the features and functions of Microsoft
Office Access 2007.
Audience Profile
This course is intended for information workers who want to learn beginning-level Access 2007 skills.
Pre-requisite
Before attending this course, students must have:
Basic computer knowledge.
Basic file-management skills.
At Course Completion
After completing this course, students will know how a relational database works and how to create the basic components of a database. They will know how to get information into the database and how to get useful information out. They will also know how to import existing data into a database, and export data from a database to another file. Specifically, they will be able to:
Work in Access 2007.
Understand database concepts.
Open an existing database.
Explore tables, queries, forms, and reports.
Preview and print Access objects.
Create a database from a template.
Create a database and a table manually.
Create a table from a template.
Manipulate table columns and rows.
Create a form by using the Form tool.
Refine form properties.
Change the arrangement of a form.
Collect data through e-mail.
Sort information in a table.
Filter information in a table.
:: Course 50135A ::
Filter information by using a form.
Import information from another Access database.
Import information from an Excel worksheet.
Import or link to a SharePoint list.
Import information from a text file, an XML file, an HTML file, an Outlook folder, and a dBASE file.
Export information to another Access database.
Export information to Excel and Word.
Export information to a SharePoint list, a text file, an XML file, or an HTML file.
Copy information to other Office programs
Module 1: Introduction to Access 2007
This module discusses the new Access interface and explores various database components, including tables, queries, forms, and reports.
Lessons
Working in Access 2007
Understanding Database Concepts
Opening an Existing Database
Exploring Tables
Exploring Queries
Exploring Forms
Exploring Reports
Exploring Other Access Objects
Previewing and Printing Access Objects
Key Points
Lab : Introduction to Access 2007
Explore the user interface.
Open, explore, and close a database.
Explore tables.
Explore queries.
Explore forms.
Preview a report.
Preview a table and a form.
After completing this module, students will be able to:
Work in the Access environment.
Describe how a database works.
Open and move around in a database.
Open and move around in tables, queries, forms, reports, and other Access objects.
Preview and print Access objects such as tables and forms.
:: Course 50135A ::
Module 2: Databases and Tables
This module explains how to create databases and tables, either manually or from templates. It also explains how to change table columns and rows.
Lessons
Creating a Database from a Template
Creating a Database and a Table Manually
Creating a Table from a Template
Manipulating Table Columns and Rows
Key Points
Lab : Databases and Tables
Use a template as the basis for a database.
Create a table in a blank database, and then add records.
Use a template as the basis for a table.
Change table formatting.
After completing this module, students will be able to:
Create databases in various ways.
Add tables to a database.
Change the formatting of a table.
Module 3: Simple Data Entry
This module explains how to work with forms to input data, including creating a form by using the Form tool and changing its properties and layout. It also explains how to use a form to input data by means of e-mail surveys.
Lessons
Creating a Form by Using the Form Tool
Refining Form Properties
Changing the Arrangement of a Form
Collecting Data Through E-Mail
Key Points
Lab : Simple Data Entry
Create a form that uses all the fields in a table.
Change a form’s properties.
Move labels and controls on a form.
After completing this module, students will be able to:
Use the Form tool to create a form based on a table.
Change the form's properties
Change the form's layout.
:: Course 50135A ::
Module 4: Data Display
This module explains how to display information in useful ways, by sorting and filtering tables, and by filtering information in forms.
Lessons
Sorting Information in a Table
Filtering Information in a Table
Filtering Information by Using a Form
Key Points
Lab : Data Display
Sort a table based on one field and then multiple fields.
Filter a table based on one filter and then multiple filters.
Find a record by filtering a form.
After completing this module, students will be able to:
Find information by sorting and filtering in tables.
Display information by filtering forms.
Module 5: Data Import Procedures
This module explains how to populate the tables of a database by importing existing information from other sources.
Lessons
Importing Information from Another Access Database
Importing Information from an Excel Worksheet
Importing or Linking to a SharePoint List
Importing Information from a Text File
Importing Information from an XML File
Importing Information from an HTML File
Importing Information from an Outlook Folder
Importing Information from a dBASE File
Key Points
Lab : Data Import Procedures
Import Access tables.
Populate a table with data from an Excel worksheet.
Populate a table with data from a comma-delimited text file.
Create tables from two types of XML files.
Populate a table with data from an HTML file.
Create a table with data from an Outlook Contacts folder.
Populate a table with data from a dBASE database.
After completing this module, students will be able to:
Avoid having to rekey data that exists in other file formats by importing the data into Access.
:: Course 50135A ::
Module 6: Data Export Procedures
This module explains how to use information that exists in an Access database in other programs.
Lessons
Exporting Information to Another Access Database
Exporting Information to Excel
Exporting Information to a SharePoint List
Exporting Information to Word
Exporting Information to a Text File
Exporting Information to an XML File
Exporting Information to an HTML File
Copying Information to Other Office Programs
Key Points
Lab : Data Export Procedures
Export a table as a new Access database.
Export a table as a new Excel workbook.
Export a form as an RTF document.
Export a table as both formatted and unformatted text files.
Export a table as an XML file.
Export a report as linked HTML files.
Copy Access data to Excel and Word.
After completing this module, students will be able to:
Avoid having to rekey data that exists in an Access database by exporting the data for use in other programs.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.