inner-header-banner2

Access

Acess 2007 introduction

Approx. Time Needed: 16 hour(s)
Prerequisites: Basic knowledge of MS Windows XP/Vista/Windows 7
Strong mouse and keyboard ability

Targets
  • Create a table design for a relational database
  • Establish relationships between tables
  • Work in and edit tables
  • Design Forms using Form Wizard
  • Design basic queries
  • Design basic reports
Acess 2007 Intermediate

Approx. Time Needed: 16 hour(s)
Prerequisites: Basic level Access 2007 or an equivalent experience

Targets
  • Full Or Partial Referential Integrity
  • Create Single And Multiple Field Indexes And Tables
  • Check The Integrity Of A Database
  • Use The Toolbox To Design Forms From Scratch
  • Use Calculated Fields
  • Use Report Grouping And Create Mailing Labels
Acess 2007 Advanced

Approx. Time Needed: 16 hour(s)
Prerequisites: Intermediate level Access 2007 or an equivalent experience

Targets
  • Explain steps to “Normalize’ a database
  • Explain types of database relationships
  • Use the Table Analyzer Wizard
  • Explain query join properties
  • Create command buttons on a form and attach macros
  • Create action queries
  • Use the IF function to determine if a condition exists
  • Use the Sum and Avg functions in a report
  • Link and import external data into acces

Latest News

Photoshop Courses starting in March 2014

Photoshop Lessons are starting again  this March 2014!! For all those who would like to learn

In 2014....

In 2014 MCO Training Center is planning to expand it's package of services.  As the main goal of MCO
More News
promise

What we promise you as a client

  • Excellent Products and Services
  • Trainers offering personalized courses
  • Top quality Course materials
  • Satisfaction after completing any course
promise

Where you can find/fetch us

promise

Join MCOTC become member