Cisco training   Microsoft training   Web design courses   Graphic design   Web development   IT courses


  • Overview
  • Course Details
  • Course outline
Advanced Access
MS Access 2007- 2010


.Our advanced Access training course is suitable for anyone who has previously taken our intermediate course or for those with a solid working knowledge of Access who wish to progress to learn the most complicated features.

Once you have completed the course you will have learnt to automate functions using both simple and complex macros, you will have again improved your knowledge of queries and acquired practical experience of working with SQL statements. You will also have gained a knowledge of how to work with objects and the principals of database management.

For more details about our advanced Access training or any of our Access training courses, please see our Access overview page.

If after taking an advanced Access training course, you still want to further your knowledge of Access, you can look into taking an Access VBA training course.


 

 

 
   
Advanced Access
MS Access 2007- 2010


Introduction Access Training


Our introduction Access training course is aimed at the complete beginner, so this course is for people who have never used Access before, or have had a little experience in using Access. At the end of this introduction Access training course you will have a firm grasp of the basics of Access and databases. You will be able to design and create a database from scratch and you will have a practical understanding of tables, forms, reports and simple queries.


Intermediate Access Training


Our intermediate course is suitable for those that have already taken our introduction course or if you have a fairly basic working knowledge of Access. During the course you will learn how to use the slightly more advanced features of Access that you may not have encountered before. You will then move on and learn about the more complex queries, forms and reports. Finally you will tackle PivotTables and PivotCharts.

If you wish to further your knowledge of Microsoft Access after taking the intermediate Access training you could move on and attend the advanced Access training course.

Advanced Access Training


Our advanced Access training course is suitable for anyone who has previously taken our intermediate course or for those with a solid working knowledge of Access who wish to progress to learn the most complicated features.

Once you have completed the course you will have learnt to automate functions using both simple and complex macros, you will have again improved your knowledge of queries and acquired practical experience of working with SQL statements. You will also have gained a knowledge of how to work with objects and the principals of database management.

For more details about our advanced Access training or any of our Access training courses, please see our Access overview page.

If after taking an advanced Access training course, you still want to further your knowledge of Access, you can look into taking an Access VBA training course.

MOS certifications


Gain Microsoft Office Specialist (MOS) certification from our Microsoft authorised testing centres. The MOS certification is the only credential of its kind approved by Microsoft and demonstrates end-user proficiency with Microsoft Office products.

The MOS certificate illustrates a measurement of proficiency in Microsoft Office applications. Successful qualified candidates gain the recognition for having advanced desktop Office skills. Professionals and students will then be able to confirm their expertise in the Microsoft Office suite. After taking an advanced Access training course, why not cement your skills with the MOS certification.

Who is this training course suitable for?

Our advanced Micorosoft Access training 2007 course is suitable for those with a sound working knowledge of Access who wish to progress to the most complicated functions and features.

Prerequisites

A working knowledge of Access is required.

Benefits

At the end of this course you will have a complete understanding of the higher functions of Access. You will learn to automate functions by creating simple and then very advanced macros. You will advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects, and the fundamentals of database management. Finally you will be taught how to protect your valuable data sources.

You will then be qualified to progress to the VBA course for Access.



 

 

 

Advanced Access
MS Access 2007- 2010


What's new in Access 2007

PivotTables and PivotCharts
Create a PivotTable
Modify a PivotTable
Working with a PivotChart

Creating Advanced Forms
Designing a form based on joined tables
Automating data entry
Grouped control
How to improve the user interface
Designing subforms

Macros
Create and run macros
Attach macros to events of database objects

Creating Advanced Macros
Create macros to provide user interaction
Create macros requiring user decision
Use AutoKeys and AutoExec macros

Exploring Access SQL
How to identify different clauses in an SQL statement
Writing SQL statements
Attach an SQL statement to database objects

Integrating the Internet
Work with hyperlink fields

Managing Databases
Work with database utilities to optimise resources
Secure data by database replication

Security Fundamentals
Protect databases


 


 

 


 
   

 
 
             
Microsoft Partner Cisco Partner prometric testing center ec council ciw 3 comptia
           
     
  Featured Courses : MCITP | MCTS | MCTS WEB | MCTS SQL | MCTS WINDOWS | MCPD | CCNA | CCNP | A+ | ETHICAL HACKER
 
  Other Courses :       SECURITY + | AUTOCAD | 3DMAX | FORENSICS INVESTIGATOR | ICDL | PMP | FINANCIAL EXCEL | ADV.ACCESS  
  IT Services :             NETWORK SOLUTIONS | IT CONSULTING | PROJECT MANAGMENT | PC MAINTINANCE  
  Help & support :      ABOUT US | FACILITIES | PARTNERS | FACEBOOK | REGISTER | CONTACT US  
     
  All rights reserved ®Global IT Co. 2010                                                                                     Developed by MS WEBSITE DESIGNERS  
     
     
     
     
Global it home page