CCNC/CCNC Module 5/Designing and creating tables/Basic Table Operations

Creating a Table
The first step to a database is to create the tables that are needed. You can design a table from scratch or you can activate the Table Wizard which allows you to choose formats that have been pre-defined and are available to use.

To do this click on the Tables icon on the left hand side of the screen (Figure 1). Then choose "Create Table in Design View..." from the task panel. 

Designing the Table
If you choose to Create Table in Design View, the following screen will appear (Figure 2).

Here you enter the field names underneath each other. The green arrow shows the active row. You can specify a Field Type in the next column which can be either a Text field or a Date, Time, Number, various types of Integers etc. If you do not specify a Field type it will default to Text. 

Test your knowledge
