Microsoft Access

1. A database is an organized collection of information.

True

False

2. Which of the following is a way to sort data?

Chronologically

Alphabetically

Numerically

All of the above

None of the above

3. If you sort data in order of decreasing value such as Z-A, or 10-1, what type of sort are you using?

Ascending

Descending

Incremental

Exponential

4. A computerized database can store millions of telephone numbers.

True

False

5. A query lets you speed up the prowsing process by finding information that matches specifically to your criteria.

True

False

6. One disadvantage of computerized databases is that they limit your ability to arrange information.

True

False

7. A property rental database acts as an index to let users find and view all properties leased by landlords.

True

False

8. A database is a collection of related information, but a database management system is a type of software program.

True

False

9. The use of a password can help preserve a database's _____________.

Privacy

Security

Accurace

Integrity

10. A field's data type determines what kind of information can be stored there.

True

False

11. What does a filter do?

Make more records available

Hide records from view

Slow down processing

Add to the quantity of data

12. What is a query?

A question you ask a database

A question you ask a record

A question you ask a table

A question you ask a field

13. Which of he following is NOT a part of a database?

Tables

Records

Fields

Worksheets

14. In a database, each _________________ contains a collection of related data.

Table

Record

Field

None of the above

15. In a database, a _____________ is a unit of information about one individual or item.

Table

Record

Field

File

16. Once tables are created and defined, Access will automatically save data as you type without clicking save.

True

False

17. If you sort a database's information chronologically, then you are sorting letters and symbols.

True

False

18. Databases typically store all of the data you entered into one combined table.

True

False

19. If you want to view some but not all information in a table so you can insert data in a certain field for multiple records which feature would you most likely use?

Find & Replace

Filter

Sort

Freeze Panes

20. The same features that make databases efficient tools also enables them to keep data secure.

True

False

Microsoft Access

1. A database is an organized collection of information.

2.

What first name or nickname would you like us to use?

2. Which of the following is a way to sort data?

3. If you sort data in order of decreasing value such as Z-A, or 10-1, what type of sort are you using?

4. A computerized database can store millions of telephone numbers.

5. A query lets you speed up the prowsing process by finding information that matches specifically to your criteria.

6. One disadvantage of computerized databases is that they limit your ability to arrange information.

7. A property rental database acts as an index to let users find and view all properties leased by landlords.

8. A database is a collection of related information, but a database management system is a type of software program.

9. The use of a password can help preserve a database's _____________.

10. A field's data type determines what kind of information can be stored there.

11. What does a filter do?

12. What is a query?

13. Which of he following is NOT a part of a database?

14. In a database, each _________________ contains a collection of related data.

15. In a database, a _____________ is a unit of information about one individual or item.

16. Once tables are created and defined, Access will automatically save data as you type without clicking save.

17. If you sort a database's information chronologically, then you are sorting letters and symbols.

18. Databases typically store all of the data you entered into one combined table.

19. If you want to view some but not all information in a table so you can insert data in a certain field for multiple records which feature would you most likely use?

20. The same features that make databases efficient tools also enables them to keep data secure.