Microsoft Office Access 2016: Part 1 (Beginner)
Learn the basics of building an Access database. Learn step-by-step how to create tables, queries, forms and reports.
Office Productivity,Microsoft,Microsoft Access
Lectures -47
Resources -10
Duration -2 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
A relational database application such as Microsoft Office Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports, and creating queries to join, filter, and sort data.
Using Access is a wise decision when you have to manage a lot of data. Maybe you already tried and found out that especially the first steps can be complicated. In this basic course, you will learn how to create databases, understand relationships between databases and how to establish them. These first steps will enable you to perform queries on a database and create reports.
Target audience:
This course is designed for people who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.
Goals
Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
Organize and manage data stored within Access tables.
Use queries to join, sort, and filter data from different tables.
Use forms to make it easier to view, access, and input data.
Create and format custom reports.
Prerequisites
Just basic computer skills.

Curriculum
Check out the detailed breakdown of what’s inside the course
Getting Started with Access
13 Lectures
-
Getting Started with Access 2016 - Introduction 03:04 03:04
-
Orientation to Access 04:28 04:28
-
Access vs. Excel 02:20 02:20
-
Navigate Tables 03:56 03:56
-
Navigate and Edit Data in Forms 02:05 02:05
-
Relational Databases 03:42 03:42
-
Use Queries - Introduction 01:32 01:32
-
Use Queries 01:50 01:50
-
Use Reports 02:28 02:28
-
Create a New Database 06:56 06:56
-
Get Help 05:12 05:12
-
Configure Options in Access 06:03 06:03
-
Microsoft Access 2016 Part 1 Quiz 1
Working with Table Data
8 Lectures

Querying a Database
9 Lectures

Using Forms
7 Lectures

Generating Reports
9 Lectures

Course Follow Up
1 Lectures

Instructor Details

Sonic performance
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now