Learning Outcomes

Core Database Concepts - Introduction

SQL Server Management Studio

Lesson Summary

Learn more about the fundamental concepts of database. You will be introduced to databases, SQL, DBMS and RDMS. You will also learn about SSQL Server Management Studio and how GUI can be used to manage an SQL Server, its databases, and the content contained within the databases.

Normalization

Referential Integrity

Constraints

In this module, you will study the relational concepts of database. You will begin by studying Normalization and you will see how the various normal forms impact upon the organization of data in a database. You will also study referential integrity and constraints.

Datatypes

Database Objects

DDL Statements

Learn about what a datatype is and then learn about some of the categories of datatypes. You will also learn about unicode, implicit and explicit datatypes before moving onto database objects and DDL statements.

Introduction to Database Concepts  - Final Assessment

Learn the core concepts of relational databases for storing data with this free online Database Concepts course.

Introduction to Database Concepts

This free online Introduction to Database Concepts course will teach you the process of storing, managing, and retrieving information in a database. A database is an organized collection of data in rows and columns, typically stored in tables. These tables are then stored on database servers that host the database files. With this course, you will learn how databases can provide high-level performance for a diverse set of users.

Launching, Exploring and Navigating Access

Creating and Testing a New Database

Getting Help in Microsoft Access

Getting Started with Access - Quiz

In this module, Getting Started with Access, students will learn about the basics when starting with Microsoft Access. Students will learn about launching, exploring, and navigating Access. The module will also talk about creating and testing a new database. The module will then talk about getting help in Microsoft Access.

Modifying and Navigating Records

Working with Records

Creating and Configuring Lookups

Working With Table Data - Quiz

In this module, Working with the data table, students will learn about using the data table in Microsoft Access.Students will start by learning about modifying and navigating records. The module will then go over working with records. Students with end the module by creating and configuring lookups.

How to Create and Use a Query

Filtering Out Data in a Query

Working with Calculations in a Query

Querying a Database - Quiz

In this module, Querying a Database, students will learn about using a query in Microsoft Access. Students will start by learning about how to create and use a query. The module will then cover filtering out data in a Query. The module will wraps up with working with calculations in a query

Creating a Query with Single and Multiple Parameters

Creating Action Queries

Working with Unmatched and Duplicate Queries

Creating a Crosstab Query

Creating Advanced Queries - Quiz

In this module, Creating Advanced Queries, students will learn about advanced queries in Microsoft Access. Students will learn about. Creating a query with single and multiple parameters. The module will then talk about working with unmatched and duplicate queries. Students will wrap up the course with creating a crosstab query.

Creating a Report

Adding and Adjusting Report Control

Enhancing the Appearance of a Report

Preparing Reports for Print

Generating Reports - Quiz

In this module, Generating Reports, students will learn about creating reports in Microsoft Access 2013. Students will learn about adding and adjusting report control. The module will then cover enhancing the appearance of a report. Students will then wrap up the course with preparing reports for print.

Exploring the Access Environment

Customizing the Access Environment - Quiz

In this module, Customizing the Access Environment, students will learn about the Access Environment interface in Microsoft Access 2013. Students will learn about exploring the Access Environment and customizing the environment. This this the last thing students will learn before the course assessment.

Diploma in Microsoft Access 2013 Basic Online Training - Assessment

Learn about making databases in Microsoft Access 2013 with this free online course.

Diploma in Microsoft Access 2013 Basic Online Training

This free online course, Microsoft Access 2013 Basic Online Training. Students will learn about working with table data. The course will also cover querying a database. It then shows how to create an advanced queries. Students will then learn about generating reports. The course wraps up with customizing the access environment. So, why wait? Start this course today and learn about Microsoft Access 2013.

12 Best Data Structures & Algorithms Courses for 2025

FutureLearn’s 2021: Year in Review

10 Best Go (Golang) Courses for 2025

[2025] 450+ Free Google Certificates and Badges

6 Best Site Reliability Engineering Courses to Take in 2025

Stanford Medicine Offers Courses with Free Certificate & CME Credit

EdX’s 2021: Year in Review

[2025] 150+ Online Courses to Help Your Career

Why Duolingo is Worth More Than Coursera and Udemy Combined

2U Powered Degrees Pricing Chart: 112 Programs from $20K – $200K

7 Best Autodesk Maya Courses for 2025: Exploring 3D Animation

The Day MOOCs Truly Died: Coursera’s Preview Mode Kills Free Learning

10 Best Organic Chemistry Courses for 2025

15 Best Lisp Courses for 2025

12 Best Data Science Courses for 2025

900+ Open University Free Certificates