185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151
Access 2010: Transition MS Access 2003
Access 2010: Transition MS Access 2003

Price: $149.00

Course Code: GI | Hours: 4

Access 2010: Transition MS Access 2003 Training Overview

This course is designed for experienced Access users who have worked with the earlier versions of Microsoft Access, ideally Microsoft Access 2003, and who have or are planning to upgrade to Microsoft Access 2010. This course is also designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program 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. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.

Upon successful completion of this course, students will be able to:

  • identify the components of the Microsoft Office Access 2010 interface
  • build tables and forms and also work with macro
  • create queries and report
  • work with external data
  • build a database for the web

Prerequisites:

Students should have a basic understanding of Windows, including how to use files and folders.

Next Classes:

See Also:

Prerequisites:

Students should have a basic understanding of Windows, including how to use files and folders.

Next Classes:

See Also:

Microsoft Access 2010: Transition MS Access 2003 Training Outline

Lesson 1: Identifying the Components of the Access 2010 Environment

• Topic 1A: Explore the User Interface
• Topic 1B: Access Commands on the Ribbon Tabs
• Topic 1C: Access the Contextual Tabs
• Topic 1D: Customize the Access Environment

Lesson 2: Building Tables and Forms

• Topic 2A: Create a Table
• Topic 2B: Build Forms from Existing Table Data
• Topic 2C: Design a Form
• Topic 2D: Work with Macros

Lesson 3: Creating Queries and Reports

• Topic 3A: Query a Database
• Topic 3B: Generate Reports
• Topic 3C: Format a Report

Lesson 4: Working with External Data

• Topic 4A: Import Data
• Topic 4B: Export Data to Other Applications

Lesson 5: Building a Database for the Web

• Topic 5A: Create Tables and Forms in a Web Database
• Topic 5B: Create Queries and Reports in a Web Database
• Topic 5C: Prepare to Publish a Database to Access Services

Appendix A: New Features in Microsoft Office Access 2010

Appendix B: Enhanced File and Compatibility Features in Access

Appendix C: Publish a Database to Access Services