Access 2003 Basic

Description

Students will learn how to plan and create a database, work with tables, create queries and forms, filter records, and generate reports. This course is approved courseware for Microsoft Office Specialist certification.

Objectives

• Organize data efficiently by using a database management system; start Access and open Access databases; and use the Help feature.
• Plan and create a database; use Datasheet view and Design view; and create tables and work in tables.
• Modify a table design; use the Find feature and the spelling checker; and sort, filter, and delete records.
• Set field properties; create input masks; set validation rules; and create singleand multiple-field indexes.
• Create queries, and sort and filter the results; modify queries; and perform operations in queries.
• Create, modify, and work with forms; and use them to find, sort, and filter records.
• Create reports by using AutoReport, the Report Wizard, Design view, and queries; and modify and print reports.

Outline

Access 2003 Intermediate

Description

Students will learn how to set table relationships, work with Lookup fields and subdatasheets, create join queries, create PivotTables and PivotCharts, and use hyperlink fields and data access pages.

Objectives

• Normalize tables, set table relationships, and implement referential integrity between related tables.
• Create a Lookup list field, modify Lookup field properties, and use a subdatasheet to add data to related tables.
• 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.

Outline

Access 2003 Advanced

Description

Students will learn how to: query with SQL; use crosstab, parameter, and action queries; create and run macros; import, export, and link database objects; optimize, replicate, and synchronize databases; and maintain database security.

Objectives

• 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, and export and import tables and queries to the Windows SharePoint Services site.
• 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.

Outline