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) …show more content…
_________________________
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. …show more content…
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
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) …show more content…
_________________________
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. …show more content…
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