MICROSOFT ACCESS

Microsoft Access, the database application of Microsoft Office, makes it easy to record large volumes of related data and track it using a variety of tools. In addition to simple tools, such as sorting, Access includes powerful tools for retrieving, reviewing and reporting on data.

• Full Day Class (8:15 am - 4:30 pm)
• Sample: Table Of Contents (PDF)
• Sample: Class Excerpt
  Click the link to view a sample of this class' "slide show". The slide images are large, so please be patient while they load.

Overview

In this class participants learn to create an Access database, populate it with tables to store data, build queries to find information, create forms to display data and reports to print the data. The primary focus is on table and query design, including the construction of simple calculations in queries. The section on table design includes information about controlling user entry with field properties that check for invalid information, as well as tips on how to make a database more user-friendly.

Objectives

• Understand fundamental Access concepts: tables, records, fields, queries, forms and reports.
• Learn basic table use: build tables with the table wizard, add, edit and delete records, freezing and moving columns.
• Design tables: understand field definitions and properties.
• Use more advanced table features: sorting data, finding records, applying filters.
• Explore queries: learn how queries can retrieve and create data.
• Build forms: create a pleasant data entry environment.
• Work with reports: arrange data for printing.

Prerequisite(s)

• Introduction To Windows
  Or Equivalent Experience Using Windows-Based Computers

Other Information

• In addition to the formal prerequisite above, basic experience with Microsoft Word is helpful but not necessary.
• If you have questions about this class' content or prerequisites, please contact us.

• Full Day Class (8:15 am - 4:30 pm)
• Sample: Table Of Contents (PDF)
• Sample: Class Excerpt (PDF)
  Intermediate Access is written in a book-style format in order to engage in the necessary depth and complexity required for this class. As a result, the sample is meant to be viewed in printed form and may not display with full clarity when viewed on screen.

Overview

Students learn additional database design techniques in this workshop-style class. Participants are encouraged to ask questions based on their own needs and experience, with answers provided by the instructor. Common questions address the creation of drop-down lists in tables, forms with subforms and setting relationships between database tables. The expansive possibilities offered by queries are usually highlighted through various demonstrations. Other common topics include retrieving data from a non-Access source and controlling the user interface.

Objectives

• Create lookup fields in tables.
• Understand table relationships and referential integrity.
• Add a combo box to a form in order to easily locate and move to specific records.
• Build subforms to display subsets of data related to the information on a form.
• Learn to use the four types of action queries.
• Work with queries that involve multiple tables.
• Summarize the data in a query through the use of the summary options.
• Use Access' linking ability to work with data from external sources such as text files and other Access databases.
• Add a main control panel to a database and use Access' startup options to display it when the database is loaded.

Prerequisite(s)

• Introduction To Access
  Or Equivalent Experience

Other Information

• If you have questions about this class' content or prerequisites, please contact us.

If you have usability issues with this web site, or if it does not render properly in your browser, please tell the "webmaster" (we use that term loosely). We're striving to make it as standards- and accessibility-compliant as we can, but we haven't had the opportunity to test all platforms, browsers, environments, etc.