Thread: Working with your table

Finally, you will have your complete table presented to you. The field that is assigned as a primary key has "Autonumber" written in its columns. The cells in the primary key need not be filled since their values are entered automatically by Access. You can move to the next column in the same row by pressing the [Tab] key. Enter the appropriate value and press [Tab] again. MS Access makes sure that the data values entered in certain columns pertain to some basic data type [Figure 31. It doesn't accommodate illegitimate values into fields that have a certain permissible data value. To view the data types, click on "View I Design View",

In the Design View, you get a glimpse of what actually happens during database creation IFigure 41. Here, you will find three columns: "Field Name", "Data Type", and "Description". The Data Type drop¬down list includes all the available data type values. These are some of the most commonly used data types in Access:



AUTONUMBER: It is assigned as a primary key. The values are automatically increased after every line, TEXT: Mostly text values are entered into this field. Fields like names and addresses use this data type. DATE/TIME: This field requires you to enter values for date and time in the specified format. If you do no want to follow any specific formats, then you can change the data type to Text. CURRENCY: This data type is used to indicate money or any other currency¬related data. It prefixes it with a "$" sign and post fixes it with two decimal values.

YES/NO: when you select the Yes/No data type, a check box appears in the column that contains it. It is not necessary to provide descriptions. The column can be left blank. Once you have made the changes lif anyl to the table structure, then click on [Ctrl] + Wand save the table. After all the values are entered into the database, you need to present it in the form of a report.