Mastering Access 2016 – Basics
Duration
2h 57m
Students
0
Level
Beginner
Last Updated
December 16, 2024
Create custom databases with this modern data-crunching powerhouse!
Microsoft Access lets ordinary users develop powerful databases customized for their business needs. You can learn to build and share a simple database in no time at all. It’s easy to create and structure your data, then build forms to enter data and reports to share data with others.
In this course, experienced Microsoft Access trainer Kathy Jones will walk you through building your first Microsoft Access database. You’ll learn to create your own tables to store the information you need. You’ll learn to sort, filter, and query the data in those tables. Kathy will also show you how to create forms for entering data into your Access database, and how to create, format, and run reports on your data.
- 19 Sections
- 2h 57m Duration
Introduction
Database Objects
Creating a Simple Access Database
Getting Help and Configuring Options
Modifying Table Date
Sorting and Filtering Records
Creating Basic Access Forms
Filtering Data in a Query
Sorting Data in a Query
Performing Calculations in a Query
Creating Basic Access Forms
Working with Data on Access Forms
Lookup Fields on a Form
Creating a Report
Adding Controls to a Report
Adding Logos and Colors
Preparing a Report for Print
Organizing Report Information
Formatting Reports
Free
Course Includes
- Navigating within Microsoft Access
- Creating an Access database
- Locating and changing data
- Sorting and filtering records in a table
- Creating a query
- Sorting and filtering data through a query
- Performing calculations through a query
- Creating a form
- Working with data in a form
- Creating a report
- Organizing and formatting reports
- Applying themes, fonts, and layout options
- Preparing a report to be printed
