Access - Level 2 Course

Course Details:

Length: 2 days

Price: $550/person (USD)

Bundle & Save: View Bundle

Group Price: Request Quote

Training Reviews

Course Features:

Live Instructor Teaching

Certificate of Completion

Digital Badge

Courseware: Print

Free 6 Month Online Retake

Hands-On Learning?: Yes

Software Lab Included?: Yes

Delivery Methods:

Live Online

Individuals and Groups
@ Your Location

Onsite for Teams

Group Teams
@ Your Organization

This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.


Course Overview

This 2-day course provides students with additional skills and concepts needed to use Microsoft Access productively and efficiently. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users. The Access - Level 2 Class focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports. This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access. For comprehensive certification training, students should complete the Level 1, 2 and 3 courses for Access.

Learning Objectives

In this course, you will optimize an Access database.
You will:

  • Provide input validation features to promote the entry of quality data into a database.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Improve the usability of Access tables.
  • Create advanced queries to join and summarize data.
  • Use advanced formatting and controls to improve form presentation.
  • Use advanced formatting and calculated fields to improve reports.

Register Early: Registration Deadline is 2 Weeks Prior to Class Start.

Course Notes

Versions That Can Attend: Desktop Version of Office 2021, 365, 2019, 2016 (Microsoft Windows PC or Macintosh)
Course Taught With: Desktop Version of Office version 365/2019 (Microsoft Windows PC) Software and Courseware

Target Audience

This course is designed for students looking to establish a foundational understanding of Microsoft Access for Office 365/2019, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Knowledge Prerequisites

Access - Level 1
• Also, to ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. You can obtain this level of skills and knowledge by taking the Windows for End Users Course.

Suggested Follow-Ons

Access - Level 3

Related Certifications

MOS: Microsoft Access Expert Certification

Certification Notes: Certification exams are administered by third party testing companies. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact the corresponding testing provider to take a certification exam.


Course Topics

Lesson 1: Promoting Quality Data Input
Topic A: Restrict Data Input through Field Validation
Topic B: Restrict Data Input through Forms and Record Validation

Lesson 2: Improving Efficiency and Data Integrity
Topic A: Data Normalization
Topic B: Associate Unrelated Tables
Topic C: Enforce Referential Integrity

Lesson 3: Improving Table Usability
Topic A: Create Lookups within a Table
Topic B: Work with Subdatasheets

Lesson 4: Creating Advanced Queries
Topic A: Create Query Joins
Topic B: Create Subqueries
Topic C: Summarize Data

Lesson 5: Improving Form Presentation
Topic A: Apply Conditional Formatting
Topic B: Create Tab Pages with Subforms and Other Controls

Lesson 6: Creating Advanced Reports
Topic A: Apply Advanced Formatting to a Report
Topic B: Add a Calculated Field to a Report
Topic C: Control Pagination and Print Quality
Topic D: Add a Chart to a Report

Course FAQs

What are the available class formats?

This course is taught by a live instructor and is available in two class formats:

  1. Live Online for Individuals
  2. Onsite/Online for Private Groups

What is database quality input?

One of the most important aspects of any database is the quality of the input. Database quality input refers to the cleanliness, accuracy, and completeness of the data that is entered into a database. Poor quality input can lead to a number of problems, including inaccurate results, inconsistency in reports, and incorrect data analysis.

There are a number of ways to ensure high quality input. First, it is important to have clear and concise rules for data entry. Any ambiguity in the rules can lead to errors. Second, it is important to have a system in place to check for errors. This can be done manually or through the use of software tools. Third, it is important to have a system in place to track changes to the data. This helps to ensure that any errors can be corrected and that the database is always up-to-date.

By following these tips, you can help to ensure that your database has high quality input and avoid many of the problems that can occur with poor quality data.

How do you improve efficiency and data integrity in a database?

There are a number of ways to improve efficiency and data integrity in a database. One way is to use a normalized database design. This means that the data is organized into tables and columns in such a way that redundancy is minimized and data dependencies are clearly defined. Another way to improve efficiency and data integrity is to use proper indexing. Indexing allows for quick retrieval of data from a database. Finally, using proper security measures can help to ensure that data is not compromised.

How do you improve table usability in Microsoft Access?

There are a few simple ways to improve table usability in Microsoft Access. One way is to use the AutoFormat feature. This can be found under the Format menu. Another way is to use the Datasheet View options. These can be found under the View menu. Finally, you can use the Table Design options. These can also be found under the View menu. By using these features, you can improve the usability of your tables in Microsoft Access.

If you want to further improve table usability in Microsoft Access, consider using some of the following tips:

- Use field names that are easy to understand and describe the data they contain.

- Use clear and concise data entry forms.

- Use consistent field sizes and formats.

- Use meaningful table and field names.

- Avoid using abbreviations.

By following these tips, you can further improve the usability of your tables in Microsoft Access.

What are Microsoft Access advanced queries?

Microsoft Access offers a robust and versatile platform for creating powerful queries. Advanced queries in Microsoft Access can be used to find specific information or groups of data, and can be customized to return the results you need.

There are four main types of advanced queries in Microsoft Access: crosstab queries, make-table queries, append queries, and update queries.

Crosstab queries are used to summarize data from multiple records into a single table. This can be useful for finding trends or patterns in your data.

Make-table queries are used to create new tables from existing data. This can be useful for creating backups of your data or for creating new tables with specific information that you want to analyze further.

Append queries are used to add records from one table to another. This can be useful for consolidating data from multiple tables into a single table.

Update queries are used to modify existing data in a table. This can be useful for correcting errors in your data or for updating information in multiple records at once.

Advanced queries in Microsoft Access can be created using the Query Wizard or by creating a query in SQL view.

What is form formatting in Microsoft Access?

Form formatting in Microsoft Access is the process of creating a visually appealing and easy-to-use form. By taking advantage of the various tools available, you can create forms that are both aesthetically pleasing and functional.

There are a few things to keep in mind when Formatting Forms:

Layout: The layout of your form is important to consider. You want to make sure that your form is easy to read and navigate. One way to achieve this is to use a grid layout. This will ensure that your form elements are evenly spaced and easy to find.

Colors: The use of color can also be helpful in creating an appealing form. Choose colors that are complementary to each other and easy on the eyes.

Text: The text on your form should be legible and easy to read. Consider using a sans serif font such as Arial or Helvetica.

Images: If you plan on using images on your form, make sure that they are high quality and relevant to the content of your form.

These are just a few tips to keep in mind when formatting your Microsoft Access forms. By taking the time to format your forms correctly, you can create a more professional and user-friendly experience for your users.

What are Microsoft Access advanced reports?

Microsoft Access offers a variety of advanced reports that can be used to further analyze your data. These reports can be used to identify trends, spot errors, and track progress over time.

Some of the most popular advanced reports in Microsoft Access include:

-Pivot Tables: Pivot tables are a powerful way to summarize data and identify trends. They can be used to track progress over time, compare different groups of data, and more.

-Charts and Graphs: Charts and graphs are a visual way to represent data. They can be used to spot trends, compare different groups of data, and more.

-Conditional Formatting: Conditional formatting allows you to highlight certain data points based on conditions that you set. This can be used to identify errors, track progress over time, and more.

-Macros: Macros are a way to automate repetitive tasks in Access. They can be used to populate reports with data, run queries, and more.

Explore Microsoft Access Training Classes Near Me:


Start your training today!