Microsoft Office Access 2010: Transition
from MS Access 2003

Overview

TCCIT Solutions provides high quality, affordably priced, training classes in Microsoft Access 2010. With experienced instructors and a convenient midtown NYC location, we offer Microsoft Access 2010 courses for the corporate community. TCCIT Solutions offers group classes and private tutoring to beginner and more advanced corporate clients in Microsoft Access 2010. We offer onsite training or classes at our facility on 34th Street and Madison in New York City.

Description

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 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.

Course Objective:

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:

Related Classes:

TCCIT Solutions Course Curriculum for Microsoft Access 2010: Transition from Access 2003:

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

For more information about Corporate Training, please either call us at your convenience at 212-684-5151 or email us at info@TCCITSolutions.com.

You can always view our Complete Course List and our Complete Schedule.

www.tccitsolutions.com will take you to our sister site www.careercenters.com