This article is part 1 of the database tutorial.
Here, we cover the following:
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.
This article is Part 1 of the Microsoft Access tutorial.
Here’s what’s included in this article:
To create a database from a script in MySQL:
CREATE DATABASE or CREATE SCHEMA statement to create the database (example below)This will create a new database.
To create a database in the MySQL Workbench GUI:
The database will now be created, and a message will display advising that the script was successful.
To create a database in SQL Server using the GUI:
Once you’ve created the database, you can create tables and other database objects. You can also modify any database properties as required.
In Microsoft Access 2013 & 2016, you can create a database straight from the Welcome screen or from the work area. You can create either a blank database, or a database from a template.
When you first open Access, the Welcome screen is displayed. You can create your database straight from here.
Your new database will have one table called “Table1”. You can modify this table to your needs. You can also create new tables and other database objects.