ACC T1: Creating A Database Paper

ACC T1 - Creating a Database

Modified True/False
Indicate whether the statement is true or false. If false, change the identified word or phrase to make the statement true.

1. Defining a(n) primary key in a second table creates a relationship between that table and the table where the primary key was first defined. _________________________

2. One benefit of a relational database management system is that it contains a built-in query language, which lets you obtain immediate answers to the questions you ask about your data. _________________________

3. A(n) relational database management system provides protection for your data through the use of security, control, and recovery facilities. _________________________

4. A(n)
template is a predesigned database that includes professionally designed tables, reports, and other database objects that can make it quick and easy for you to create a database.
_________________________

5. A field name can consist of up to 255 characters. _________________________

6. When you create a table in Datasheet view, you can use the options in the Database group on the Fields tab to add fields to your table.
_________________________

7. The item marked 1 in the accompanying figure is the field selector. _________________________

8. The field marked 2 in the accompanying figure is the record selector.

9. Access has a button you can use to save the active database. _________________________

10.
The item marked 2 in the accompanying figure is the First record button. _________________________

11. The item marked 3 in the accompanying figure is the Next record button. _________________________

12. The item marked 4 in the accompanying figure is the New (blank) record button. _________________________

13. In Design view, you can make design changes to the form while it is displaying data, so that you can see the effects of the changes you make immediately. _________________________

14. Backing up a database rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly. _________________________

15. To back up your database, click the Home tab to display Backstage view, click the Save & Publish tab in the navigation bar, click Back Up Database in the Advanced section of the Save Database As pane, and then click the Save As button. _________________________

Matching

Identify the letter of the choice that best matches the phrase or definition.
a. field g. foreign key
b. table h. relational DBMS
c. field value i. report
d. relational database j. backing
up
e. common field k. compact
f. primary key l. query

16. Organizes data as a collection of tables

17. A collection of related tables

18. The specific content of a field

19. Connects the records in separate tables

20. A single characteristic or attribute of a person, a place, an object, an event, or an idea

21. A primary key from one table that is used to form a relationship with a second table

22. A collection of fields that describe a person, a place, an object, an event, or an idea

23. A field or collection of fields whose values uniquely identify each record in a table

24. A question you ask about data stored in a database

25. A formatted printout (or screen display) of the contents of one or more tables

26. To rearrange the data and objects in a database file, to decrease its file size

27. The process of making a copy of the database file to protect your data against loss or damage.