Microsoft Access 2003 Specialised (2-days)

Objectives: After completing this course, you will know how to: Create join queries, create calculated fields in a query, and use queries to view summarized and grouped data. Add unbound controls, graphics, calculated fields, and a combo box to a form. Add headers and footers in a report, use functions to add calculated values in a report, and embed a subreport in a report. Create and modify charts in forms and reports. Create a PivotTable, modify a PivotTable, and create a PivotChart. Create and use hyperlink fields and data access pages. Use SQL statements and examine them in Access, write SQL statements to create queries, and attach an SQL statement to a command button. Create crosstab queries to summarize grouped data, create parameter queries to view results based on specified criteria, and create action queries to add, delete, and modify data in tables and to create new tables. Create and run macros to automate tasks and attach macros to the events of database objects. Create data validation and data-entry macros, create macros that run parameter queries, create the AutoKeys and AutoExec macros, and create macros to import and export database objects. Import Access objects into an active database from another Access database and from Excel, export objects from one active database to another Access database, export and import XML documents, link objects from one database to another and update the links. Work with database utilities to optimize resources and replicate and synchronize a database. Use a password to secure database files, encrypt and decrypt databases, and set specific permissions for users to secure database objects. Identify the components of an application and plan an application. Create and use grouped controls, create and use tab controls to make a form user-friendly, and create and use subforms. Examine and create a dialog box, examine and create macros to automate a dialog box, use code elements in Visual Basic for Applications and automate navigation across forms by using command buttons. Create, test, and modify Switchboard forms by using the Switchboard Manager, create Splash Screen forms by modifying form properties, and automate Splash Screen forms to appear at database startup

Prerequisites: This course is designed for students who have completed the Access 2003 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.

Delivery:	Distance
Category:	Advanced Microsoft Access