Access 2016 Essentials
Database application for PC12 H 54 M
Master Microsoft Access with the whole team. Learn basic terminology and key concepts of relational database design in the Access interface.
Episodes
Episodes
- Introduction
- Overview
- Introduction to Access
- What is a Database
- Database Terminology
- Database Terminology Part 2
- Getting Started in Access
- Access Interface and Navigation
- Planning and Database Design
- Planning and Database Design Part 2
- Creating Access Tables
- Creating Tables: Manual Data Entry
- Creating Tables: Importing External Data
- Creating Tables: Importing External Data Part 2
- Creating Table Relationships
- Creating Table Relationships Part 2
- Creating Queries for Testing Design
- Creating Queries for Testing Desgin
- Creating Queries for Testing Design Part 2
- Creating Queries for Testing Design Part 3
- Creating Queries for Testing Design Part 4
- Creating Queries for Testing Design Part 5
- Creating Basic Forms
- Creating Basic Forms
- Creating Basic Forms Part 2
- Creating Basic Forms Part 3
- Creating Basic Forms Part 4
- Reporting Data
- Creating Basic Reports
- Creating Basic Reports Part 2
- Creating Basic Reports Part 3
- Creating Basic Reports Part 4
- Creating Basic Reports Part 5
Overview
10 M



- Episode Description
- Transcript
Access is the database application within the Microsoft Office suite. Many businesses, large and small, use Access to store large amounts of information. Just like building a strong house, you must have a solid foundation. We start from the very beginning discussing how to plan a database, introducing basic terminology and key concepts of relational database design, and exploring the Access Interface. Then we dive more in depth into each object in an Access databases - tables, queries, forms, and reports. This series is targeted for users who want to get started in Access or users that want a refresher on Access essentials. Access is a Windows only product and only available as a local installation.
Just you? Training a whole team? There's an ITProTV plan that fits.
With more than 5,800 hours of engaging video training for IT professionals, you'll find the courses you and your team need to stay current and get the latest certifications.