Tutorialspoint

Mid-Year Savings Flat 10% OFF, Use Code: MID10

Microsoft Access Training - Practice to Perfect Skills

person icon Rada Asghar

4.1

Microsoft Access Training - Practice to Perfect Skills

The Complete Microsoft Access Course for Beginners

updated on icon Updated on Jul, 2024

language icon Language - English

person icon Rada Asghar

English [CC]

category icon Microsoft Access,Office Productivity

Lectures -45

Resources -7

Duration -3 hours

4.1

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

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.
Microsoft Access Training - Practice to Perfect Skills

Curriculum

Check out the detailed breakdown of what’s inside the course

Presentation Of Contents
45 Lectures
  • play icon Introduction 02:26 02:26
  • play icon Flat vs Relational Database 04:24 04:24
  • play icon New Access Database 01:53 01:53
  • play icon Access Objects 06:32 06:32
  • play icon Naming Conventions 01:16 01:16
  • play icon Product Table 04:40 04:40
  • play icon Supplier Table 02:11 02:11
  • play icon Caption Property 01:47 01:47
  • play icon Field Property 03:58 03:58
  • play icon Format Property 02:04 02:04
  • play icon Lookup Wizard 01:38 01:38
  • play icon Field Description 01:25 01:25
  • play icon Add Data 03:38 03:38
  • play icon Enter a Record 02:03 02:03
  • play icon Import Records 03:07 03:07
  • play icon Import in Supplier Table 01:24 01:24
  • play icon Sort Data 02:37 02:37
  • play icon Filter Data 06:01 06:01
  • play icon Formatting 01:23 01:23
  • play icon Freeze Columns 02:04 02:04
  • play icon Relationship between Tables 07:29 07:29
  • play icon Relationship between Tables using Lookup Wizard 06:05 06:05
  • play icon Product Form 1 02:50 02:50
  • play icon Product Form 2 04:56 04:56
  • play icon Design Form 01:32 01:32
  • play icon Input Fields Form 02:30 02:30
  • play icon Form Header and Form Footer 03:30 03:30
  • play icon Form Buttons 06:46 06:46
  • play icon Form Properties 03:00 03:00
  • play icon Supplier Form 03:18 03:18
  • play icon Supplier Form Part 2 04:53 04:53
  • play icon Supplier Form Header 06:17 06:17
  • play icon Form Wizard 08:23 08:23
  • play icon Select Query 06:14 06:14
  • play icon Select Query By Two Related Tables 05:30 05:30
  • play icon And/Or Criteria 04:57 04:57
  • play icon Comparison Operators 02:15 02:15
  • play icon AND Criteria 01:44 01:44
  • play icon Query Wildcard Criteria 04:11 04:11
  • play icon Report For Product Table 07:23 07:23
  • play icon Product Report 06:20 06:20
  • play icon Suppliers Report 07:51 07:51
  • play icon Navigation Form 09:45 09:45
  • play icon Navigation Form Buttons 04:00 04:00
  • play icon Form Improvements 03:00 03:00

Instructor Details

Rada Asghar

Rada Asghar

I've been working online since since 2009. I left my job and went full-time online in 2012. Teaching here on Tutorialspoint is probably the most satisfying thing I do. Being able to help others to learn life changing techniques and business models.

Over the last 15 years or so I've created and marketed many digital e-learning products and have also worked extensively in the field of affiliate marketing.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515