Tutorialspoint

Microsoft Access Training - Practice to Perfect Skills

The Complete Microsoft Access Course for Beginners

Course Description

Hello everyone, Welcome to the course! I am thrilled to have you on board. You're going to be a valuable asset, and I can't wait to see all that you accomplish. 

Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. This course is designed for those people who want to learn how to start working with Microsoft Access and to get you to feel comfortable and confident using Access. It's designed to get you started with the skills you need to organize your data in tables, mine your data using queries, and create clean, professional reports to impress your boss.  

With Access, you can build a database without writing code or being a database expert.

Well-designed templates help you quickly build databases. Easily find just the data you want with queries. Instantly create forms for simple data entry. Summarize data in grouped and summary reports. Dozens of Wizards make it easy to get started and get productive.

You might be wondering if this course will be a good fit for you. Well, I designed this course for the beginner who needs to add this course to their list of important job skills. This course is also a good fit for you if you have a little bit of experience with access already, and you're ready to fine-tune and expand your skills in an easy, stress-free way.

It is a simple and easy-to-understand course. There are no set prerequisites as such, and it should be useful for any beginner who wants to acquire knowledge on MS Access.

While it's ultimately up to you, my goal is to give you the skills to impress your boss and hopefully get that raise, promotion, or a new job that you deserve.

All I ask for is to send me your reviews and ratings and let me know how did my course help you outstand and outshine. That always makes my day.

Alright ! so Let's dive in !! Happy Learning 

Goals

  • What is a relational database and how does it c
  • Compare to the way data is stored in Excel.
  • Designing tables to store data. Setting data types and field properties.
  • Importing data into your Access database stored in Excel or as text files.
  • Understanding primary and foreign keys and creating relationships between tables.
  • Design Forms, that look great and function well.
  • Understand how to set AND/OR criteria, use comparison operators and wildcards.
  • Create a Front-End for your Database .Create a navigation form with command buttons that open your forms and reports.

Prerequisites

  • No Requirements, You need a computer with good internet access.
Show More

Curriculum

  • Introduction
    02:26
    Preview
  • Flat vs Relational Database
    04:24
    Preview
  • New Access Database
    01:53
  • Access Objects
    06:32
  • Naming Conventions
    01:16
  • Product Table
    04:40
  • Supplier Table
    02:11
  • Caption Property
    01:47
    Preview
  • Field Property
    03:58
  • Format Property
    02:04
  • Lookup Wizard
    01:38
  • Field Description
    01:25
  • Add Data
    03:38
  • Enter a Record
    02:03
  • Import Records
    03:07
  • Import in Supplier Table
    01:24
  • Sort Data
    02:37
    Preview
  • Filter Data
    06:01
  • Formatting
    01:23
  • Freeze Columns
    02:04
  • Relationship between Tables
    07:29
  • Relationship between Tables using Lookup Wizard
    06:05
  • Product Form 1
    02:50
  • Product Form 2
    04:56
  • Design Form
    01:32
  • Input Fields Form
    02:30
  • Form Header and Form Footer
    03:30
  • Form Buttons
    06:46
  • Form Properties
    03:00
  • Supplier Form
    03:18
  • Supplier Form Part 2
    04:53
  • Supplier Form Header
    06:17
  • Form Wizard
    08:23
  • Select Query
    06:14
  • Select Query By Two Related Tables
    05:30
  • And/Or Criteria
    04:57
  • Comparison Operators
    02:15
  • AND Criteria
    01:44
  • Query Wildcard Criteria
    04:11
  • Report For Product Table
    07:23
  • Product Report
    06:20
  • Suppliers Report
    07:51
  • Navigation Form
    09:45
  • Navigation Form Buttons
    04:00
  • Form Improvements
    03:00
Feedbacks
  • No Feedbacks Posted Yet..!
Microsoft Access Training - Practice to Perfect Skills
This Course Includes
  • 3 hours
  • 45 Lectures
  • 7 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

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

Talk to us

1800-202-0515