Term
|
Definition
| A tool for organizing, storing, retrieving, and communicating groups of information that have similar characteristics |
|
|
Term
| What are the four database objects? |
|
Definition
| Tables, queries, forms and reports |
|
|
Term
|
Definition
| Stores data for the database. |
|
|
Term
| What do all databases contain at least one of? |
|
Definition
|
|
Term
| What is a row called in a database? |
|
Definition
|
|
Term
| What is a column called in a database? |
|
Definition
|
|
Term
|
Definition
| A group of related fields |
|
|
Term
|
Definition
| One bit of information in a record; comprised by entries |
|
|
Term
|
Definition
| Data typed into a field; made up of characters |
|
|
Term
| What is the function of the data type? |
|
Definition
| Defines the value of the cell. |
|
|
Term
| What is the function of a field property? |
|
Definition
| Defines the format of the data within the cell. |
|
|
Term
| Why are data types important? |
|
Definition
| To control the sorting of data. |
|
|
Term
|
Definition
| Characters that do not require calculations. |
|
|
Term
|
Definition
| Lengthy text or combinations of text and numbers |
|
|
Term
|
Definition
| Characters used in mathematical calculations. |
|
|
Term
|
Definition
| Values and numeric data used in mathematical calculations involving data with four or more decimal places. |
|
|
Term
|
Definition
| Unique sequential number or random numbers |
|
|
Term
|
Definition
| Answers that contain only two values (also known as true/false) |
|
|
Term
| What is the lookup wizard? |
|
Definition
| Creates a field that allows you to choose a value from another table or from a list of values using a list box or combo box. |
|
|
Term
| When should you change the default data type? |
|
Definition
| If you need to control how the data in a particular field will be searched, sorted or used on calculations. |
|
|
Term
|
Definition
| The maximum number of characters you can put in the field (255) |
|
|
Term
|
Definition
| A display layout for the field; can customize the way numbers, dates, times and text are displayed and printed |
|
|
Term
|
Definition
| Makes data easier and to control the values users can enter. |
|
|
Term
|
Definition
| A label that gives a brief description to the user. |
|
|
Term
| When should you set a field property? |
|
Definition
| If you want to specify how the data will be entered, what data will be entered and how the data will appear. |
|
|
Term
| What is the first step to making a database? |
|
Definition
|
|
Term
| What is always the last step to making a database? |
|
Definition
|
|
Term
| What should you do as soon as you open a database? |
|
Definition
|
|
Term
| What do you do after you have saved the database? |
|
Definition
|
|
