Access Finals
About this set
Created by:
janiejohnston on May 6, 2010
Subjects:
Log in to favorite or report as inappropriate.
Order by
25 terms
Terms | Definitions |
|---|---|
 Access 2000 can best be described as ______ software. | database |
| The smallest piece of information in a database is called a ___ or category of information. | field |
| A group of related fields such as all the demographic information for one customer is called a ______. | record |
| A collection of records for a single subject, such as all of the customer records, is called a _____. | table |
| Table, queries, and modules are examples of Access ______. | objects |
| The term ________ database comes from the fact that two or more tables are linked by a common field. | relational |
| The Access object that contains all of the raw data within the database is the _____. | table |
| The access object which provides an easy-to-use data entry secreen is the _____. | form |
| A ______ is a collection of information associated with a topic such as sales. | database |
| The first step to planning a database is to determine the ____ and give it a ________. | purpose, meaningful title |
| Examples of databases could include: ____, _________, and _______. | 1) a library card catalog 2) a list of students attending St. Louis Catholic High School 3) an list addresses |
| An active field is the _________ field. | currently selected |
| The best way to repostion a field within a form is to ______________. | drag it to the new location |
| _______ View allows you to add, delete, or modify the fields in a table. | Design |
| "Updating" a record is defined as __________________________________. | changing the data already stored in a record to reflect changes. |
| As data is entered into a field from the keyboard, it is displayed on the ___________. | Entry bar |
| A _______ is a selected group of information extracted from a database, usually printed. | report |
| A calculation field stores a _______. | formula |
| After a query is applied to a database only those records that ______________. | match the query criteria are displayed |
| When a database is sorted __________________________. | the order of the records is changed based on the values specified. |
| If the number 50 were entered in a field formatted for currency and two decimal place, Access would display the number as ________. | $50.00 |
| Reasons for carefully planning a report before creating it could include: _______, ___________, and ___________. | 1) to determine how fields should appear when printed 2)to exclude unnecessary information 3) to make the report easier to read |
| On a report screen, a cell is the ______________________. | interestion of the column and the row |
| If 4500 were entered in a field formatted for commas with 3 decimal places, Accress would siplay the number as ________. | 4,500.000 |
| In Navigation mode, press [Tab] or _______ to move to the next field within the same record. | [Enter] |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.