Create Database Applications Using MS Access 2013
4.6 (14 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.
182 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Create Database Applications Using MS Access 2013 to your Wishlist.

Add to Wishlist

Create Database Applications Using MS Access 2013

Create real world database applications. Easy to Follow Lectures. Boost Your Resume and Earning Potentials!.
4.6 (14 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.
182 students enrolled
Created by Kelvin Mbatu
Last updated 2/2016
English
Current price: $10 Original price: $65 Discount: 85% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • A computer with Microsoft Access Installed
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.




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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
29 Lectures
02:41:52
+
Introduction and Objectives
5 Lectures 12:24

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

Preview 02:50

Understand databases, and why they are important

What is a database
01:56

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

What is MS Access
01:48

A discussion on the final course project and course structure

Course database project
03:44

Brief introduction to the MS Access product and interface.

Getting Started with MS Access
02:06

Understand MS Access
2 questions
+
Components of an Access Database Application
6 Lectures 12:08

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

Tables
01:55

Description of relationships, and their uses

Relationships
02:37

Description of a forms and their uses

Forms
02:13

Description of queries, and their uses

Queries
02:59

Description of reports, and their uses

Reports
01:24

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

Other MS Access objects
01:00

Components of MS Access database application
5 questions
+
Designing the database
3 Lectures 15:55

Understand the importance of database design.

Design is key
00:57

Best practice database design principles

Database design principles
07:43

A walkthrough of the process of designing a database

The design process
07:15

Database design concepts
5 questions
+
Building the database
13 Lectures 01:48:50

How to build the table, and decide on data types

Building the tables
10:16

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

Inserting data into the tables - using datasheet view
06:21

How to import MS Excel data into your MS Access tables

Inserting data into the tables - importing data from excel
06:10

Building MS Access tables
4 questions

How to create table relationships and enforce referential integrity

Building the table relationships
03:58

Building MS Access table relationships
3 questions

How to create the MS Access forms.

Building the forms for data Input
06:59

How to modify form's design

Modify the Forms Design
12:22

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

Create the Rental Reservation Form
15:50

Building MS Access Forms
3 questions

How to create MS Access queries and execute them

Building Queries
04:43

Introduction to SQL using MS Access. Understand Joins

Building Queries - Intro to SQL
10:19

Create queries in MS Access using the query builder

Preview 08:54

How to reference queries in combo boxes

Referencing Queries in Combo boxes
03:07

Learn some more complex form design concepts

The Update Rental Form
07:03

Building MS Access Queries
5 questions

Build the reports for our application

Building the reports
12:48

Building MS Access Reports
3 questions
+
Piecing it together
2 Lectures 12:35

Create a dashboard for easy navigation around our database application

Linking forms
11:41

Conclusion
00:54
About the Instructor
Kelvin Mbatu
4.6 Average rating
14 Reviews
182 Students
1 Course
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