Database Tutorial (Part 1) – About Databases, Creating Databases, Tables

This article is part 1 of the database tutorial.

Here, we cover the following:

  • What is a database?
  • What is a Database Management System (DBMS)?
  • Types of databases
  • What does a relational database look like?
  • Creating a database
  • Creating tables
  • Data types

Continue reading “Database Tutorial (Part 1) – About Databases, Creating Databases, Tables”

Database Tutorial

This database tutorial is for beginners. It explains basic concepts and assumes no prior knowledge of databases.

You don’t need to follow along – there aren’t any exercises. But there are plenty of screenshots and a few diagrams. The purpose of the tutorial is to introduce you to the basic concepts of databases.

Continue reading “Database Tutorial”

Microsoft Access Tutorial (Part 3): Queries, Forms, & Macros

This article is Part 3 of the Microsoft Access tutorial.

Here’s what’s included in this article:

  • Create a query (so you can “search the database”).
  • Create a form for data entry.
  • Create a macro (so that a multi-step task can be done automatically – at the click of a button).

Continue reading “Microsoft Access Tutorial (Part 3): Queries, Forms, & Macros”

Microsoft Access Tutorial (Part 2): Design View, Field Properties, & Relationships

This article is Part 2 of the Microsoft Access tutorial.

Here’s what’s included in this article:

  • Design View.
  • Add field properties to a field.
  • Add two more tables (for the relationship)
  • Set up a relationship between three tables.

Continue reading “Microsoft Access Tutorial (Part 2): Design View, Field Properties, & Relationships”

Microsoft Access Tutorial (Part 1): Databases, Tables, & Fields

This article is Part 1 of the Microsoft Access tutorial.

Here’s what’s included in this article:

  • Create a database.
  • Add a table to the database.
  • Add four fields to the table, name/rename them, and set up their data type.

Continue reading “Microsoft Access Tutorial (Part 1): Databases, Tables, & Fields”