FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Creating a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Short Answer

Review LaterAdd Note

Review Later

 A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n) ____________________.

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

 The ____________________ option is available to compact and repair a database file automatically every time the database is closed.

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

 The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

Identify the letter of the choice that best matches the phrase or definition. - The specific content of a field. A)field value B)primary key C)Backstage view D)data type E)Current Record Box F)Create tab G)query H)Simple Query Wizard I)Print Preview J)File tab

 All of the data in a relational database are contained in ____________________.

 Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables? 

 Compacting a database rearranges the data and objects in a database to decrease its file size. _________________________ 

 Which Access feature provides information about Access commands and features and instructions about how to use them? 

 When creating a form in Access,the Layout view allows the user to make design changes to the form while it is displaying data. _________________________ 

 The query results are stored in the database in which the query has been created._________________________

 Which data type allows field values to contain letters,digits,and other characters? 

 A query is used to enter,edit,and view records in a database. _________________________ 

 When working with Access in ____ Mode,the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016. 

Identify the letter of the choice that best matches the phrase or definition. - AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.

Identify the letter of the choice that best matches the phrase or definition. - A field,or collection of fields,whose values are used to uniquely identify each record in a table.