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.
Just you? Training a whole team? There's an ITProTV plan that fits.
Start Training TodayEpisodes
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.