Category: Relational (page 2 of 6)

SQL DROP DATABASE Syntax – Listed by DBMS

This article lists the SQL DROP DATABASE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading

SQL ALTER DATABASE Syntax – Listed by DBMS

This article contains the SQL ALTER DATABASE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading

SQL CREATE TABLE Syntax – Listed by DBMS

This article contains the SQL CREATE TABLE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading

SQL CREATE DATABASE Syntax – Listed by DBMS

This article contains the SQL CREATE DATABASE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading

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 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 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

This Microsoft Access tutorial will show you how to use Microsoft Access to create a simple database with all the common features such as tables, forms, queries, and macros.

This tutorial is for beginners. No prior database knowledge is assumed.

Continue reading

What is the Input Mask Wizard in Microsoft Access?

The Input Mask Wizard is a feature of Microsoft Access that helps you create an input mask.

An input mask allows you to specify exactly how data should be entered into the database. It’s an expression that specifies certain rules about how the data should be formatted as it is entered into the system.

Here’s an example of an input mask:

(999) 000-0000

This specifies the format that a phone number must be entered. The number 9 indicates an optional character. The number 0 specifies a mandatory one. So in this example, the area code is optional.

Continue reading

What is the Expression Builder in Microsoft Access?

The Expression Builder is a component of Microsoft Access that helps you build expressions. It allows you to look up and build expressions without having to remember how to type the full expression.

Screenshot of the Expression Builder in MS Access 2013.

The Expression Builder in Access 2013.

Continue reading

Older posts Newer posts

© 2017 Database.Guide

Theme by Anders NorenUp ↑