Access 2016 Introduction

Name: Access 2016 Introduction
Rating: 4.5 (158 reviews)

Learn the basics of building an Access database with well built tables, queries, forms and reports.

Created byIntellezy Trainers

Last updated 3/2018

English

What you'll learn

Understand Databases and Database Terminology
Work with Data
Create Databases and Objects
Work with Queries
Work with Reports
Work with Forms

Course content

9 sections • 52 lectures • 2h 56m total length

Introduction1:03

What is a Database?1:56
Understanding Database Terminology5:18
Navigating the Access Interface6:11
What is a Flat File Database?4:26
What is a Relational Database?8:49
Relating Tables5:31
Learn to relate tables in Access 2016 by creating one-to-many relationships between orders, order details, and products, enforcing referential integrity, and using subdata sheets to view and enter related records.
Reviewing the Access Ribbon3:36

Understanding Database and Table Design Principles10:26
Using Table Data Sheet View4:06
Working with Field Data Types3:59
Explore design view to see how data types shape storage and entry, including text, numbers, date and time, currency, auto number, yes/no, and lookup wizard options.
Using Table Design View3:31
Explore the table design view in Access 2016, review fields, data types, and field properties, and learn how design settings flow to forms, primary keys, lookups, and relationships.
Using Calculated Fields3:51
Calculating Numbers3:20
Calculating Dates1:27
Create a calculated field called ship by date in the orders table using order date plus four days, and confirm in the datasheet that the ship by date updates automatically.
Calculating Strings2:09
Learn to create a calculated string field that joins last name and first name into a file as field using ampersands and quotes for punctuation in Access 2016.
Using the Lookup Wizard4:36
Editing Lookups4:05
Learn to create and customize lookups in Access 2016 without the Lookup Wizard, using a combo box bound to a table or query, and edit lookups for related fields.
Using Indexes1:46

What are Queries?3:03
Creating Simple Queries4:31
Understanding the Dynaset2:03
Entering Criteria: Exact Match and Range Operators4:06
Learn to refine access queries with criteria, using less than, between, and exact-match conditions in design view, and save each criteria set as separate queries across multiple fields.
Understanding AND versus OR3:19
Using Wild Cards2:20
Using Keywords2:32
Sorting and Hiding Fields1:49
Creating Multi-Table Queries3:19
Additional Tips2:59
Learn practical tips for troubleshooting common query design mistakes in Access 2016, including removing duplicate tables, navigating the design view, rearranging fields, and avoiding accidental action queries.

What are Reports?2:39
Understanding Report Types2:45
Building Effective Reports1:53
Using AutoReport3:41
Learn to use the AutoReport tool in Access 2016 to create and customize a report from a query, and perform design view edits to adjust layout and remove outlines.
Understanding the Report Wizard3:51
Use the report wizard in Access 2016 to create reports from queries or multiple tables with grouping by category and product, and customize layout.
Using the Report Design View8:15
Creating Labels2:29

What are Forms?4:03
Understanding Form Types1:46
Creating Forms2:02
Navigating Forms1:39
Editing Data in Forms3:06
Understanding the Form Wizard2:55
Using the Form Design View3:40
Explore the form design view in Access 2016, covering headers, detail sections, and footers, then configure labels and controls, adjust properties, tab order, arrangement, and formatting.
Working with Controls2:52
Explore bound and unbound controls in Access 2016, learn how bound controls connect to fields, use unbound text boxes for formulas, and move, resize, delete, undo in design view.
Using Form Layout View2:10
Additional Tips2:28

Requirements

Basic computer skills. Knowledge of basic database concepts is helpful but not required.

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 a basic database, create tables, queries, reports and forms, perform calculation with fields, numbers, and dates, navigate and work with tables and the various data types, understand and work with select queries, review and work with various reports and reporting features, and review data entry 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.

Who this course is for:

Students who want to learn database concepts and build basic databases.

Access 2016 Introduction

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Getting Started7 lectures • 36min

Working with Data5 lectures • 13min

Creating Databases and Objects11 lectures • 43min

Working with Queries10 lectures • 30min

Working with Reports7 lectures • 26min

Working with Forms10 lectures • 27min

Conclusion1 lecture • 1min

Access 2016 Advanced Assessments0

Requirements

Description

Who this course is for: