Create new tableClick the Table button from the Database window and select the New Table option. A window like this will thus appear:
 Table Name The name of your new table. It can contain up to 64 characters. New table creation In order to create more tables in the database instead of only one, enter the new name into the Table Name combo box. You will notice how the Table fields column list disappears if you had had previous table names therein. Define new columns for the new table and click the Build the table button to make the program create the table. Changing existing table structure There are names of existing (defined) database tables within the Table Name combo box. If you want to change the data for any one of them, click the combo box arrow and select table name from the list. Names and table column types will appear in the Table Fields. Once you have clicked any column in the Field Name text box, its name will appear which you can change. A column Type will appear in the Data Type combo box, which you can change according to need by selecting another from the list. Click the modify button to change the data for the selected column. Build the Table Once you have defined your column tables, click this button to create a table. You will have the possibility of choosing a Primary Key: 
If you select the Add primary key, the program will create a column which will be allowed to have only unique values. You may also select a pre-defined column as a primary key, by clicking the combo box and selecting its name from the list. If you want a new column, enter its name in the combo box and the program will create a Long Integer column which will have an Autonumber property i.e. every record will have its unique number. The primary key is very useful when you want to prevent the repetition of data within a column. For instance, if you create a column with the name of 'E-mail Address', a one that will help you enter e-mail addresses, that column would not contain two identical addresses. The program will ignore the inscription if it is entered for the second time. No primary key When you want your table not to have a Primary key, then select this option. Add primary key If you select this option the program will create a primary key for the table whose name stands in the adjacent combo box. If such a named column does not exist, it will be created as unique, an autonumber column of the Long Integer type. The program will automatically suggest a new column with the ID name. You can select any other name or select some of the existing columns. Field name Contains column names Add Adds a new column to the list. Modify When you select a column from the Table Fields list, the program will input changes for it when clicking the Modify button, provided that you have changed the data in the meantime. Delete Deletes the column from the list. Table Fields Contains a list of all defined columns. Data type Determines data type within a column. The default type is text, which enables typing texts up to 255 characters. If you want to create text columns which can support up to a maximum of 1.2 gigabytes of text, use Memo (extended text) data type. Data types: ------------------------------------------------------------------------------ ByteByte (8-bit) data. An integer value between 0 and 255. ------------------------------------------------------------------------------ CurrencyCurrency data. A scaled integer between 922,337,203,685,477.5808 and 922,337,203,685,477.5807. ------------------------------------------------------------------------------ Date/TimeDate value data. Formats are displayed according to the settings specified in the Regional Settings Properties dialog box in Windows Control Panel. ------------------------------------------------------------------------------ DoubleDouble-precision floating-point data. A double-precision floating-point value with a range of 1.79769313486232E308 to 4.94065645841247E-324 for negative values, 4.94065645841247E-324 to 1.79769313486232E308 for positive values, and 0. ------------------------------------------------------------------------------ IntegerInteger data. A short integer between 32,768 and 32,767. ------------------------------------------------------------------------------ Long IntegerLong Integer data A long integer between 2,147,483,648 and 2,147,483,647. ------------------------------------------------------------------------------ MemoMemo data (extended text) Zero to a maximum of 1.2 gigabytes. ------------------------------------------------------------------------------ SingleSingle-precision floating-point data A single-precision floating-point value with a range of 3.402823E38 to 1.401298E-45 for negative values, 1.401298E-45 to 3.402823E38 for positive values, and 0. ------------------------------------------------------------------------------ TextText data (variable width). Zero to 255 characters. ------------------------------------------------------------------------------ Yes/NoBoolean (True/False) data. Yes and No values and fields that contain only one of two values. ------------------------------------------------------------------------------ Delete Table, Rename Table, Properties Filter records Searching tables for records Printing Edit Table Columns See Also: Database Wizards E-mail Merge Extracting data from the web forms | 
