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 .

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: