Access Level 2
Printer friendly

Course Overview
  As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 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.



Objectives
  

This Course Includes:
  Six months of access to Online Learning Resources for the topics covered in your class. Online Learning Resources is a convenient, on-demand way of helping you retain what was taught in your class.

Sixty days of access to Post Class Support for instant help regarding the topics and tasks covered in your class. Post Class Support provides you with 24/7 support from certified experts via chat, phone and multimedia, including live demonstration, collaborative learning and step-by-step instruction.

Audience
  This course is designed for the student who wishes to learn intermediate-level operations of the Microsoft® Access program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft® Word or Excel.

This course is suited for those using Office 2003 or Office 2002.This course will be taught using MS Office Access 2003. In addition, this course is intended for persons interested in pursuing Microsoft Office Specialist certification in Microsoft Office Access.

Prerequisites
  To ensure the successful completion of Microsoft Access Level 2, we recommend completion of the following courses, or equivalent knowledge (basic familiarity with Access tables, relationships, queries, forms, and reports) from another source: Microsoft Access Level 1

Course Number
  EKEUACCL2
Course Length
  2 Days

Course Price
  $550.00
Category
  1
Topics
  Lesson 1: Structuring Existing Data
  • Import Data
  • Analyze Tables
  • Create a Junction Table
  • Improve Table Structure

Lesson 2: Writing Advanced Queries
  • Create Unmatched and Duplicates Queries
  • Group and Summarize Records Using the Criteria Field
  • Summarize Data with a Crosstab Query
  • Create a PivotTable and a PivotChart
  • Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros
  • Create a Macro
  • Attach a Macro to a Command Button
  • Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros
  • Require Data Entry with a Macro
  • Display a Message Box with a Macro
  • Automate Data Entry

Lesson 5: Making Forms more Effective
  • Change the Display of Data Conditionally
  • Display a Calendar on a Form
  • Organize Information with Tab Pages

Lesson 6: Making Reports More Effective
  • Cancel Printing of a Blank Report
  • Include a Chart in a Report
  • Arrange Data in Columns
  • Create a Report Snapshot

Lesson 7: Maintaining an Access Database
  • Link Tables to External Data Sources
  • Back Up a Database
  • Compact and Repair a Database
  • Protect a Database with a Password
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database