|
Course ID: 13886
| Course Duration: 2 Days
|
|
Course Dates:
|
| |
|
| |
Access 2007 - Level 1 Training Class
Course ID: 13886
|
|
| |
|
|
| |
|
|
| |
Access 2007 - Level 1 Training Seminar
In the course, students create and modify new databases and their various objects. They learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Access??? 2007 with other applications. (Second Edition)
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
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
|
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Windows XP (New Version) - Level 1
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
| |
Access 2007 - Level 1 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 13886
| Course Duration: 2 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request More Info |
|
Print/Fax Register |
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Business Skills courses
|
|
| |
|
|
| |
Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |

|
|