Microsoft Access 2016 For Beginners
Microsoft Access 2016 For Beginners
Duration: 1h 22m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 515 MB
Genre: eLearning | Language: English
Duration: 1h 22m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 515 MB
Genre: eLearning | Language: English
A Complete Guide to Microsoft Access Essentials
What you'll learn
Understand the Basics of Access databases , tables, queries, forms and reports.
How to create tables and how to create tables imported from Excel.
How to create queries, forms and reports
Students will be able to create and design their own databases
Requirements
Basic knowledge of computer
MS Access installed on a PC or a Laptop.
Description
This course includes an introduction to the Microsoft Access 2016 interface. It covers the various aspects of database creation and management in Access 2016
This Introductory course contains five basic modules on
how to create and manage databases T
how to create tables
how to create different queries
how to create and design forms
and how to create reports
The various modules presented in this document will help you to build a solid knowledge foundation of the software.
The booklet in the form of pdf is the companion document to the Intro to Access 2016 workshop.
Each module begins with a video and textual overview of the material, followed by a Assignment, which takes you step-by-step through a hands-on database example of the chapter contents. Each module has around ten assignments to practice and be expert to proceed to next module. All assignment resources are available with each module. Each module has quiz related to its topic.At the conclusion of most chapters, you have the opportunity to complete an Applied assignment and quiz to check your knowledge and application of the material learned.
After completing all the modules and following instructions in the companion , you will be able to
Identify the components of the Access 2016 interface
Create a new database
Understand how to create a table
Understand the purpose of the primary key
Enter descriptions for fields
Understand how to add validation rule in the fields
Understand how to enter various types of data into the table
Understand how to create a Query
Understand how to create a Form
Understand how to create a Report
Who this course is for:
This course is suitable for MS Access beginners as well as anyone who would like to learn a new skill.
Anyone who would like to learn how to work with databases
More Info