• LOGIN
  • No products in the cart.

Login

Course Curriculum

Course Curriculum

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 Sub data sheets 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:30: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

MS Access 2016 Introduction

4.7( 9 REVIEWS )
343 STUDENTS
$ 249.00
MS Access 2016 Introduction

Description

MS Access 2016 Introduction Course is intended to provide the learner with the basics and fundamental knowledge of MS Access 2016 and database management. In this course, you’ll become familiar with various database components, concepts, and terminologies.

  • Learning outcome
  • Acquire the skills to facilitate the management of information in any company.
  • Get a comprehensive overview of database management.
  • Understand Databases and Database Terminology
  • Design databases, establish relationships and make inquiries about them.
  • Work with Queries, Reports, and Forms.

Requirements

  • Learners will need regular access to a computer with an internet connection.
  • High speed broadband access (LAN, Cable or DSL) is highly recommended for the optimal learning experience.
  • This course is available to all learners, of all academic backgrounds.
  • Why should I take this course?
  • 3.5+ hours of quality e-Learning content.
  • Certificate upon completion of the course.
  • Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes.
  • The demand for database managers is increasing rapidly since all the businesses are adopting technology in their regular operations.
  • Achieve a good grasp of database management and kickstart your career in the field of database management.

Testimonial

Hear what our happy students want to say

Setup Menus in Admin Panel