Question 1

To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.

Accepted Answer

A) HOME 
B) CREATE 
C) FILE 
D) EDIT 
A) HOME 
B) CREATE 
C) FILE 
D) EDIT

Question 2

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon. ____________________

Accepted Answer

A) True 
 B)False

Question 3

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

Accepted Answer

The answer of A set of controls grouped together in...

Question 4

The Columnar form layout displays the fields from one record at a time.  ____________________

Accepted Answer

A) True 
 B)False

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

Match between columns
                        Premises: The view that gives the most detailed view of the structure of a form or report.

Accepted Answer

The Answer of Design view and Themes and Pencil symbol is...

Question 7

A report formatted where the page is taller than it is wide is formatted in ____.

Accepted Answer

A) landscape orientation 
B) primary datasheet orientation 
C) portrait orientation 
D) Wizard orientation 
A) landscape orientation 
B) primary datasheet orientation 
C) portrait orientation 
D) Wizard orientation

Question 8

To select both a field label and field value to move in a report design, after selecting the field label press the ____ key to select the field value box.

Accepted Answer

A) Ctrl 
B) Alt 
C) F2 
D) Shift 
A) Ctrl 
B) Alt 
C) F2 
D) Shift

Question 9

The first, last, next, or previous page in a report may be displayed using the ____________________ buttons.

Accepted Answer

The answer of The first, last, next, or previous page...

Question 10

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

Accepted Answer

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

Question 11

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.

Accepted Answer

A) report 
B) field 
C) conditional 
D) criteria 
A) report 
B) field 
C) conditional 
D) criteria

Question 12

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 13

Match between columns
                        Premises: The easiest way to move a picture on a form is to first remove the picture from the ____.

Accepted Answer

The Answer of Design view and $?$ and  ! is...

Question 14

Data in Date/Time fields are automatically ____-aligned.

Accepted Answer

A) left 
B) right 
C) center 
D) top 
A) left 
B) right 
C) center 
D) top

Question 15

The Tabular and Justified form report layouts display the fields from multiple records at one time. ____________________

Accepted Answer

A) True 
 B)False

To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon. ____________________

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

The Columnar form layout displays the fields from one record at a time. ____________________

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.

A report formatted where the page is taller than it is wide is formatted in ____.

To select both a field label and field value to move in a report design, after selecting the field label press the ____ key to select the field value box.

The first, last, next, or previous page in a report may be displayed using the ____________________ buttons.

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.

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

Data in Date/Time fields are automatically ____-aligned.

The Tabular and Justified form report layouts display the fields from multiple records at one time. ____________________

Access-Module 1: 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 Securing a Database

Relational Databases and Database Design

Filters

Exam 4: Creating Forms and Reports

To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon. ____________________

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

The Columnar form layout displays the fields from one record at a time. ____________________

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.

A report formatted where the page is taller than it is wide is formatted in ____.

To select both a field label and field value to move in a report design, after selecting the field label press the ____ key to select the field value box.

The first, last, next, or previous page in a report may be displayed using the ____________________ buttons.

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.

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

Data in Date/Time fields are automatically ____-aligned.

The Tabular and Justified form report layouts display the fields from multiple records at one time. ____________________

Access-Module 1: 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 Securing a Database

Relational Databases and Database Design

Filters