chapter 17 - ms access Flashcards
It is the foundation of any database.
table
made up of fields.
record
A ______ like other things in Access, can have up to 64 characters.
➢ It can contain letters, numbers, and symbols except for a period (.), an
exclamation point (!), an accent grave (`), brackets ([ ]), and double quote
mark (“).
➢ You cannot start it with space(s).
field
Can hold over 60,000 plain text characters. Cannot contain formatting.
memo
a text can have less than ___ and its default field size is ____
255, 50
Great to use for an primary key.
autonumber
requires that values be between 0 and 255 and uses 1 byte of storage.
Byte
can hold whole numbers between –32,768 and 32,767 in 2 bytes of storage.
Integer
can hold a 7 digit decimal number in 4 bytes.
Single
can hold whole numbers between -2,147,483,648 and 2,147,483,647 (over 2 trillion!) in 4 bytes of
storage.
Long Integer
can hold a 15 digit decimal number in 8 bytes.
Double
can hold a 28 digit decimal number in 12 bytes.
Decimal
Starts a wizard that will create a list of values to choose from for the field.
lookup wizard
backs up one field to the left
shift + tab
A record in one table is linked to one or more records in another table
one to many
A record in one table is linked to one record in another table
one to one
Records in one table is linked to several records in another table
many to many
It is a key in a relational database that is unique for each record
primary key
It is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table
foreign key
