Access - Level 1 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 covers the basic skills and concepts students need to use Microsoft Access productively and efficiently. Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft Access can help you and your organization with this task. The Access - Level 1 Class focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. This course is the first 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 create and manage an Access database.
You will:

Navigate within the Access application environment, create a simple database, and customize Access configuration options.
Organize and manage data stored within Access tables.
Use queries to join, sort, and filter data from different tables.
Use forms to make it easier to view, access, and input data.
Create and format custom 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

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 2
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: Working with an Access Database
Topic A: Launch Access and Open a Database
Topic B: Use Tables to Store Data
Topic C: Use Queries to Combine, Find, Filter, and Sort Data
Topic D: Use Forms to View, Add, and Update Data
Topic E: Use Reports to Present Data
Topic F: Get Help and Configure Options in Microsoft Access

Lesson 2: Creating Tables
Topic A: Plan an Access Database
Topic B: Start a New Access Database
Topic C: Create a New Table
Topic D: Establish Table Relationships

Lesson 3: Creating Queries
Topic A: Create Basic Queries
Topic B: Add Calculated Columns in a Query
Topic C: Sort and Filter Data in a Query

Lesson 4: Creating Forms
Topic A: Start a New Form
Topic B: Enhance a Form

Lesson 5: Creating Reports
Topic A: Start a New Report
Topic B: Enhance Report Layout

Course FAQs

What are the available class formats?

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

What is a Microsoft Access database?

A Microsoft Access database is a computer application used to store and manipulate data. It is a part of the Microsoft Office suite of applications, which also includes Word, Excel, PowerPoint, and Outlook. Access is designed to work with data stored in other applications, such as Microsoft SQL Server or Oracle Database.

Access databases are often used to store data for small businesses or organizations. They can be used to track customer information, inventory, employee records, and more. Access databases can be created using the Access software application or by exporting data from another application, such as Excel.

Access databases are typically stored on a computer's hard drive, but they can also be stored on a network drive or on a removable storage device, such as a USB flash drive. When storing an Access database on a network drive or removable storage device, it is important to ensure that the file is properly backed up in case of data loss.

What are tables in Microsoft Access?

Tables are a database component in Microsoft Access that stores information in a structured format. Tables are the basis for all data stored in an Access database. All data in an Access database is stored in tables.

Tables consist of rows and columns, with each row representing a record, and each column representing a field. Fields can contain various types of data, such as text, numbers, or dates. Tables can be related to each other through relationships, which are used to link data from multiple tables together.

What are Microsoft Access queries?

Microsoft Access queries are a powerful way to retrieve and manipulate data from your database. Queries can be used to find specific records, calculate summaries, or even create new tables and forms. With the right query, you can make working with your data much easier and more efficient.

Creating a query is simple: just specify the criteria you want to use and Access will do the rest. For example, you can use a query to find all the orders placed by a particular customer, or all the products in a certain category. You can even use queries to generate custom reports.

There are two main types of queries: Select and Action. Select queries are used to retrieve data from your database, while Action queries can be used to add, change, or delete data.

What are Microsoft Access forms?

Microsoft Access forms are an essential part of the application. They provide a user-friendly way to enter, view, and edit data. Forms can also be used to create custom reports and queries.

When creating a form, you can choose from a variety of form templates, or you can create a custom form. Forms can be created in Layout view or Design view.

Layout view is a drag-and-drop interface that lets you quickly create a form. Design view gives you more control over the form's design, and is better suited for complex forms.

Once a form has been created, it can be customized to match your specific needs. For example, you can add or remove fields, change the layout of the form, and add graphics or other objects.

Forms are an essential part of Microsoft Access and can be used to make your application more user-friendly and efficient.

What are Microsoft Access reports?

Microsoft Access reports are a great way to collect and present data. Reports can be used to show data in tabular, summary, or detail form. They can also be used to create charts and graphs. Reports can be printed or exported to other file formats.

Creating a report is easy with Microsoft Access. Simply select the fields you want to include in the report, and then choose a layout. Access will automatically generate the report. You can then print or export the report as needed.