How to: Create a Table Object in a Database Microsoft Access 2003

June 24, 2009 by Marius
1 Comment

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
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
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 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
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
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
Table Building with Link Table
Tags: , , , ,