Tutorialspoint

#May Motivation Use code MAY10 for extra 10% off

Microsoft Office Access 2016: Part 1 (Beginner)

person icon Sonic Performance

3.9

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.

updated on icon Updated on May, 2024

language icon Language - English

person icon Sonic Performance

English [CC]

category icon Office Productivity,Microsoft Access

Lectures -47

Resources -10

Duration -2 hours

3.9

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

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.

Microsoft Office Access 2016: Part 1 (Beginner)

Curriculum

Check out the detailed breakdown of what’s inside the course

Getting Started with Access
13 Lectures
  • play icon Getting Started with Access 2016 - Introduction 03:04 03:04
  • play icon Orientation to Access 04:28 04:28
  • play icon Access vs. Excel 02:20 02:20
  • play icon Navigate Tables 03:56 03:56
  • play icon Navigate and Edit Data in Forms 02:05 02:05
  • play icon Relational Databases 03:42 03:42
  • play icon Use Queries - Introduction 01:32 01:32
  • play icon Use Queries 01:50 01:50
  • play icon Use Reports 02:28 02:28
  • play icon Create a New Database 06:56 06:56
  • play icon Get Help 05:12 05:12
  • play icon Configure Options in Access 06:03 06:03
  • play icon Microsoft Access 2016 Part 1 Quiz 1
Working with Table Data
8 Lectures
Tutorialspoint
Querying a Database
9 Lectures
Tutorialspoint
Using Forms
7 Lectures
Tutorialspoint
Generating Reports
9 Lectures
Tutorialspoint
Course Follow Up
1 Lectures
Tutorialspoint

Instructor Details

Sonic performance

Sonic performance


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual 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

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515