Microsoft Certified Application Specialist (MCAS)
1 Day Course
Performance-based objectives
- Examine the basic database concepts and explore the Microsoft Office Access 2007 environment.
- Design a simple database.
- Build a new database with related tables.
- Manage the data in a table.
- Query a database using different methods.
- Design forms.
- Generate reports.
Prerequisites
This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. Students should have a working knowledge of the Windows Operating System.
Course Content
Lesson 1: Exploring the Access Environment
- 1A: Examine Database Concepts
- 1B: Explore the User Interface
- 1C: Explore the Ribbon
- 1D: Customize the Access Environment
- 1E: Obtain Help
- 1F: Use an Existing Access Database
Lesson 2: Designing a Database
- 2A: Describe the Relational Database Design Process
- 2B: Define Database Purpose
- 2C: Review Existing Data
- 2D: Determine Fields
- 2E: Group Fields into Tables
- 2F: Normalize Data
- 2G: Designate Primary and Foreign Keys
- 2H: Determine Table Relationships
Lesson 3: Building a Database
- 3A: Create a New Database
- 3B: Create a Table
- 3C: Manage Tables
- 3D: Create a Table Relationship
Lesson 4: Managing Data in a Table
- 4A: Modify Table Data
- 4B: Sort Records
- 4C: Work with Subdatasheets
Lesson 5: Querying a Database
- 5A: Filter Records
- 5B: Create a Query
- 5C: Add Criteria to a Query
- 5D: Add a Calculated Field to a Query
- 5E: Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
- 6A: View Data Using an Access Form
- 6B: Create a Form
- 6C: Create a Form Using the Form Wizard
- 6D: Modify the Design of a Form
Lesson 7: Generating Reports
- 7A: View an Access Report
- 7B: Create a Report
- 7C: Create a Report Using the Report Wizard
- 7D: Add a Custom Calculated Field to a Report
- 7E: Format the Controls in a Report
- 7F: Apply an AutoFormat to a Report
- 7G: Prepare a Report for Print
For Information Contact
Rhuann Heimann 618-523-4893
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
www.trainatacumen.com
|
