|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
|
| Training Providers
| Regions
| Training Search
| Advertise Training Seminars
| Login
|
||||||||||||||||||||||||
Training Provided by 2e2Objectives: By the end of this course you will be able to produce advanced form interfaces, understand hyperlinked and data access pages, create and use macros, design advanced data queries and implement Access security features.Prerequisites: This course is designed for students who have completed the Access Database Fundamentals course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software. Target Audience: Advanced users who need to build secure databases for other users, and those wishing to automate and control the use of database objects. Delegates will be shown Internet tools, such as Data Access Pages, hyperlinks, how to create Web pages, and integrate with other Office products. Delegates will also be shown how to secure a database effectively and be given a brief overview of VBA programming. Training Avaliability and Delivery
Related Keywords: microsoft access 2007 2003 2000 database Training Program DetailsCourse Content:
Complex queries Joining tables in queries Creating calculated fields Summarizing and grouping values Advanced form design Adding unbound controls Adding graphics Adding calculations Adding combo boxes Advanced reports Creating customized headers and footers Adding calculated values Working with subreports Creating charts Creating charts in forms Creating charts in reports PivotTables and PivotCharts Creating PivotTables Modifying PivotTables Working with PivotCharts Internet integration Working with hyperlink fields Working with data access pages Macros Creating and running macros Attaching macros to events of database objects Advanced macros Creating macros to provide user interaction Creating macros that require user decision Using AutoKeys and AutoExec macros Advanced queries Creating crosstab queries Using parameter queries The SQL statement Writing SQL statements Attaching an SQL statement to database objects Importing, exporting, and linking objects Importing Access objects Exporting Access objects XML documents Linking Access objects Working with shared databases Database management Optimizing resources Ensuring database integrity Security fundamentals Protecting databases Encrypting and decrypting databases User-level security Modules and MDE files Understanding modules Understanding MDE files Application design Examining an application Planning an application Advanced forms Building a form based on joined tables Using automated data entry Using grouped controls Improving the user interface Creating Subforms Automating forms Working with dialog boxes Working with macro groups Automating navigation across forms Switchboards and Splash Screens Working with Switchboards Working with Splash Screens Automating Splash Screens About 2e2 - Training Provider
2e2 - 2e2 is a training provider focussing on the end-user, providing courses in the following areas:
Desktop Applications training (e.g. Microsoft Office)
Unified Communications training (e.g. IP Telephony)
Service Management (including ITIL)
Web Development
Training Room Hire
We deliver public courses in London, Leeds and Birmingham and have...
More Microsoft Office Training from 2e2
| ||||||||||||||||||||||||
Custom Search
| ||||||||||||||||||||||||
| Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links | ||
|
| ||
| Training-Classes.com by Skillbox® 07/25/08 Copyright 1998-2008 skillbox, inc. All rights reserved |
 |
|
| Are you a Microsoft training provider? |
| You could be on this page today - for FREE! |
