Access Foundation (Level 1)
Course length: 1-day
Microsoft’s Office Access is Microsoft’s popular database program. Microsoft Access is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data.
The Foundation (Level 1) Course is designed to help all novice computer users get up to speed on the program quickly. The class will also help more experienced users with previous Access versions to understand the ribbon interface.
Highlights of the course include a complete overview of the ribbon interface; information on getting started with databases; creating and using tables, forms, queries, and reports; and information on printing and viewing data in different ways.
This course is delivered using Access 2016. With the exception of the new modern look and touch screen support, there are few differences between the Office suites; therefore, users currently operating on Office 2010 and later will benefit from the material in this course.
Before attending this course, students must have:
- Basic computer knowledge
- Basic file management skills
- Basic Excel knowledge is helpful
The course begins with a look at how to get started with Access, create and save a database, and open an existing database. This module also includes information on database terminology.
- Getting Started
- Signing In
- Creating a Database
- Database Terminology
- Saving a Database
- Opening a Database
Navigating in an Access Database
This module discusses how to search for objects and open various database objects. Students will also learn how to change object views, manage objects, and work with security warnings.
- About Security Warnings
- Searching for Objects
- Opening Database Objects
- Changing the Object View
- Understanding the Types of Views Available
- Managing Objects
Understanding Table Relationships
Students will learn how to view relationships, view object dependencies, enforce referential integrity, and enforce cascade update and delete. Students also will learn about types of relationships and referential integrity.
- About Relationships
- Types of Relationships
- Viewing Relationships
- What is Referential Integrity?
- Enforcing Referential Integrity
- Using Cascade Delete and Cascade Update
Working with Tables and Records
This module takes a look at tables and records. Here, students will learn to create a table, add and edit database records, search and browse records, and delete and print records.
- Creating a Table
- Understanding Table Views
- Adding and Editing Records
- Searching and Browsing Records
- Deleting Records
Formatting Tables in Datasheet View
Students will learn to select data, change the size of rows and columns, apply text formatting and fill color, apply gridlines, and perform a spell check.
- Selecting Data
- Changing Column and Row Width and Height
- Applying Text Formatting
- Applying Gridlines
- Changing Fill Colors
- Checking Your Spelling
Students explore the various methods of creating forms from an object and using the wizard. Students will also learn how to use form views, and customize forms in Design View.
- Creating a Form from an Object
- Creating a Form with the Wizard
- Understanding Form Views
- Using a Form
Students learn to create a report from an object and by using the wizard. Students will also learn how to use report views, and print reports.
- Creating a Report from an Object
- Creating a Report with the Wizard
- Understanding Report Views
- Printing Reports
Creating Basic Queries
This module allows students to develop basic querying skills. They will learn how to create a query with the wizard and in Design View, run a query, sort and filter a query, and use criteria to specify the results of a query.
- Types of Queries
- Creating a Query
- Running a Query
- Understanding Query Views
- Sorting and Filtering a Query
Customizing the Interface
Students learn to collapse and pin the ribbon, customize the Quick Access toolbar, hide and show ribbon tabs, create custom tabs, and reset changes made to the interface.
- Collapsing and Pinning the Ribbon
- Customizing the Quick Access Toolbar
- Hiding and Showing Ribbon Tabs
- Creating Custom Ribbon Tabs
- Resetting Interface Changes