Question 1. 1. (TCO 5) To edit a form, use (Points : 5) Datasheet view. Design v

Question

Question 1.1. (TCO 5) To edit a form, use (Points : 5)        Datasheet view.
       Design view.
       Layout view.
       Layout view or Design view. Question 2.2. (TCO 5) Which database property type increases the efficiency of a search on the designated field in the physical database? (Points : 5)        Validation rule
       Validation text
       Indexed
       Expression Question 3.3. (TCO 6) Queries are objects in a database based on one or more underlying (Points : 5)        forms.
       modules.
       tables.
       macros. Question 4.4. (TCO 6) Which of the following expressions is NOT correct? (Points : 5)        Cost: [Price] * [Qty]
       DiscountAmt = [Price] * [Qty] * [Discount]
       PrPerSqFt: [SalePr] / [SqFt]
       Sales: [GP] * [Qty] Question 5.5. (TCO 9) First normal form can be identified by (Points : 5)        a row of a table holds data that pertains to one and only one instance.
       all the entries in a column must be the same data.
       the order of rows does not matter.
       All of the above Question 6.6. (TCO 2) A validation rule (Points : 5)        can prohibit values from being entered that may not meet a
criterion.
       compares a field to a table.
       is an error message that appears when a value is incorrectly
entered into a field.
       makes a value entered into a field appear in a particular
format. Question 7.7. (TCO 8) The _____ interface displays a menu that provides the ability to open the various objects within the database, and to move easily from one object to another. (Points : 5)        form
       utility
       switchboard
       object Question 8.8. (TCO 9) To secure an Access database, all of the following should be done EXCEPT (Points : 5)        digitally sign a database and open it in a trusted location.
       require a password to open a database.
       run the Table Analyzing Wizard and Performance Analyzer.
       save a database with the .accde file extension. Question 9.9. (TCO 9) A digital signature (Points : 5)        helps ensure that a file has not been tampered with and will be safe to open.
       is used with database files exclusively.
       is a tracking system of a file.
       must be obtained from a certification authority, such as VeriSign. Question 10.10. (TCO 10) The ACCDT file format type refers to a(n) (Points : 5)        database.
       digitally signed database.
       executable database.
       template. Question 11.11. (TCO 4) Which database property type increases the efficiency of a search on the designated field in the physical database? (Points : 5)        Validation rule
       Validation text
       Indexed
       Expression Question 1.1. (TCO 5) To edit a form, use (Points : 5)        Datasheet view.
       Design view.
       Layout view.
       Layout view or Design view.

Explanation / Answer

Layout view and Design view are the two views in which you can make design changes to forms. But Design view gives a more detailed view of the structure of the form. One can see the Header, Detail, and Footer sections for the form.

2.2 Validation rule.

Validation rule improve the quality of your data using validation rules.

3.3 tables

Queries are objects in a database based on one or more tables.

4.4 PrPerSqFt: [SalePr] / [SqFt)

                    Price per square foot = total cost of the house/ the number of square feet                and you have the total cost per square foot.

5.5 A row of a table holds data that pertains to one and only one instance.

A relation is in first normal form if every attribute in every row can contain only one single (atomic) value.

            6.6 Validation rules verify that the data a user enters in a record meets the standards you specify before    the user can save the record

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.