Table design grid
top portion of the table window where you enter values for the Field Name, Data Type, and description field properties.
Allows you to move from the Table Design grid to the field properties pane
allows you to define or modify a table structure or the properties of the fields in a table
used to enter an optional description for a field to explain its purpose or usage.
Field Properties Pane
select values for all other field properties, most of which are optional
when two or more fields might be needed to function as the primary key.
used to connect one table logically with another table.
when you store data in more than one place
characteristics of each field so that the DBMS knows how to store, display and process the field values.
when you select or enter a value.
Field Size property
defines a field value's maximum storage size for Text, Number and AutoNumber fields only.
specifies for a field how the field name is displayed in database objects, including table, and query datasheets, forms, and reports.
stores whole numbers from 0 to 255 in one byte
Stores whole numbers from -32,768 to 32,767 in two bytes
(default) Stores whole numbers from -2,147,483,648 to 2,147,438,647 in four bytes
Stores positive and negative numbers to precisely seven decimal places and uses four bytes
Stores positive and negative numbers to precisely 15 decimal places and uses eight bytes.
establishes an unique identifier for replication of tables, records and other objects in databases created using Access 2003 and earlier versions and uses 16 bytes
Stores positive and negative numbers to precisely 28 decimal places and uses 12 bytes.
Decrease Decimal button
Access decreases the decimal places by one
Show Table Button
used to open the Show Table dialog box. From there you can choose a table to add to the relationships window.
illustrates the relationships among a database's tables. Used to view or change existing relationships, define new relationships between tables, and rearrange the layout of the tables in the window.
exists between two tables when one record in the first table matches zero, one, or many records in the second table and when one record in the second table matches at most one record in the first table.
is the "one" table in a one-to-many relationship.
connects the common field used to create the relationship between two tables.
is the "many" table in a one-to-many relationship
When you add a table to the relationships window, the fields in the table appear here.
process that allows you to copy the data from a source without having to open the source file.
Data type gallery
available in the Add & Delete group on the Fields tab, allows you to add a group of related fields to a table at the same time.
Quick Start selection
The group of fields you add using the Data Type gallery.
delimited text file
one in which fields of data are separated by a character such as a comma or a tab.
the process of creating tables.
a set of rules that Access enforces to maintain consistency between related tables when you update data in a database.
Cascade Update Related Fields option
access permits the change in value to the primary key and changes the appropriate foreign key values in the related table eliminating the possibility of inconsistent data.
Cascade Delete Related Records Option
Access deletes the record in the primary table and also deletes all records in related tables that have matching foreign key values.