Question | Answer |
Allows you to store,retrieve, analyze and print info | Database Management |
Collection of items | Database |
Lists the objecta in the database | Navigation pane |
Complete set of data | record |
a plane in which something is categorized | Field |
The data entered into a field | Field value |
The table displays its data organized into rows and columns | Datasheet view |
A table with data organised into rows and columns | datasheet |
a button used to select an entire field | field selector |
button used to select a record | record selector |
selects entire datasheet | datasheet selector |
auto resize the column for best width for the data | best fit |
rearranges how the database is stored on the disk and optimizes the performance of the database | Compacting |
Numbers, text, or combo of both used for the order | alphanumeric order |
adds a unique number to the primary key field for each record | autonumber |
creates a database with an empty table in it | blank database |
determines the kind of data you can enter in each field | data type |
enters the same field value in a field every time record is added | default value |
option used to describe what to enter in the field | description property |
the top half of the table window | design grid |
where you can add, delete, make changes to the way fields store data | design view |
the bottom of the table window | field properties pane |
describes a fields contents beyond basic data type | field property |
sets the number of characters you can put in a text number or autonumber field | field size property |
used to specify how you want access to deisplay numbers dates, times and text | format property |
field that contains a unique field value for each record in the table | primary key |
specifies whether you must enters a field valuein a record | required property |
creates the database and one or more tables query form and report objects | template |
selects records that match all of two or more conditions | and operator |
a menu that opens when you click an arrow | autofilter |
when a field displays a value calculated using other fields | calculated field |
a field appears in both tables | common field |
a way of telling the query which info you are interested in | condition |
names enclosed in small square brackets | expression |
temporarily displays records in a datasheet based on the condition | filter |
when you need a record with info from several fields | filter by form |
used and you select a field value | filter by selection |
common field in a related table | foreign key |
queries based on more than one table | multitable query |
the back of les 3 vocaB | |