Question 1

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

Accepted Answer

A)  resize the object 
B)  delete the object and recreate it 
C)  move the object to another location 
D)  change the caption 
A)  resize the object 
B)  delete the object and recreate it 
C)  move the object to another location 
D)  change the caption

Question 2

Query elements may be added to a form to improve its appearance or add visual appeal.___________________

Accepted Answer

A) True 
 B)False

Question 3

Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.

Accepted Answer

The answer of Precise control for moving selected objects on...

Question 4

The less precise way to move objects in report Layout view is to ____.

Accepted Answer

A)  use the Move command to move objects 
B)  use the arrow keys on the keyboard to move objects 
C)  drag objects 
D)  use the insert key on the keyboard to move objects 
A)  use the Move command to move objects 
B)  use the arrow keys on the keyboard to move objects 
C)  drag objects 
D)  use the insert key on the keyboard to move objects

Question 5

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

Accepted Answer

A)  # 
B)  + 
C)  (?) 
D)  * 
A)  # 
B)  + 
C)  (?) 
D)  *

Question 6

Case-Based Critical Thinking Questions Case 4-2
Carmen and Sergio have created a database for the Spring Fling event at their college.  Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event.  The tables and fields for the database along with established relationships are illustrated in the figure below.
 
The first report Carmen would like to create will include all participants and the balance due to participate in the Spring Fling.  Which two tables should Carmen use to create the report?

Accepted Answer

A) ParticipantAccount and RequestedResources 
B) ParticipantAccount and Location 
C) ParticipantInformation and ParticpantAccount 
D) Location and RequestedResources 
A) ParticipantAccount and RequestedResources 
B) ParticipantAccount and Location 
C) ParticipantInformation and ParticpantAccount 
D) Location and RequestedResources

Question 7

Which of the following may be used as a wildcard character when searching for a value in Access?

Accepted Answer

A)  % 
B)  # 
C)  ^ 
D)  & 
A)  % 
B)  # 
C)  ^ 
D)  &

Question 8

Layout view shows both the form and its data while allowing the form to be modified.

Accepted Answer

A) True 
 B)False

Question 9

Case-Based Critical Thinking Questions Case 4-2
Carmen and Sergio have created a database for the Spring Fling event at their college.  Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event.  The tables and fields for the database along with established relationships are illustrated in the figure below.
 
The faculty sponsor has asked Carmen to create a report that includes the participant email address and the location site assigned to the participant. He would also like to know how many tables and chairs each participant needs. Which tables and fields does Carmen need to use to create the report?

Accepted Answer

A)  ParticipantInformation:Email ParticipantAccount:ParticipantID
RequestedResources:TableQuantity
RequestedResources:ChairQuantity 
B)  ParticipantInformation:Email ParticipantAccount:LocationSite
RequestedResources:TableQuantity
RequestedResources:ChairQuantity 
C)  ParticipantInformation:ParticipantID Location:LocationSite
RequestedResources:TableQuantity
RequestedResources:ChairQuantity 
D)  PatientAccount:LocationSite Location:ParticipantID
RequestedResources:TableQuantity
RequestedResources:ChairQuantity 
A)  ParticipantInformation:Email ParticipantAccount:ParticipantID
RequestedResources:TableQuantity
RequestedResources:ChairQuantity 
B)  ParticipantInformation:Email ParticipantAccount:LocationSite
RequestedResources:TableQuantity
RequestedResources:ChairQuantity 
C)  ParticipantInformation:ParticipantID Location:LocationSite
RequestedResources:TableQuantity
RequestedResources:ChairQuantity 
D)  PatientAccount:LocationSite Location:ParticipantID
RequestedResources:TableQuantity
RequestedResources:ChairQuantity

Question 10

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

Accepted Answer

A)  single table 
B)  datasheet layout 
C)  single record 
D)  subform layout 
A)  single table 
B)  datasheet layout 
C)  single record 
D)  subform layout

Question 11

Match between columns
                        Premises: The wildcard character that will match any single numeric character.

Accepted Answer

The Answer of Find and (?) and # and Design is...

Question 12

When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option. ____________________

Accepted Answer

A) True 
 B)False

Question 13

Clicking the  
     button moves all fields from the Available Fields box to the Selected Fields box using the Report Wizard.

Accepted Answer

A) True 
 B)False

Question 14

An item on a form or report object that can be manipulated to modify an object's appearance is a(n) ____.

Accepted Answer

A)  element 
B)  property 
C)  control 
D)  layout 
A)  element 
B)  property 
C)  control 
D)  layout

Question 15

Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.

Accepted Answer

Answers might include: 
(1) It is import

Question 16

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

Accepted Answer

A)  primary record 
B)  detail record 
C)  secondary table 
D)  record values 
A)  primary record 
B)  detail record 
C)  secondary table 
D)  record values

Question 17

Match between columns
                        Premises: The button used to display the Find and Replace dialog box.

Accepted Answer

The Answer of # and Themes and Layout view and is...

Question 18

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field.

Accepted Answer

A) True 
 B)False

Question 19

A placeholder used in a value search when only part of a value is known is called a ____________________ character.

Accepted Answer

The answer of A placeholder used in a value search...

Question 20

Field values edited in Form view are also changed in the form's underlying table. ____________________

Accepted Answer

A) True 
 B)False

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

Query elements may be added to a form to improve its appearance or add visual appeal.___________________

Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.

The less precise way to move objects in report Layout view is to ____.

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

Which of the following may be used as a wildcard character when searching for a value in Access?

Layout view shows both the form and its data while allowing the form to be modified.

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option. ____________________

Clicking the button moves all fields from the Available Fields box to the Selected Fields box using the Report Wizard.

An item on a form or report object that can be manipulated to modify an object's appearance is a(n) ____.

Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field.

A placeholder used in a value search when only part of a value is known is called a ____________________ character.

Field values edited in Form view are also changed in the form's underlying table. ____________________

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

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 5: Creating Forms and Reports

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

Query elements may be added to a form to improve its appearance or add visual appeal.___________________

Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.

The less precise way to move objects in report Layout view is to ____.

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

Which of the following may be used as a wildcard character when searching for a value in Access?

Layout view shows both the form and its data while allowing the form to be modified.

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option. ____________________

Clicking the button moves all fields from the Available Fields box to the Selected Fields box using the Report Wizard.

An item on a form or report object that can be manipulated to modify an object's appearance is a(n) ____.

Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field.

A placeholder used in a value search when only part of a value is known is called a ____________________ character.

Field values edited in Form view are also changed in the form's underlying table. ____________________

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

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