Description

Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. This Access 2016 Introduction is designed for beginners so that even if you've never so much as opened the program before, you can learn how to use it like a pro.

This course covers all the important features of Access 2016 and demonstrates how to use them. Here you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records. This course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage.

What Will I Learn?

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

Requirements

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

Who is the target audience?

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

Introduction
	Intro	FREE	00:01:00
Getting Started
	What is a database		00:02:00
	Understanding Database terminology		00:05:00
	Navigating the Access Interface		00:06:00
	What is a flat file database		00:04:00
	What is a relational database		00:09:00
	Relating Tables		00:06:00
	Reviewing the Access Ribbon		00:04:00
Working with Data
	Working with Tables		00:04:00
	Navigating Tables		00:02:00
	Editing Data		00:03:00
	Adding New Records		00:02:00
	Using Subdata Sheets		00:03:00
Creating Databases and Objects
	Understanding Database and Table Design Principles		00:10:00
	Using Table Data Sheet View		00:04:00
	Working with Field Data Types		00:04:00
	Using Table Design View		00:03:00
	Using Calculated Fields		00:04:00
	Calculating Numbers		00:03:00
	Calculating Dates		00:01:00
	Calculating Strings		00:02:00
	Using the Lookup Wizard		00:05:00
	Editing Lookups		00:04:00
	Using Indexes		00:02:00
Working with Queries
	What are Queries		00:03:00
	Creating Simple Queries		00:04:00
	Understanding the Dynaset		00:02:00
	Entering Criteria- Exact Match and Range Operators		00:04:00
	Understanding AND v. OR		00:03:00
	Using Wild Cards		00:02:00
	Using Key Words		00:03:00
	Sorting and Hiding Fields		00:02:00
	Creating Multi-Table Queries		00:03:00
	Additional Tips		00:03:00
Working with Reports
	What are Reports		00:03:00
	Understanding Report Types		00:03:00
	Building Effective Reports		00:02:00
	Using AutoReport		00:04:00
	Understanding the Report Wizard		00:04:00
	Using the Report Design View		00:08:00
	Creating Labels		00:02:00
Working with Forms
	What are Forms		00:04:00
	Understanding Form Types		00:02:00
	Creating Forms		00:02:00
	Navigating Forms		00:02:00
	Editing Data in Forms		00:03:00
	Understanding the Form Wizard		00:03:00
	Using the Form Design View		00:04:00
	Working with Controls		00:03:00
	Using Form Layout View		00:02:00
	Additional Tips (2)		00:02:00
Conclusion
	Course Recap		00:01:00
Resources
	Resources - Access 2016 Introduction		00:00:00
Course Certification

Course Images

Access 2016 Introduction

By iStudy UK

Booking options

Highlights

Description

What Will I Learn?

Requirements

Who is the target audience?

About The Provider

Tags

Reviews