TEL: 01639 648443

TEL: 01639 648443

  • Access 2007 Concepts
  • First look at Access 2007
  • Opening a Database and Security
  • Creating Databases and Using Views
  • Table Navigation and Modification
  • Field Properties, Validation and Input Masks
  • Manipulating Records and Tables
  • Primary Keys and Indexing
  • Filtering and Sorting
  • Revising What's New in 2007
  • Modifying Fields
  • Look up Fields
  • Validation Rules
  • Input Masks
  • Default Values
  • Mandatory Fields
  • Basics of Relationships
  • Creating Relationships
  • Applying Inner and Outer Joins
  • Applying and Using Referential Integrity
  • Applying Automatic Deletion of Records
  • Query Types
  • Grouping Information in a Query
  • Forms
  • Reports
  • Access Switchboards
  • Customising Access

Office Access 2007 Courses

 

DATE LEVEL TIME PRICE LESSON  
17/08/10 Foundation 9.15 - 3.15 £95.00 ONLINE BOOKING FORM
18/08/10 Intermediate 9.15 - 3.15 £105.00 ONLINE BOOKING FORM
20/08/10 Advanced 9.15 - 3.15 £115.00 ONLINE BOOKING FORM

 

 

Certificate of Achievement

 

Here in the Microsoft ® NPTC IT Academy every candidate is awarded a Microsoft Certified Certificate of Achievement on completion of all courses

 

MCAS Qualification

 

To attain the MCAS qualification in the required application, candidates must complete the MCAS exam for that application - Cost per MCAS exam: £50

 

Examination Information

 

Exams are conducted within 'live' Microsoft Office Programs. Exams are available on a weekly basis at the college campus. Please contact the NPTC IT Academy for availability info@nptcitacademy.com