DBMS Exam – Questions And Answers (100% Correct)
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 Right Ans - Detail Record
Viewing and printing options for forms and records are available on the ____
tab. Right Ans - PRINT PREVIEW
Data in Date/Time fields are automatically ____-aligned Right Ans - Right
To design a form using the Form Wizard begin by clicking on the ____ tab on
the Access Ribbon. Right Ans - CREATE
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. Right Ans - *
The appearance of text on a form or report is changed using the "Design"
group on the FORMAT table on the Ribbon Right Ans - False
The Form Wizard limits fields to be used in a form to one table or one query
Right Ans - False
A form created from more than one table uses the primary table for the main
form. Right Ans - True
The less precise way to move objects in report Layout view is to ____. Right
Ans - Drag objects
Field values "edited" in Form view are also changed in the form's underlying
table. Right Ans - True
After a conditional formatting rule is created used the ____ dialog box, the rule
is then available for use in the database from the Conditional Formatting
Rules Manager dialog box. Right Ans - New Formatting Rule
Layout view shows both the form and its data while allowing the form to be
modified. Right Ans - True
, A form's object name appears on the tab for the form in the Access window.
Right Ans - True
The Columnar form layout displays the fields from one record at a time.
Right Ans - True
Data in a form created from the primary table is contained in the ____. Right
Ans - Main form
To print two records from a form, select the ____ option in the Print dialog box.
Right Ans - Selected Record(s)
The Tabular and Justified form report layouts display the fields from multiple
records at one time. Right Ans - False
Formatting used in a report that is applied to certain field values depending
on the conditions set for the values is ____ formatting. Right Ans -
Conditional
When a form is created based on two or more tables, a relationship must be
defined between queries. Right Ans - False
Report fields and field value boxes may be re-positioned while viewing the
report in Layout view. Right Ans - True
Field values edited in Form view are also changed in the form's underlying
table. Right Ans - True
The appearance of fields in a report that is created using the Report Wizard is
determined by ____. Right Ans - The order the fields are selected in a Report
Wizard
A ____ is a placeholder used in a search when the search should start or end
with a specific character or match a particular pattern. Right Ans -
Wildcard character
The ____ is located to the right of the navigation buttons and is used to locate a
specific record in a form. Right Ans - Search box
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 Right Ans - Detail Record
Viewing and printing options for forms and records are available on the ____
tab. Right Ans - PRINT PREVIEW
Data in Date/Time fields are automatically ____-aligned Right Ans - Right
To design a form using the Form Wizard begin by clicking on the ____ tab on
the Access Ribbon. Right Ans - CREATE
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. Right Ans - *
The appearance of text on a form or report is changed using the "Design"
group on the FORMAT table on the Ribbon Right Ans - False
The Form Wizard limits fields to be used in a form to one table or one query
Right Ans - False
A form created from more than one table uses the primary table for the main
form. Right Ans - True
The less precise way to move objects in report Layout view is to ____. Right
Ans - Drag objects
Field values "edited" in Form view are also changed in the form's underlying
table. Right Ans - True
After a conditional formatting rule is created used the ____ dialog box, the rule
is then available for use in the database from the Conditional Formatting
Rules Manager dialog box. Right Ans - New Formatting Rule
Layout view shows both the form and its data while allowing the form to be
modified. Right Ans - True
, A form's object name appears on the tab for the form in the Access window.
Right Ans - True
The Columnar form layout displays the fields from one record at a time.
Right Ans - True
Data in a form created from the primary table is contained in the ____. Right
Ans - Main form
To print two records from a form, select the ____ option in the Print dialog box.
Right Ans - Selected Record(s)
The Tabular and Justified form report layouts display the fields from multiple
records at one time. Right Ans - False
Formatting used in a report that is applied to certain field values depending
on the conditions set for the values is ____ formatting. Right Ans -
Conditional
When a form is created based on two or more tables, a relationship must be
defined between queries. Right Ans - False
Report fields and field value boxes may be re-positioned while viewing the
report in Layout view. Right Ans - True
Field values edited in Form view are also changed in the form's underlying
table. Right Ans - True
The appearance of fields in a report that is created using the Report Wizard is
determined by ____. Right Ans - The order the fields are selected in a Report
Wizard
A ____ is a placeholder used in a search when the search should start or end
with a specific character or match a particular pattern. Right Ans -
Wildcard character
The ____ is located to the right of the navigation buttons and is used to locate a
specific record in a form. Right Ans - Search box
