Share |

HOME
ABOUT
WEB DESIGN
PC SERVICES
CONTACT
  Call (360) 813-2987

Microsoft Access 2007 

Access 2007 is the database software in the MicrosoftLearn Access 2007 2007 Office Suite. It allows you to order, manage, search, and report large amounts of information.

Includes course materials. Our class size is limited to two students, this provides more one on one time with our expert instructor. Hands on training.

After attending the class we provide you with a certificate of completion.

Price: $285 / Sale $185.00 / premium one day course

Students will learn the following lessons.

 

understanding database concepts

  1. Why do I need a database? 
    • Create and manage databases. A database is a place where you can store information related to a specific topic. How you intend to use the information will determine whether you need an Access database or a different program to create and manage your data. 
  2. Exploring an Access Database
    • Once you have determined that an Access database will help you store and manage your data, you will need to learn the parts of a database, how to start using Access, and how to navigate the Access window. In this lesson, we will provide a basic overview of Access, including the parts of a database, and common tasks you can complete using a database.
  3. Identifying the basic parts of the Access window
    • Identify the parts of the main Access window
    • Identify the parts of the database window
    • Understand the role of the design windows
  4. Thinking about database Design
    • This lesson will walk you through the steps of database design, using a bookstore scenario. You will determine the purpose of the database, and plan the tables and fields you will need for a very simple bookstore database.

 

Building the database

  1. Setting up Tables and Fields 
  2. Building Table Relationships
  3. Entering and Editing Data in Tables
  4. Creating and Using Forms
  5. Making Forms More Usable with Controls
  6. Making Forms Attractive

 

Analyzing and Reporting Data

  1. Sorting Records 
  2. Filtering Records
  3. Filtering Records
  4. Using Queries to Make Data Meaningful - Part 1
  5. Using Queries to Make Data Meaningful - Part 2
  6. Using Reports to Make Data Meaningful to Others

 

Back to Top