Information Processing Access Study Guide--Lesson 1--Access Basics
Name:____________________________________________
Date of Test:______________________________

Study the following vocab words for an on-line test.
1. Database--an organized collection of facts about a particular subject
2. Database management system�provides funcitons to store, search, filter, query, and report on data in a database
3. Relational database management system�provides tools to link databases that contain related information
4. Database objects--tools to store, maintain, search analyze, and report on data in a database program (four database objects--tables, forms, queries, and reports
5. Table�spreadsheet format
6. Record--each row in a table--one person's data
7. Fields�items of data
8. Field names�way each field is identified/a table can have up to 255 fields
9. Field content�specific data in a field
10. Datasheet�-another name for table
11. Primary key�a field for a unique code or number for each record
12. Forms�used to display one record at a time
13. Queries--way to retrieve data that meets certain criteria for a table
14. REports--displays information retrieved from the database and analyzes the data specified
15. Wizard--a tool that asks you questions and then automatically designs an object
16. You establish a primary key to link tables.
17. View--Way to look at data or the structue of an object
18. Design view--create and modify table structures
19. Datasheet view--you can add, edit, delete, and view data.
20. Database objects have multiple views.
Hosted by www.Geocities.ws

1