• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

MS Access 2016 Introduction

MS Access 2016 Introduction

By John Academy

4.3(43)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 3 hours 1 minutes

  • All levels

Description

Description

As a beginner, do you want to learn about MS Access? Are you interested to know its various function and use? Do you want to be an expert in this field? If so, take a look at our MS Access 2016 Introduction course. It will assist you in understanding all you need to learn about this course.

The course designs for the fresher who have a little or no basic knowledge of MS Access. It teaches you how to create, open, and save an Access database. It will acquaint you with the basic equipment such as ribbons and toolbar so that you can get access it flexibly to create a table, and store date smoothly. It introduces you to numeric and index field with a plenty of practical exercises so that you can learn the basic of MS Access 2016 effectively.

Assessment:

This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.

Certification:

After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

Who is this Course for?

MS Access 2016 Introduction is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Requirements

Our MS Access 2016 Introduction is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Career Path

After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

Introduction

Introduction

FREE

00:01:00

Getting Started

What is a Database?

00:03:00

Understanding Database terminology

00:05:00

Navigating the Access Interface

00:06:00

What is a flat file database

00:04:00

What is a relational database

00:09:00

Relating Tables

00:06:00

Reviewing the Access Ribbon

00:04:00

Working with Data

Working with Tables

00:04:00

Navigating Tables

00:02:00

Editing Data

00:03:00

Adding New Records

00:02:00

Using Subdatasheets

00:04:00

Creating Databases and Objects

Understanding Database and Table Design Principles

00:10:00

Using Table Data Sheet View

00:04:00

Working with Field Data Types

00:04:00

Using Table Design View

00:04:00

Using Calculated Fields

00:04:00

Calculating Numbers

00:03:00

Calculating Dates

00:01:00

Calculating Strings

00:02:00

Using the Lookup Wizard

00:05:00

Editing Lookups

00:04:00

Using Indexes

00:02:00

Working with Queries

What are Queries

00:03:00

Creating Simple Queries

00:05:00

Understanding the Dynaset

00:02:00

Entering Criteria: Exact Match and Range Operators

00:04:00

Understanding AND versus OR

00:03:00

Using Wild Cards

00:02:00

Using Keywords

00:03:00

Sorting and Hiding Fields

00:02:00

Creating Multi-Table Queries

00:03:00

Additional Tips

00:03:00

Working with Reports

What are Reports

00:03:00

Understanding Report Types

00:03:00

Building Effective Reports

00:02:00

Using AutoReport

00:04:00

Understanding the Report Wizard

00:04:00

Using the Report Design View

00:08:00

Creating Labels

00:02:00

Working with Forms

What are Forms

00:04:00

Understanding Form Types

00:02:00

Creating Forms

00:02:00

Navigating Forms

00:02:00

Editing Data in Forms

00:03:00

Understanding the Form Wizard

00:03:00

Using the Form Design View

00:04:00

Working with Controls

00:03:00

Using Form Layout View

00:02:00

Additional Tips

00:03:00

Conclusion

Course Recap

00:01:00

Resources

Resources - MS Access 2016 Introduction

00:00:00

Certificate and Transcript

Order Your Certificates and Transcripts

00:00:00

About The Provider

Tags

Reviews