Tables
A database contains one or more relational tables. A Table is a collection of related information, usually organized in horizontal rows and vertical columns.
You can compare the tables with Excel sheets. You can create an Excel spreadsheet, for example, to track students and enter the name of each on a separate line. Each category of information for each student is entered in the various columns: name, class, call number and so on. Each set of information about each student appears on a separate line.
Concepts
Records and Fields
Tables are made up of records and the records are made up of fields.
The fields and their data types
A data type defines what type of information that can be stored in the field in question.
For example:
Text - can be written in letters and numbers.
Numeric - Only numbers can be written, is not accepted letters.
Date - You only accept numbers in the date format can not be written or decimal numbers and text.
Defining the Fields in a Table
You have the following items defining the top of the window.
When choosing data types for each field is a menu where you must define the data type of the field support.
Field Name-Sets the name to be given to the field, for example Class.
Data Type-Defines the type of information that may be stored in this field.
Description-Allows you to create a description of the nature of the field in question. Access uses the description to the text property of the status bar in new forms, so that the description appears in the status bar when you view data in the form.
Data Type
-Text and text numbers, such as names and character.
Memo-extensive text and numbers, as comments or explanations; up to 32,000 characters.
Number-numeric data in which you intend to perform mathematical calculations, except calculations involving money. Set the Field Size property to set the data type "Number" specific.
Date / Time, dates and times. A variety of display formats available or can also create a.
Currency-Currency values. Do not use the data type "Number" for monetary values, because the numbers to the right of the decimal will be rounded in the calculations. The data type "Money" has a fixed precision.
Auto-Numbering-A unique sequence number (incremented by 1). This field will start the number one and placed it will increase each record one by one. AutoNumber fields can not be updated. For more information, see the property
Counter-sequential numbers automatically entered by Access. The numbering starts at 1. It's a great field for primary key.
Yes / No -Sim/Não, True / False, On / Off or fields that contain only one of two values.
Object OLE-objects created in other programs using the OLE protocol that may be linked or embedded in an Access database through a control on a form or report.
Research Assistant-Creates a field that allows you to choose a value from another table or a list of values using a combo box. Choosing this option in the Data Type list starts the Lookup Wizard to define the type of data.
well, I found it interesting text about tables, just not what I was looking for!
a + what i was looking for