Create Database Applications Using MS Access 2013

Create real world database applications. Easy to Follow Lectures. Boost Your Resume and Earning Potentials!.
4.6 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
159 students enrolled
Instructed by Kelvin Mbatu Development / Databases
77% off
Take This Course
  • Lectures 29
  • Length 2.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course Description

This MS Access 2013 course was designed to be easily understood by absolute beginners and at the same time offer value to somewhat proficient users of Microsoft Access.

The course focuses on equipping you with the hands-on skills required to develop database applications with MS Access in as little time as possible.

By the end of the course, you'll have the confidence required to get you started with developing your own database applications.

What's in it for you?

In this course, you will learn how to:

  • Develop database applications by solving a real world problem.
  • Create MS Access objects: tables, forms, queries, macros and reports
  • Develop SQL Queries to retrieve and manipulate data from your tables
  • Easily import data from Microsoft Excel to MS Access
  • Quickly format forms, and restrict data that is entered into your tables.
  • Create a switchboard for easy navigation around your database

Course Structure

This course was structured to first teach you the fundamentals of database design and then guide you on a step-by-step basis on how to design and create your own database applications

You do not need any prior technical or programming experience to fully participate in this course, you just need the patience and willingness to learn.

You'll have access to the detailed step-by-step Lab Exercises that will guide you through developing the various application components.

There are quizzes at the end of each new concept learnt to validate the knowledge and skills you would have gained.

What are the requirements?

  • A computer with Microsoft Access Installed

What am I going to get from this course?

  • Confidently develop database applications using Microsoft Access
  • Understand MS Access and how it can be applied to solve real world problems
  • Understand and Implement best practice database design concepts
  • Create tables, forms, queries, reports, macros and relationships

Who is the target audience?

  • Professionals needing to develop Microsoft access applications
  • Students taking or preparing to take a MS Access class
  • Anyone seeking to obtain this invaluable skill

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Introduction and Objectives

Introduction to creating databases with MS Access 2013. What to expect in the coming lectures


Understand databases, and why they are important


Understand MS Access, its uses and applications. Understand other DBMSs


A discussion on the final course project and course structure


Brief introduction to the MS Access product and interface.

Understand MS Access
2 questions
Section 2: Components of an Access Database Application

Description of a table, how it is organised and its uses


Description of relationships, and their uses


Description of a forms and their uses


Description of queries, and their uses


Description of reports, and their uses


Description of other objects not covered in this class such as VBA.

Components of MS Access database application
5 questions
Section 3: Designing the database

Understand the importance of database design.


Best practice database design principles


A walkthrough of the process of designing a database

Database design concepts
5 questions
Section 4: Building the database

How to build the table, and decide on data types


How to insert data into your database tables using the data sheet view.


How to import MS Excel data into your MS Access tables

Building MS Access tables
4 questions

How to create table relationships and enforce referential integrity

Building MS Access table relationships
3 questions

How to create the MS Access forms.


How to modify form's design


How to create the rental reservation form which references multiple tables in our database

Building MS Access Forms
3 questions

How to create MS Access queries and execute them


Introduction to SQL using MS Access. Understand Joins


Create queries in MS Access using the query builder


How to reference queries in combo boxes


Learn some more complex form design concepts

Building MS Access Queries
5 questions

Build the reports for our application

Building MS Access Reports
3 questions
Section 5: Piecing it together

Create a dashboard for easy navigation around our database application


Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kelvin Mbatu, Information Technology Enthusiast

The Instructor - Kelvin Mbatu - has a background in Computer Science and a masters degree in Information Systems from Carnegie Mellon University.

He's an IT enthusiast and has over 9 years professional IT consulting experience; Advising fortune 500 companies on matters related to cyber security, IT governance, and systems implementation.

He loves teaching and believes that nothing is difficult to learn. It's how it is taught that makes the difference.

He has a couple professional IT/Management certifications including: PMP (Project Management Professional), SCJP (Sun Certified Java Programmer), CISSP (Certified Information Systems Security Professional), CISA (Certified Information Systems Auditor), etc

Ready to start learning?
Take This Course