Mastering Access 2016 – Basics

Mastering Access 2016 - Basics

# of Lessons

19

Duration

2:56:27

Skill Level

Basic

MSRP

$30

Instructor(s)

Kathy Jones

Available Captions

Not Captioned

Also Included

Practice Files, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style! 

Everything you need to know about Microsoft Access–delivered in easily searchable, highly informative video modules

 

Microsoft Access lets ordinary users develop powerful apps customized for their business needs. You can build and share a database in seconds. You’ll be amazed at how easy it is to create and structure your data. You can also 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 show you how to create forms for entering data into your Access database, and how to create, format, and run reports on your data.

 

Topics covered include

  • Navigating within Microsoft Access
  • CreatingAccess database
  • UsingAccess help and setting configuration options
  • 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
  • Adding a control to a report
  • Applying themes, fonts, and layout options
  • Preparing a report to be printed
  • Organizingreport information
  • Formatting a report

 

Quickly search for and find the skills you want to master–then just point, click and learn!

 

High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style!

Course Contents:

#  Lesson  Length 
1  Introduction  10:31 
2  Database Objects  11:08 
3  Creating a Simple Access Database  11:23 
4  Getting Help and Configuring Options  5:09 
5  Modifying Table Date  11:03 
6  Sorting and Filtering Records  5:05 
7  Creating Basic Access Forms  7:59 
8  Filtering Data in a Query  14:30 
9  Sorting Data in a Query  8:37 
10  Performing Calculations in a Query  7:02 
11  Creating Basic Access Forms  7:59 
12  Working with Data on Access Forms  13:10 
13  Lookup Fields on a Form  11:08 
14  Creating a Report  7:41 
15  Adding Controls to a Report  8:17 
16  Adding Logos and Colors  5:50 
17  Preparing a Report for Print  3:45 
18  Organizing Report Information  13:22 
19  Formatting Reports  12:48 

Related Course Recommendations:

Mastering Access 2016 - Intermediate
Mastering Access 2016 - Advanced
Microsoft Teams Essentials 2021

Catalog Request

Login Logo