Microsoft Office Access 2007 Basic
|
|
MS Office |
Language Course |
ILT Classroom |
Mentored Learning |
OnLine AnyTime |
OnLive Live |
|
Access 2007 |
Portuguese /
English |
Yes |
Yes |
Yes |
Yes |
40 HRS / 5 DAYS
Lesson 1: Exploring the Microsoft® Office Access™ 2007 Environment
• Examine Database Concepts
• Explore the User Interface
• Explore the Ribbon
• Customize the Access Environment
• Obtain Help
• Use an Existing Access Database
Lesson 2: Designing a Database
• Describe the Relational Database Design Process
• Define Database Purpose
• Review Existing Data
• Determine Fields
• Group Fields into Tables
• Normalize Data
• Designate Primary and Foreign Keys
• Determine Table Relationships
Lesson 3: Building a Database
• Create a New Database
• Create a Table
• Manage Tables
• Create a Table Relationship
• Save a Database as a Previous Version
Lesson 4: Managing Data in a Table
• Modify Table Data
• Sort Records
• Work with Subdatasheets
Lesson 5: Querying a Database
• Filter Records
• Create a Query
• Add Criteria to a Query
• Add a Calculated Field to a Query
• Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
• View Data Using an Access Form
• Create a Form
• Modify the Design of a Form
Lesson 7: Generating Reports
• View an Access Report
• Create a Report
• Add a Custom Calculated Field to a Report
• Format the Controls in a Report
• Apply an AutoFormat to a Report
• Prepare a Report for Print
Lesson 8: Controlling Data Entry
• Restrict Data Entry Using Field Properties
• Establish a Pattern for Entering Field Values
• Create a List of Values for a Field
Lesson 9: Joining Tables
• Create Query Joins
• Join Unrelated Tables
• Relate Data Within a Table
Lesson 10: Creating Flexible Queries
• Set Select Query Properties
• Create Parameter Queries
• Create Action Queries
Lesson 11: Improving Forms
• Design a Form Layout
• Enhance the Appearance of a Form
• Restrict Data Entry in Forms
• Add a Command Button to a Form
• Create a Subform
Lesson 12: Customizing Reports
• Organize Report Information
• Format the Report
• Set Report Control Properties
• Control Report Pagination
• Summarize Report Information
• Add a Subreport to an Existing Report
• Create a Mailing Label Report
Lesson 13: Sharing Data Across Applications
• Import Data into Access
• Export Data
• Analyze Access Data in Excel
• Export Data to a Text File
• Merge Access Data with a Word Document