Tutorialspoint

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.

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.

Show More

Curriculum

  • Getting Started with Access 2016 - Introduction
    03:04
    Preview
  • Orientation to Access
    04:28
  • Access vs. Excel
    02:20
    Preview
  • Navigate Tables
    03:56
  • Navigate and Edit Data in Forms
    02:05
  • Relational Databases
    03:42
  • Use Queries - Introduction
    01:32
  • Use Queries
    01:50
  • Use Reports
    02:28
  • Create a New Database
    06:56
  • Get Help
    05:12
  • Configure Options in Access
    06:03
  • Microsoft Access 2016 Part 1 Quiz 1
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Microsoft Office Access 2016: Part 1 (Beginner)
This Course Includes
  • 2 hours
  • 47 Lectures
  • 10 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate