Custom Search
Home > Computer > Microsoft Office > NobleProg - IT training courses > Access 2007 Advanced Training Course
Provided by: NobleProg - IT training courses

Access 2007 Advanced Training Course

Access

 NobleProg - IT training courses
Training Provided by NobleProg - IT training courses By the end of this course you will have a complete understanding of the higher functions of Access. The course involves showing you how to automate functions by creating simple and then very advanced macros. You will be shown how to advance your querying ability and then to use SQL statements in your queries. You will be guided how to discover how to work with objects, and the fundamentals of database management. Finally you will be taught how to protect your valuable data sources.
This is primarily ilt training
workshop / seminarThis is a workshop seminar
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
computer labComputer Lab Work
group study and discussionThis class may involve group study
instructor led trainingThis class may be available at a classroom in London, London,
Contact NobleProg - IT training courses for more information
Course Level:advanced
Duration:8 hours
Training Presented in:English
Click here for more information or to take this course
Access 2007 Advanced Training Course Whats New IN Access 2007

  • Old Menu/ New Location

  • New spreadsheet Dimensions

  • Cell & Table Styles

  • Enhanced Conditional Formatting

  • Enhanced Cell/ Font Colour

  • Enhanced Chart Features

  • Page Layout View

  • Old Feature, New Location

PivotTables and PivotCharts

How to create a PivotTable
How to modify a PivotTable
How to work with a PivotChart

Creating Advanced Forms

Joined tables and designing a form
Automation and data entry
Grouped control

Improving the user interface
Designing subforms

Macros

Creating and running macros
Attaching macros to events of database objects

Creating Advanced Macros

Creating macros to provide user interaction
Creating macros requiring user decision
AutoKeys and AutoExec macros

 Access SQL

Identication of clauses in an SQL statement
Writing SQL statements
Attach an SQL statement to database objects

How to Integrate the Internet

Hyperlink fields

Data access pages

How to manage Databases

Database utilities to optimise resources
Secure data by database replication

Security

Protection of databases

About The Training Provider: NobleProg - IT training courses
NobleProg - IT training courses - NobleProg specializes in bespoke computer and management training courses. NobleProg provides computer training courses in the following areas: * Drupal * Java * Linux * MySQL * OpenOffice * Oracle * PHP * Project Management * SVN and CVS * UML * Web Application Testing * CSS * VBA * BPM * SOA * LPI (We are...
Click here for more information or to take this course
Home > Computer > Microsoft Office > NobleProg - IT training courses > Access 2007 Advanced Training Course
tcw11-gfc-v396M-11/17/09-10:51:02-()[B]-[A]-[A] -00:15:34