Access-lesson 1 key terms.

1. Database- A collection of data related to a perticular topic. An Access database is a single file that contains all the tables, queries, forms, and reports for that collection of information.

2. Database object- Tables. quieries, reports, forms and other objects that are the functional parts of an Access database.

3. Database window- The window that appears when you first open an Access database. the Database window gives you accesss to all the objects in a database.

4. Datasheet- In Access, dat displayed in a row-and-column format in a table, query, or form.

5. Datasheet view- In Access, an object view that displays records in a row -and-colmn format similar to a spreadsheet. Datasheet view allows you to see many records at the same time.

6. Design view- An Access, an object view that allows you to design and change tables, queries, forms, reports, and other objects.

7. Field- 1. In Word, a special plaeholder for changeable information such as the date or time.
2. In Access, a field is displayed as a column in Datasheet view.

8. Form View- In Access, an object view that usually displays data one record at a time, with added graphical elements for easier reading. this view is convenient for entering and editing data in tables.

9. Print Preview- A document view that shows how your document will look when it is printed.

10. Query- In Access, a databse object that shows specific data you want to work with. The data may be drawn from multiple related tables, may have several filters applied, and may include calculated expressions.

11. Record- In Access, a set of information that belongs together, such as a customer's name and address information, or details about a product.

12. Record Selector- In Access, the gray box at the left side of each record in Datasheet view or in form view. Click the record selector to select the entire record.

13. Relational database- a type of database in which information is stored in seperate but related tables, which allows for nonredundant, more efficient data storage and retrieval.

14. Report- In Access, a database object that presents data organized and formatted to your specifications.

15. Table- 1. In Word, a grid made up of horizontal rows and vertical columns that is used to order certain types if infomation.
2. In Access, a collection of data with the same subject or topic. Data are stored in records (rows) and fields (columns).