Microsoft Access 2003: Introduction for Beginners (2 day)

About this class

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.

This training may be available onsite; please contact us if you are interested.

Who will the lesson benefit?

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.

Examination details

This course will prepare you for the following exams and certification tracks shown. Please note that the exam may not be included in the price shown: please contact us to check.

Microsoft® Certification Tracks  »
    Microsoft® Exams  »
       Exam access2003: MOS: Access 2003
       Elective (MOS - Master 2003)  »
          MOS: Access 2003
          MOS: Access 2003
          MOS- Access 2003  »
             Exam access2003: MOS: Access 2003

What prerequisites are required

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.

Contents of this class

• 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.