Exam (elaborations)
MISY 5325 FINAL EXAM ACTUAL EXAM WITH COMPLETE QUESTIONS AND ACCURATE ANSWERS GRADED A+
- Course
- Institution
MISY 5325 FINAL EXAM ACTUAL EXAM WITH COMPLETE QUESTIONS AND ACCURATE ANSWERS GRADED A+
[Show more]
Content preview
MISY 5325 FINAL EXAM 2024- 2025 ACTUALEXAM WITH COMPLETE QUESTIONS AND
ACCURATE ANSWERS GRADED A+
1. To compact and repair a database, tap or click ———— button
in the Info gallery in the Backstage view. Correct Answer
Compact & Repair
2. To combine criteria with ———— place the criteria on the
same row. Correct Answer AND
3.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. Correct Answer Query Design
4.To create a multivalued field, create a ———— field being sure
to check the Allow Multiple Values check box. Correct Answer
lookup
5. To create a lookup field, select ————- from the menu of
available data types. Correct Answer Lookup Wizard
6. To create a crosstab, click the———— button on the CREATE
tab. Correct Answer crosstab, Query Wizard
7. 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 Correct Answer parameter square brackets [
]
8. 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. Correct Answer More Forms
9. To create a multivalued field, create a ———— field being sure
to check the Allow Multiple Values check box. Correct Answer
lookup
10. 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. Correct Answer False
11. To create a validation rule for the State field to restrict entries
to TN or TX, enter ————in the Validation Rule property box.
Correct Answer T
12. To create an update query, create a new query and then click
the ———- button on the DESIGN tab. Correct Answer Update
13. To define an additional field in Datasheet view, tap or click the
———- column heading. Correct Answer Click to Add
14. To define an additional field in Datasheet view, tap or click the
———— column heading, select the data type, and then type the
field name. Correct Answer Click to Add
15. 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. Correct Answer Delete
16. To delete a field from a table, open the table in ———- view,
click the row selector for the field to be deleted, and then press
the DELETE key. Correct Answer Answer: Design
17. To delete a field in a table, press and hold or right-click the
column heading for the field, and then tap or click ————-on the
shortcut menu. Correct Answer Delete Field
,18. To delete a field, press and hold or right-click the column
heading for the field, and then tap or click Remove Field on the
shortcut menu. T/F Correct Answer False
19. To delete a record, tap or click the record selector for the
record, and then press the key(s). Correct Answer DELETE
20. To display the Total row in a datasheet, click the Sum button
on the ribbon. Torf Correct Answer False
21. To enter a number in a criterion, type the number without any
dollar signs or commas.t or f Correct Answer True
22. 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. Correct Answer EXTERNAL DATA
23. To filter records using complex criteria, click the ———-button
on the HOME tab and then click Advanced Filter/Sort on the
menu that appears. Correct Answer Advanced
24. 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 Correct Answer True
25. To find duplicate records in a table, use the ———Query
Wizard. Correct Answer Find Duplicates
26. To find the largest amount paid amount for a client, select —
——-as the entry in the Total row for the Amount Paid column.
Correct Answer MAX
27. To include all fields for a table in the design grid, double-click
the ———in the field list. Correct Answer asterisk (*)
, 28. To include all fields in the design grid, double-click the
question mark (?) in the field list. T or f Correct Answer False
29. To include calculated fields in queries, enter a name for the
calculated field, a(n) ——-and then the expression in one of the
columns in the Field row. Correct Answer colon (:)
30. To include the Total row in the design grid, click the button on
the DESIGN tab. Correct Answer Totals
31. To include totals and other statistics at the bottom of a
datasheet, click the ———-button on the HOME tab to include the
Total row in the datasheet. Correct Answer Totals
32. To indicate grouping in Access, select ————as the entry in
the Total row for the field to be used for grouping. Correct Answer
Group By
33. To insert a field between existing fields, for the field that will
follow the new field, and then tap or click ———on the shortcut
press and hold or right-click the column heading menu. Correct
Answer Insert Field
34. To insert a field between existing fields, press and hold or
right-click the column heading for the field that will follow the new
field, and then tap or click on the shortcut menu. Correct Answer
Insert Field
35. To insert a field between existing fields, press and hold or
right-click the column heading for the field that will follow the new
field, and then tap or click Insert Column the shortcut menu. T or f
Correct Answer False
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller wachiraMaureen. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $24.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81503 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now