|
Acend Corporate Learning ~ Microsoft Training Toronto Cancellation Policy
Description: Day 1- (Nonconsecutive days) Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database by using the Microsoft® Office Access 2003 relational database application and its information management tools.
Day 2- As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.
Introducing the Acend Modern Classroom
Classes Guaranteed to Run
An assessment process takes place at the start of class that results in the creation of a personalized learning plan for each participant . We integrate each individual's specific project objectives with their skill gaps to create the learning prescription. The instructor assumes the role of consultant and guides each participant through the process of filling the critical gaps identified in the learning plan.
Course Content
Day 1:
Lesson 1: An Overview of Access 2003
- Topic 1A: Understand Relational Databases
- Topic 1B: Examine the Access Environment
- Topic 1C: Open the Database Environment
- Topic 1D: Examine an Access Table
Lesson 2: Managing Data
- Topic 2A: Examine an Access Form
- Topic 2B: Add and Delete Records
- Topic 2C: Sort Records
- Topic 2D: Display Record sets
- Topic 2E: Update Records
- Topic 2F: Run a Report
Lesson 3: Establishing Table Relationships
- Topic 3A: Identify Table Relationships
- Topic 3B: Identify Primary and Foreign Keys in the Relationships Window
- Topic 3C: Work with Subdatasheets
Lesson 4: Querying the Database
- Topic 4A: Create a Select Query
- Topic 4B: Add Criteria to a Query
- Topic 4C: Add a Calculated Field to a Query
- Topic 4D: Perform a Calculation on a Record Grouping
Lesson 5: Designing Forms
- Topic 5A: Examine Form Design Guidelines
- Topic 5B: Create a Form Using AutoForm
- Topic 5C: Create a Form Using the Form Wizard
- Topic 5D: Modify the Design of a Form
Lesson 6: Producing Reports
- Topic 6A: Create an AutoReport
- Topic 6B: Create a Report by Using the Wizard
- Topic 6C: Examine a Report in Design View
- Topic 6D: Add a Calculated Field to a Report
- Topic 6E: Modify the Format Properties of a Control
- Topic 6F: AutoFormat a Report
- Topic 6G: Adjust the Width of a Report
Appendix A: Microsoft Office Specialist Program
Day 2:
Lesson 1: Planning a Database
- Topic 1A: Design a Relational Database
- Topic 1B: Identify Database Purpose
- Topic 1C: Review Existing Data
- Topic 1D: Determine Fields
- Topic 1E: Group Fields into Tables
- Topic 1F: Normalize the Data
- Topic 1G: Designate Primary and Foreign Keys
Lesson 2: Building the Structure of a Database
- Topic 2A: Create a New Database
- Topic 2B: Create a Table Using a Wizard
- Topic 2C: Create Tables in Design View
- Topic 2D: Create Relationships between Tables
Lesson 3: Controlling Data Entry
- Topic 3A: Restrict Data Entry with Field Properties
- Topic 3B: Create an Input Mask
- Topic 3C: Create a Lookup Field
Lesson 4: Finding and Joining Data
- Topic 4A: Find Data with Filters
- Topic 4B: Create Query Joins
- Topic 4C: Join Unrelated Tables
- Topic 4D: Relate Data Within a Table
Lesson 5: Creating Flexible Queries
- Topic 5A: Set Select Query Properties
- Topic 5B: Create Parameter Queries
- Topic 5C: Create Action Queries
Lesson 6: Improving Your Forms
- Topic 6A: Enhance the Appearance of a Form
- Topic 6B: Restrict Data Entry in Forms
- Topic 6C: Add Command Buttons
- Topic 6D: Create a Subform
Lesson 7: Customizing Your Reports
- Topic 7A: Organize Report Information
- Topic 7B: Set Report Control Properties
- Topic 7C: Control Report Pagination
- Topic 7D: Summarize Information
- Topic 7E: Add a Subreport to an Existing Report
- Topic 7F: Create Mailing Labels
Lesson 8: Expanding the Reach of Your Data
- Topic 8A: Publish Access Data as a Word Document
- Topic 8B: Analyze Access Data in Excel
- Topic 8C: Export Data to a Text File
- Topic 8D: Merge Access Data with a Word Document
Appendix A: Microsoft Office Specialist Program
Certificates offered: Certificate of completion
Duration Details: 2 non-consecutive days
9:00am - 4:30pm
Facility Location: Toronto Training Center
80 Bloor Street West
Suite 501
Toronto
Ontario
Canada
M5S 2V1
| 
