Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools.
A hands-on training provides understanding of the basic database concepts, creating and modifying databases and their various objects using the Microsoft® Office Access™ 2007 relational database application. You will gain the basic skills needed to work with Microsoft® Office Access™ 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. You will also learn to maintain data consistency, how to customize database components, and how to share Access data with other applications. |
Topics:
-
Examine Database Concepts
-
Explore the User Interface
-
Use an Existing Access Database
-
Customize the Access Environment
-
Obtain Help
-
Describe the Relational Database Design Process
-
Refine Database Purpose
-
Review Existing Data
-
Determine Fields
-
Group Fields into Tables
-
Normalize Data
-
Designate Primary and Foreign Keys
-
Determine Table Relationships
-
Building a Database
-
Create a New Database
-
Create a Table
-
Manage Tables
-
Create a Table Relationship
-
Save a Database as a Previous Version
-
Modify Table Data
-
Sort Records
-
Work with Subdatasheets
-
Filter Records
-
Create a Query
-
Add Criteria to a Query
-
Add a Calculated Fields to a Query
-
Perform Calculations on a Record Grouping
-
View Data Using an Access Form
-
Create a Form
-
Modify the Design of a Form
-
View an Access Report
-
Create a Report
-
Add a Custom Calculated Field to a Report
-
Format the Controls in a Report
-
Apply an AutoFormat Style to a Report
|
Topics: (cont)
- Relate Data Within a Table
- Set Select Query Properties
- Create Parameter Queries
- Create Action Queries
- 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
- 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
- Import Data into Access
- Export Data
- Analyze Access Data in Excel
- Export Data to a Text File
- Merge Access Data with a Word Document
- Restrict Data Entry Using Field Properties
- Establish a Pattern for Entering Field Values
- Create a List of Values for a Field
- Create Query Joins
- Join Unrelated Tables
|
Target Audience
This course is ideal for people who need to store, manage, sort and view large amounts of data. |
