MS Access field record table and data types

What is field?

Each column is used to define specific information is to be entered into that particular column title “Street” for example would signify this to be the point in a record to enter in the street name when creating each new record.

What is a record?

A record applies to data entered into a single row of a table. All data in that row would belong to an individual or item.

 A row would normally include a unique ID number, Name, Description, plus other relevant information. With each new record, a new row is created.

What is a table?

Tables are used to store the data in a structured and organized format. As previously mentioned. Tables are similar to those of word and excel, in that they contain rows (records) and columns (field).

Data types:

Data types define what type of data will be entered into each ‘Field’ (column) in a table. If for example the data ‘21June2007’ or Price 1.59 is entered into a field, which by default is set as “Text” the input characters will remain unchanged.