Microsoft Access 2003 Specialised

At the completion of Microsoft Access 2003 Fundamentals you should be able to:

• create select queries for a relational database
• add calculated fields to queries
• add parameters to queries to capture criteria data
• create aggregated queries
• create a form for data entry or data viewing in Access
• produce reports with calculations
• import data into an Access table from a variety of sources
• export records from Access
• export records to HTML for use on the Web
• understand table and query relationships and how they affect the integrity of your data
• create a chart on a form
• create a data access page
• create data access pages using the Design View
• create simple macros
• use conditions in macros
• create macros that used with forms
• create a Crosstab query to analyse data in a table or query
• create action queries to make tables, and update, append, and delete records
• protect your database files against unauthorised access
• completely secure a database file and its objects so that unauthorised access is prevented
• write a simple procedure in VBA
• create sophisticated forms with tab controls and sub-forms
• create a macro for an option group to provide instant filtering
• use the Switchboard Manager to create a menu system
• split the tables from a database file
• create and maintain multiple copies of a database file