Question 1

Match between columns
                        Premises: A field, or collection of fields, whose values are used to uniquely identify each record in a table.

Accepted Answer

The Answer of Create tab and Current Record Box and is...

Question 2

In the accompanying figure, which field must be used to create a relationship between the Patient table and the Visit table?

Accepted Answer

A)  FirstName 
B)  PatientID 
C)  VisitID 
D)  VisitDate 
A)  FirstName 
B)  PatientID 
C)  VisitID 
D)  VisitDate

Question 3

Match between columns
                        Premises: An Access 2013 tool that allows the user to quickly add fields and records to display in query results.

Accepted Answer

The Answer of Print Preview and primary key and field is...

Question 4

A relationship between two tables in a database is formed using a(n) Backstage field. _________________________

Accepted Answer

A) True 
 B)False

Question 5

The default sort order for records in an Access table is based on the values in the primary key field. _________________________

Accepted Answer

A) True 
 B)False

Question 6

In a relational DBMS, a user may create a database structure that contains which of the following?

Accepted Answer

A)  data, fields, and table relationships 
B)  numbers, tables, and fields 
C)  symbols, numbers, and tables 
D)  fields, tables, and table relationships 
A)  data, fields, and table relationships 
B)  numbers, tables, and fields 
C)  symbols, numbers, and tables 
D)  fields, tables, and table relationships

Question 7

A formatted printout (or screen display) of the contents of one or more tables or queries is a(n) form . _________________________

Accepted Answer

A) True 
 B)False

Question 8

A table's contents are shown in rows and columns when using the ____________________ view.

Accepted Answer

The answer of A table's contents are shown in rows...

Question 9

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

Accepted Answer

The answer of There are two ways to move vertically...

Question 10

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

Accepted Answer

A)  wide fit 
B)  best fit 
C)  column adjustment fit 
D)  trim fit 
A)  wide fit 
B)  best fit 
C)  column adjustment fit 
D)  trim fit

Question 11

The ____________________ box in the Navigation Pane (displayed in the accompaying figure) allows the Access user to search for all database objects that contain a specific value, such as the city, "Albany."

Accepted Answer

The answer of   
The ____________________ box in the...

Question 12

The specific content of a field is referred to as the ____.

Accepted Answer

A)  field content 
B)  field value 
C)  table value 
D)  column value 
A)  field content 
B)  field value 
C)  table value 
D)  column value

Question 13

Each column in an Access table datasheet represents a ____.

Accepted Answer

A)  query 
B)  record 
C)  field 
D)  primary key 
A)  query 
B)  record 
C)  field 
D)  primary key

Question 14

Case 1-1Lisel is the Student Body President of her college. She is organizing a Fun Run/Walk fund-raising event to benefit the local Children's Hospital. Lisel wants to create an Access database to manage event vendors, the venue, participants, donors, and donations. Before the event takes place, Lisel and the student government representatives must contact vendors and ask for their participation in the event. Also, participants in the event must be registered and issued an entry number.
Three tables are necessary for the database: Vendors, Participants, and Venue. Fields in the Vendors table will include: Vendor Name, Vendor Contact Information, Venue Space Assigned. Fields in the Participants table will include: FirstName, LastName, ParticipantNumber, Donation, and Donors. The Venue table will include: TentNumber and TentSize. Choose the best answer for the questions below.When Lisel created the Participants table for the event participants, she used the Access default primary key field and did not change the name of the field. What field name was used as the primary key in the Participants table?

Accepted Answer

ID - this is the def

Question 15

Using the accompanying figure, which Ribbon group and button would be used to create a new record in an Access database table?

Accepted Answer

A)  Find group, Go To button 
B)  Records group, Save button 
C)  Records group, New button 
D)  Sort & Filter group, Advanced button 
A)  Find group, Go To button 
B)  Records group, Save button 
C)  Records group, New button 
D)  Sort & Filter group, Advanced button

Question 16

Which of the following is an Access 2013 database object?

Accepted Answer

A)  record 
B)  field 
C)  data 
D)  table 
A)  record 
B)  field 
C)  data 
D)  table

Question 17

Match between columns
                        Premises: The Access Ribbon tab that offers the option for the user to compact and repair a database.

Accepted Answer

The Answer of Current Record Box and field value and is...

Question 18

All data in a database is contained in which database object?

Accepted Answer

A)  query 
B)  form 
C)  report 
D)  table 
A)  query 
B)  form 
C)  report 
D)  table

Question 19

Clicking on the Close option from the Backstage view in Access 2013 performs which of the following tasks?

Accepted Answer

A)  closes the current database 
B)  closes the current database and exits Access 2013 
C)  closes only the current database object 
D)  copies the current database and exits Access 2013 
A)  closes the current database 
B)  closes the current database and exits Access 2013 
C)  closes only the current database object 
D)  copies the current database and exits Access 2013

Question 20

What are the five primary functions of a Database Management System (DBMS)?

Accepted Answer

1. A DBMS allows the creation of databas

In the accompanying figure, which field must be used to create a relationship between the Patient table and the Visit table?

A relationship between two tables in a database is formed using a(n) Backstage field. _________________________

The default sort order for records in an Access table is based on the values in the primary key field. _________________________

In a relational DBMS, a user may create a database structure that contains which of the following?

A formatted printout (or screen display) of the contents of one or more tables or queries is a(n) form . _________________________

A table's contents are shown in rows and columns when using the ____________________ view.

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

The ____________________ box in the Navigation Pane (displayed in the accompaying figure) allows the Access user to search for all database objects that contain a specific value, such as the city, "Albany."

The specific content of a field is referred to as the ____.

Each column in an Access table datasheet represents a ____.

Using the accompanying figure, which Ribbon group and button would be used to create a new record in an Access database table?

Which of the following is an Access 2013 database object?

All data in a database is contained in which database object?

Clicking on the Close option from the Backstage view in Access 2013 performs which of the following tasks?

What are the five primary functions of a Database Management System (DBMS)?

Managing Your Files

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters

Exam 2: Creating a Database

In the accompanying figure, which field must be used to create a relationship between the Patient table and the Visit table?

A relationship between two tables in a database is formed using a(n) Backstage field. _________________________

The default sort order for records in an Access table is based on the values in the primary key field. _________________________

In a relational DBMS, a user may create a database structure that contains which of the following?

A formatted printout (or screen display) of the contents of one or more tables or queries is a(n) form . _________________________

A table's contents are shown in rows and columns when using the ____________________ view.

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

The ____________________ box in the Navigation Pane (displayed in the accompaying figure) allows the Access user to search for all database objects that contain a specific value, such as the city, "Albany."

The specific content of a field is referred to as the ____.

Each column in an Access table datasheet represents a ____.

Using the accompanying figure, which Ribbon group and button would be used to create a new record in an Access database table?

Which of the following is an Access 2013 database object?

All data in a database is contained in which database object?

Clicking on the Close option from the Backstage view in Access 2013 performs which of the following tasks?

What are the five primary functions of a Database Management System (DBMS)?

Managing Your Files

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters