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
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
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.
![Microsoft Office Access 2016: Part 1 (Beginner) Microsoft Office Access 2016: Part 1 (Beginner)](https://d3mxt5v3yxgcsr.cloudfront.net/courses/6684/course_6684_image.jpg)
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
![Tutorialspoint](/market/public/assets/images/loader.gif)
Querying a Database
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Using Forms
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Generating Reports
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Course Follow Up
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Sonic performance](https://www.tutorialspoint.com/assets/profiles/421859/profile/200_2468965-1643349638.jpg)
Sonic performance
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
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![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)