This course covers getting started with Access 2003, basic tables, basic forms, queries, reports, importing and exporting data and data presentation in Access 2003. The training will also teach you how to use advanced data management, programmability and administration as well as database administration in Access 2003.

Upon successful completion of this Microsoft Office Access 2003 training course, you will be fully prepared to sit for the Microsoft Office Specialist Access 2003 Exam MOS: Microsoft Office Access 2003. All of our Microsoft Office 2003 training courses map to MOS certification paths.

Expected Duration (hours) – 24
Mentoring – Mon-Fri (9-5 EST)

Price: USD $149.00

USD

Getting Started with Access 2003

• Identify the type of database model implemented by Microsoft Access
• Plan a database design that meets an organization's requirements
• Identify relationships when planning a database
• Select the appropriate database design for an organization's needs
• Associate the main elements of the Access 2003 interface with their functions
• Select the methods for creating a database
• Recognize the functions provided by the database objects in an Access database
• Create an Access database and view its data in different views

Basic Access 2003 Tables

• Add a table to an Access database
• Add a table using the Design and Datasheet views
• Modify fields to define a table's features
• Use masked input fields and apply indexing to fields
• Create and modify a specific table in Access 2003
• Manage the data in records
• Identify the steps involved in creating the various types of relationships between tables
• Modify table data and edit relationships between tables
• Create a database containing relational tables in response to a business requirement

Basic Access 2003 Forms

• Select a suitable method for creating a form
• Select methods for adding and formatting controls
• Select methods for manipulating controls
• Select the correct options to bind a control
• Create a form with bound controls
• Select the correct options to format a form
• Select the correct options to manage records displayed in a form
• Format a form and manage records

Using Queries and Reports in Access 2003

• Select the options that allow you to create and run a select query
• Select the options that allow you to refine a query
• Select the options that allow you to perform calculations on a query
• Create and modify a query and print query results
• Create a crosstab query
• Find unmatched or duplicate records using queries
• Use queries to obtain information useful to an organization
• Select the appropriate methods to generate a specific report
• Add controls to a report
• Select the methods to organize data in a report
• Create a report and organize its data

Personalizing and Maintaining Access 2003

• Select methods of customizing the Access 2003 working environment
• Select methods of maintaining an Access 2003 database
• Perform backup and view dependencies in Access 2003
• Maintain a database and customize the working environment

Enhancing Tables, Forms, and Reports in Access 2003

• Select the appropriate methods of allowing tables to access related data
• Apply data validation to tables
• Access and validate table data
• Add a subform and a subreport
• Create a switchboard form
• Apply conditional formatting to a form
• Add subforms and conditional formatting to a form interface and a switchboard to a database

Advanced Querying in Access 2003

• Use joins and parameter queries to obtain specific data
• Use an action query to modify records
• Use action queries to delete and copy data
• Edit a SELECT query using SQL
• Create queries to combine, update, and filter data

Working with Data and Presentation in Access 2003

• Select appropriate methods of adding data to a database by importing or linking
• Select the appropriate methods to export Access data to a suitable format
• Use Access 2003 to import and export appropriately formatted data
• Use a PivotTable view to present data
• Use a PivotChart view to present data
• Organize data with PivotTables and PivotCharts

Access 2003 and the Web

• Create a hyperlink address
• Implement the correct procedures for building and maintaining a data access page
• Prepare a data access page for different deployment scenarios
• Create a formatted data access page for a deployment scenario

Access 2003 Programmability

• Create a macro for a typical Access 2003 task
• Launch, modify, and debug macros
• Use the Visual Basic Editor to allow a database object to start handling users' actions
• Create a macro and an event handler

Database Administration in Access 2003

• Implement methods of securing database information for a given scenario
• Set a database password and secure VB code in a given scenario
• Implement methods of sharing database information for a given scenario
• Implement methods of creating and synchronizing replicas for a given scenario
• Share and replicate database information for a particular scenario
• Implement procedures to improve the performance of a database