Microsoft Access 2003: Introduction for Beginners (2 day)

Course Overview

This course is designed to give course participants a good working knowledge of Access. Participants will learn how Access databases work, and gain an understanding of database design. It also introduces the design of on-screen forms and printed reports.

Participants will learn how to create Access databases, and gain an understanding of database design. The course will cover how to enter or edit data in tables, as well as how to create a variety of queries for finding, sorting and retrieving data in Access databases and analysing trends. The course also provides an introduction to designing forms for editing data on-screen and designing reports for printing information from the database.

CourseMonster tracks Microsoft training and can notify you when the next Microsoft Access course is available in your area. Contact us for more details.

Related Courses

• Microsoft Access 2003: Introduction for Beginners (1 day)
• Microsoft Access 2003: Advanced (1 day)
• Microsoft Access 2003: Intermediate (2 day)
• Microsoft Access 2003: Advanced (2 day)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2003: Intermediate (1 day)
• Microsoft Access 2002 2003: Advanced Development in Microsoft Access
• Microsoft Access 2003: Programming with VBA

Audience

Anyone who needs to create relational databases using Access and needs to gain an understanding of the basics of database design, and existing users who wish to improve their knowledge and understanding of Access databases.

Prerequisites

It is essential that course participants have successfully completed a Windows Introductory course, or have gained similar knowledge within the work environment. Familiarity with any database product would also be useful.

Course Outline

• Access database features and objects, the Access screen, the database window, common terminology, comparison of relational and flat file databases.
• Using the Table Wizard, creating tables manually to store data, creating and changing table field properties, creating relationships between tables, indexing fields to speed up record retrieval, setting a primary key field.
• Creating rules and input masks to validate data input, navigating through the data in a table, finding and replacing data, sorting columns in tables, applying and removing filters, filter criteria, saving filters as queries.
• Retrieving records from a table or from several tables by designing queries, adding search criteria to restrict the records that are retrieved, using parameter queries to allow the user to input query criteria.
• Changing the joins between tables in a query to control the selection of records retrieved, creating calculated fields in queries, summarising data using query totals and crosstab queries, using action queries to enable repetitive updates or deletions in tables.
• Using name autocorrect to track and manage changes to database object names.
• Creating forms using the Form Wizard and the autoform options, manually editing forms to format the appearance of data for editing or viewing and using Control Wizards to add combo boxes to forms.
• Producing printed reports using the Report Wizard, creating reports grouped or sorted on one or more fields, producing summary information in a report and using the expression builder to generate calculations on reports.