Microsoft Access Databases: Introduction to Tables

	Introduction to Tables

Introduction

A table is a database object that holds a list of values. This means that, before creating a table, you must have a database. You can create or open one.

Creating a Table

There are various ways to create a table:

You can create a table in the Datasheet View. If you create a new blank database, Microsoft Access automatically starts a new table in Datasheet View. Otherwise, after starting or opening a database, on the Ribbon, click Create. In the Tables section, click Table
To visually design a table is in the Design View, on the Ribbon, click Create. In the Tables section, click Table Design
Another way to create a table is with SQL code. To start, on the Ribbon, click Create. In the Queries section, click Query Design. In the Show Tables dialog box, close Close. Right-click the window and click SQL View:

Table Creation With SQL

Deleting a Table

To delete a table, right-click its name in the Navigation Pane and click Delete. To delete a table in SQL, type DROP TABLE followed by the name of the table. Here is an example:

DROP TABLE Employees;

Once you execute the SQL statement, the table will be deleted. Unfortunately, no message will let you know that the table was deleted.