100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
MISY 5325 Final 1-70 Questions and Answers New (2024/2025) Solved 100% Correct $7.99
Add to cart
Quickly navigate to
Preview
  2.  
  3. MISY 5325
  4.  
  5. MISY 5325

Exam (elaborations)

MISY 5325 Final 1-70 Questions and Answers New (2024/2025) Solved 100% Correct
 0 purchase
  • Course
  • MISY 5325
  • Institution
  • MISY 5325

1. 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 - ️️parameter square brackets [ ] 2. To delete a field from a table, open the table in ———- view, click the row selector for the field to be...

[Show more]

Preview 2 out of 5  pages

Document information

  • September 24, 2024
  • 5
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

Written for

  • MISY 5325
  • MISY 5325

Seller

avatar-seller
ACADEMICMATERIALS

Reviews received

Content preview

MISY 5325 Final 1-70
1. 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 - ✔️✔️parameter
square brackets [ ]

2. 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. - ✔️✔️Answer: Design

3. To create a crosstab, click the———— button on the CREATE tab. - ✔️✔️crosstab,
Query Wizard

4. 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 -
✔️✔️True

5. To create a multivalued field, create a ———— field being sure to check the Allow
Multiple Values check box. - ✔️✔️lookup

6. To create a multivalued field, create a(n) ———field being sure to check the Allow
Multiple Values check box. - ✔️✔️lookup

7. 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. - ✔️✔️Query
Design

8. To combine criteria with ———— place the criteria on the same row. - ✔️✔️AND

9. 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. - ✔️✔️More Forms

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. - ✔️✔️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. - ✔️✔️T

12. To create an update query, create a new query and then click the ———- button on
the DESIGN tab. - ✔️✔️Update

, 13. To define an additional field in Datasheet view, tap or click the ———- column
heading. - ✔️✔️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. - ✔️✔️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. - ✔️✔️Delete

16. To compact and repair a database, tap or click ———— button in the Info gallery in
the Backstage view. - ✔️✔️Compact & Repair


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. - ✔️✔️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 - ✔️✔️False

19. To delete a record, tap or click the record selector for the record, and then press the
key(s). - ✔️✔️DELETE

20. To display the Total row in a datasheet, click the Sum button on the ribbon. Torf -
✔️✔️False

21. To enter a number in a criterion, type the number without any dollar signs or
commas.t or f - ✔️✔️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. - ✔️✔️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. - ✔️✔️Advanced

24. To create a lookup field, select ————- from the menu of available data types. -
✔️✔️Lookup Wizard

25. To find duplicate records in a table, use the ———Query Wizard. - ✔️✔️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. - ✔️✔️MAX

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

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

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 ACADEMICMATERIALS. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $7.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$7.99
  • (0)
Add to cart
Added