Take this
course

Office Productivity / Microsoft

Access 2016 Introduction

An introduction to Access 2016. Get started with creating databases and becoming familiar with the Access environment.

Description

This course is an introduction to Microsoft Access 2016. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2016 Intermediate course. 


Instructor: Ed McCrae

Full details

Curriculum

  • Introduction
    Introduction
    0:59
    Course Exercise Files
  • Getting Started
    What is a Database?
    1:57
    Understanding Database Terminology
    5:19
    Navigating the Access Interface
    6:12
    What is a Flat File Database?
    4:27
    What is a Relational Database?
    8:50
    Relating Tables
    5:32
    Reviewing the Access Ribbon
    3:37
  • Working with Data
    Working with Tables
    3:30
    Navigating Tables
    1:45
    Editing Data 
    3:01
    Adding New Records
    2:13
    Using Subdata Sheets
    2:53
  • Creating Databases and Objects
    Understanding Database and Table Design Principles
    10:27
    Using Table Data Sheet View
    4:07
    Working with Field Data Types
    4:00
    Using Table Design View
    3:32
    Using Calculated Fields
    3:52
    Calculating Numbers
    3:21
    Calculating Dates
    1:28
    Calculating Strings
    2:10
    Using the Lookup Wizard
    4:37
    Editing Lookups
    4:06
    Using Indexes
    1:47
  • Working with Queries
    What are Queries?
    3:04
    Creating Simple Queries
    4:32
    Understanding the Dynaset
    2:04
    Entering Criteria: Exact Match and Range Operators
    4:07
    Understanding AND versus OR
    3:20
    Using Wild Cards
    2:21
    Using Key Words
    2:33
    Sorting and Hiding Fields
    1:50
    Creating Multi-Table Queries
    3:20
    Additional Tips
    3:00
  • Working with Reports
    What are Reports?
    2:40
    Understanding Report Types
    2:46
    Building Effective Reports
    1:54
    Using AutoReport
    3:42
    Understanding the Report Wizard
    3:52
    Using the Report Design View
    8:16
    Creating Labels
    2:30
  • Working with Forms
    What are Forms?
    4:04
    Understanding Form Types
    1:47
    Creating Forms
    2:03
    Navigating Forms
    1:40
    Editing Data in Forms
    3:07
    Understanding the Form Wizard
    2:56
    Using the Form Design View
    3:41
    Working with Controls
    2:53
    Using Form Layout View
    2:11
    Additional Tips
    2:29
  • Conclusion
    Course Recap
    1:07

Skills

  • Database Management
  • Microsoft Access

Similar Courses

More Courses by this Instructor