Follow Us :

Microsoft Access 2007 Fundamentals

Course_Reference: 
E2-A6M1
Summary: 

The skills and knowledge acquired in Microsoft Access 2007 Fundamentals are sufficient to be able to use and operate the software at an efficient level.

Audience: 

Microsoft Access 2007 Fundamentals is designed for users who are keen to extend their understanding and knowledge of the software.

Objectives: 

At the completion of Microsoft Access 2007 Fundamentals you should be able to:

• start and exit from Access and understand what a database object is
• understand some elementary database theory.
• design and create a new database file in Access
• make changes to data in a table
• format data in tables
• sort and filter data in a table
• use a range of data validation techniques to protect data integrity
• preview and print a range of objects
• create and use queries to locate and display data
• work with forms
• create reports in Access
• design relational databases
• create relational databases
• set table relationships in a database
• add records to a relational database

  • Access 2007 Orientation 
  • Database Theory
  • Creating a New Database
  • Managing Table Data
  • Formatting Table Data
  • Sorting & Filtering Table Data
  • Data Validation
  • Printing In Access
  • Select Queries
  • Working With Forms
  • Reports
  • Database Design 
  • Creating Relational Databases 
  • Setting Table Relationships 
  • Adding Relational Records 

Software Vendor

IT Technical

Business Skills