Mastering Access 2016 — Basics

Create Custom Database Apps With This Modern Data-Crunching Powerhouse!

Instructor: Kathy Jones

Everything You Need To Know About Microsoft Access — Delivered In Easily Searchable, Highly Informative Video Lessons

Microsoft Access lets ordinary users develop powerful apps customized for their business needs.

In this course experienced Microsoft Access trainer Kathy Jones will walk you through building your first Microsoft Access database, including creating tables, using queries, and implementing forms and reports.

Objectives – You will be able to:

  • Navigate within Microsoft Access
  • Create an Access database
  • Use Access help and set configuration options
  • Efficiently locate and change data
  • Sort and filter records in a table
  • Create a query
  • Sort and filter data through a query
  • Perform calculations through a query
  • Create a form
  • Work with data in a form
  • Create a report
  • Add a control to a report
  • Apply themes, fonts, and layout options to a report
  • Prepare a report to be printed
  • Organize report information
  • Format a report

Course Length

Lessons : 19
Seat Time : 3 Hours

Lessons Include:

01: Introduction (10:31)
02: Database Objects (11:08)
03: Creating a Simple Access Database (11:23)
04: Getting Help and Configuring Options (5:09)
05: Modifying Table Date (11:03)
06: Sorting and Filtering Records (5:05)
07: Creating Basic Access Forms (7:59)
08: Filtering Data in a Query (14:30)
09: 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)

Trusted by Aspiring IT Professionals, Corporations and
Government agencies
for more than a Decade

Get unlimited online access learn anywhere, anytime using your computer or mobile device!