Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
Learn the basics of building an Access database. Learn step-by-step how to create tables, queries, forms and reports.
A relational database application such as Microsoft Office Access 2016 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 2016 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.
Course Content
- 6 section(s)
- 42 lecture(s)
- Section 1 Getting Started with Access
- Section 2 Working with Table Data
- Section 3 Querying a Database
- Section 4 Using Forms
- Section 5 Generating Reports
- Section 6 Course Follow Up
What You’ll Learn
- 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.
Skills covered in this course
Reviews
-
HHal Brown
I have started this course as a prerequisite to the intermediate and advanced courses. The instructor is so clear and detailed that I went back to this first course to be sure I didn't miss anything.
-
RRandy L. Meadath
I enjoyed the course. Sometimes he moved his mouse pointer to a place on the ribbon so fast I wasn't always sure what he selected
-
CCasey McCormick
Good quality.
-
SSheryl Mesde
The content is good, but I am a bit bothered listening to the speaker because I can hear him catching his breathe after each sentence.