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 Access
Lectures -47
Resources -10
Duration -2 hours
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 you to create databases, to 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 Student:
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
What will you learn in this course:
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
What are the prerequisites for this course?
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
SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.
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 nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now