Microsoft Access Level 1

Overview: A relational database application such as Microsoft® Office Access® can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Objectives: In this course, you will create and manage an Access database. You will:

Navigate within the Microsoft 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

Course Outline:

Lesson 1: Getting Started with Access
• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data
• Modify Table Data
• Sort and Filter Records

Lesson 3: Querying a Database
• Create Basic Queries
• Sort and Filter Data in a Query
• Perform Calculations in a Query

Lesson 4: Using Forms
• Create Basic Access Forms
• Work with Data on Access Forms

Lesson 5: Generating Reports
• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• Prepare a Report for Print
• Organize Report Information
• Format Reports

Length of Class:
One Day
Instructor-led or Online:

View upcoming Class Schedule & Signup for a Class!