MISY 5325 ACTIAL Final
Exam – Management
Information Systems Test
EXAM WITH QUESTIONS
AND CORRECT VERIFIED
ANSWERS GRADED A+
To create a new query in Design view, click CREATE on the ribbon to display the
CREATE tab and then click the ———- button to create a new query. - ANSWER-Query
Design
create a parameter query, enter a parameter rather than a specific value as a criterion
in the design grid. The parameter must be enclosed in - ANSWER-parameter square
brackets [ ]
, To create a split form, select the table in the Navigation Pane, click CREATE on the
ribbon, click the ———— button on the CREATE tab to display a menu, and then click
Split Form on the menu. - ANSWER-More Forms
To create a top-values query, use the Top Values box on the DESIGN tab to change
the number of records to be included from All to the desired number. - ANSWER-False
To create a validation rule for the State field to restrict entries to TN or TX, enter ———
—in the Validation Rule property box. - ANSWER-T
To create an update query, create a new query and then click the ———- button on the
DESIGN tab. - ANSWER-Update
To define an additional field in Datasheet view, tap or click the ———- column heading.
- ANSWER-Click to Add
To define an additional field in Datasheet view, tap or click the ———— column
heading, select the data type, and then type the field name. - ANSWER-Click to Add
To delete a database object, press and hold or right-click the object in the Navigation
Pane and then tap or click ———- on the shortcut menu. - ANSWER-Delete
To display the Total row in a datasheet, click the Sum button on the ribbon. Torf -
ANSWER-False
To enter a number in a criterion, type the number without any dollar signs or commas.t
or f - ANSWER-True
To export data from a query to Excel, select the query in the Navigation Pane, click —
——-on the ribbon, and then click the Excel button. - ANSWER-EXTERNAL DATA
To filter records using complex criteria, click the ———-button on the HOME tab and
then click Advanced Filter/Sort on the menu that appears. - ANSWER-Advanced
To find all accounts whose current due amounts are greater than $2,500.00 and whose
account manager is manager 31, enter each criterion on the same row. Torf -
ANSWER-True
To find duplicate records in a table, use the ———Query Wizard. - ANSWER-Find
Duplicates
To find the largest amount paid amount for a client, select ———-as the entry in the
Total row for the Amount Paid column. - ANSWER-MAX
Exam – Management
Information Systems Test
EXAM WITH QUESTIONS
AND CORRECT VERIFIED
ANSWERS GRADED A+
To create a new query in Design view, click CREATE on the ribbon to display the
CREATE tab and then click the ———- button to create a new query. - ANSWER-Query
Design
create a parameter query, enter a parameter rather than a specific value as a criterion
in the design grid. The parameter must be enclosed in - ANSWER-parameter square
brackets [ ]
, To create a split form, select the table in the Navigation Pane, click CREATE on the
ribbon, click the ———— button on the CREATE tab to display a menu, and then click
Split Form on the menu. - ANSWER-More Forms
To create a top-values query, use the Top Values box on the DESIGN tab to change
the number of records to be included from All to the desired number. - ANSWER-False
To create a validation rule for the State field to restrict entries to TN or TX, enter ———
—in the Validation Rule property box. - ANSWER-T
To create an update query, create a new query and then click the ———- button on the
DESIGN tab. - ANSWER-Update
To define an additional field in Datasheet view, tap or click the ———- column heading.
- ANSWER-Click to Add
To define an additional field in Datasheet view, tap or click the ———— column
heading, select the data type, and then type the field name. - ANSWER-Click to Add
To delete a database object, press and hold or right-click the object in the Navigation
Pane and then tap or click ———- on the shortcut menu. - ANSWER-Delete
To display the Total row in a datasheet, click the Sum button on the ribbon. Torf -
ANSWER-False
To enter a number in a criterion, type the number without any dollar signs or commas.t
or f - ANSWER-True
To export data from a query to Excel, select the query in the Navigation Pane, click —
——-on the ribbon, and then click the Excel button. - ANSWER-EXTERNAL DATA
To filter records using complex criteria, click the ———-button on the HOME tab and
then click Advanced Filter/Sort on the menu that appears. - ANSWER-Advanced
To find all accounts whose current due amounts are greater than $2,500.00 and whose
account manager is manager 31, enter each criterion on the same row. Torf -
ANSWER-True
To find duplicate records in a table, use the ———Query Wizard. - ANSWER-Find
Duplicates
To find the largest amount paid amount for a client, select ———-as the entry in the
Total row for the Amount Paid column. - ANSWER-MAX
