Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Access Vocabulary
terms and defintions
| 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 |
Created by:
brianhall
Popular Computers sets