Creating a table in a database Microsoft Access 2003 consists in:

• selecting the type of object Tables in the Database Window [...];
• command launch New in the toolbar of the Database Window;
• selecting how to create the table from the list of the options in the dialog box New Table.

New Table Dialog Box

Ways to create a table in Access 2003:

• Datasheet View: creates a table that contains a set of the fields; table opening is made directly in Datasheet View for immediate introduction of data; initially, the table contains 10 fields with names Field1, Field2, …, Field10; associated data type field is set depending on the nature of data entered;

Table Building in Datasheet View

• Design View: creates a table for which the user must explicitly define the types of associated data fields and their properties;

Table Building in Design View

• Table Wizard: creates a table using a wizard application included in Microsoft Access 2003; application wizard assists the user in adding new fields in the created table and appropriate combination of properties for these fields;

Table Building with Table Wizard

• Import Table: creates a table by importing data from an external database (Access, Lotus 1-2-3, Paradox, dBase), or external data source (Excel books, Outlook or Microsoft Exchange directories, XML, HTML, text files, ODBC data sources); bases or external data sources are specified in the Import dialog box displaying when the option Import Table is selected;

Table Building with Import Table

• Link Table: creates a table linked to another database or external data source; binding is specified in the Link dialog box displayed when the Link Table option is selected.

Table Building with Link Table