Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Access 2019 Beginner Tutorial

Learnit Training via YouTube

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course is designed to help beginners through experienced users sharpen their skills and increase efficiency in Microsoft Access. By the end of the course, learners will be able to navigate a completed database, design and create database tables, import and enter table data, create queries, forms, and reports, understand table relationships, and utilize advanced report and form design techniques. The teaching method includes hands-on exercises, demonstrations, and step-by-step guidance. The intended audience for this course includes individuals looking to enhance their knowledge of Microsoft Access and improve their database management skills.

Syllabus

Start
Introduction
How Databases Operate
Accessing Databases
Exploring Relational Databases
Examining Database Objects
How Data is Related Between Tables
Understanding the Access Interface
Planning Steps and Naming Conventions for New Databases
Planning Tables
Creating Tables in Design View
Importing Data from Excel into New Tables
Modifying New Table Imports
Importing to Existing Tables
Importing to Existing Tables by Yourself
Manually Entering Data in a Table
Sorting and Filtering Data
Creating Table Relationships
Using the Simple Query Wizard
Creating Queries in Design View
Customizing Queries with Criteria
Conclusion

Taught by

Learnit Training

Reviews

Start your review of Access 2019 Beginner Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.