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

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

2025’s Online Education Shakeup Claims Another: Skillshare’s CEO Departs

SEO Content Strategy Demystified: Coursera, MasterClass, and edX

Harvard CS50 Guide: How to Pick the Right Course (with Free Certificate)

Udemy Earns More, Pays Instructors Less: Class Central Exclusive

CreativeLive is Live Again: CourseHorse Acquires Platform 15 Days Before Shutdown

Udemy vs Coursera: Comparing Online Learning Giants that IPO’d in 2021

2000+ Free Developer and IT Certifications

10,000+ Free Courses from Tech Giants: Learn from Google, Microsoft, Amazon, and More

600+ Courses from Top Med Schools with Free Certificate & CME Credit

White-Labeling in Online Education: Whose Credential Is It Anyway?

200K Layoffs, $100B Lost: The Tsunami of China’s Regulation on Education

Coursera and Udemy are Finally One. What’s Next?

Inside the Coursera-Udemy Deal: Three Bids, Two Years and a Rival Suitor

University of Sheffield Ends 11-Year Partnership with FutureLearn