Question

16) What does Access do to denote action queries differently in the Navigation pane? A) It displays them in bold text. B) It displays them in a larger typeface. C) It displays them in a section called Action queries. D) It displays them using specific icons. 17) Which of the following is not a rule for using an Append query? A) Data types in both tables much match (with some exceptions). B) There must be the same number of fields in both tables. C) The destination table should not have an AutoNumber field. D) All the normal rules for adding a new record to the destination table still apply. 18) Which query would you use to show the sales by region for each of four quarters? A) Find duplicates B) Summary C) Crosstab D) Find unmatched 19) To make sure that a user can only pick from an item on the list in a Combo Box, what property must be enabled? A) Restrict to Menu B) Limit to List C) Limit to Menu D) Restrict to List 20) Which of the following is not true about making a table the source data for a Combo Box? A) The user can be forced to choose from only those records in the table. B) The data is then in an easy-to-edit location. C) New records can be added or existing records deleted very easily. D) It is quicker for Access to index the data,

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
16) What does Access do to denote action queries differently in the Navigation pane? A) It...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Microsoft Access 0 database name should be the broad name of what will be inside it....

    Microsoft Access 0 database name should be the broad name of what will be inside it. If I were creating a database on the history of the Pittsburgh Steeler Coaches I would call mine SteelerCoaches.accdb, for example. A. Design one table with at least a. 6 Fields (can have more, but not more than 10) b. Correct datatypes for your fields c. Property changes appropriate to the fields. Have all Field names with more than one word have no spaces...

  • If the focus in a form moves from left to right and you want the focus...

    If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____. . a. . sort order . b. . tab order . c. . form layout . d. . focus grouping    What do you change when you drag the right border of a form in Form Design view? . a. . the layout of the form . b. . the width of the form ....

  • 1. You typically increase the decimal places from 1 to 2 for a(n) _____ field. A....

    1. You typically increase the decimal places from 1 to 2 for a(n) _____ field. A. Currency B. AutoNumber C. Long Text D. Money 2. What button do you use on the Query Tools Design tab to add a field list to a query? A. Field List button B. Show Table button C. View button D. Table Names button 3. _____ view provides the most options for defining fields. A. Field Create B. Field Define C. Table Create D. Table...

  • You are given a database in a MS Access file called ‘DBP-e14-Cape-Codd’ that contains data collected...

    You are given a database in a MS Access file called ‘DBP-e14-Cape-Codd’ that contains data collected in an outdoor sports retail store. The retail store hired you as a data analyst to answer questions in order to help them make business decisions that will help them grow. Write the SQL statement for each query and save them in MS Access as Q1, Q2,… Please submit the MS Access and MS Word to help speed the grading turnout! in Blackboard. (to...

  • erms Matching Match the key terms with their definitions. Write the key term letter by the...

    erms Matching Match the key terms with their definitions. Write the key term letter by the appropriate numbered definition k. Foreign key 1. Multitable query m. Nul a. AND condition b. Auto Number c. Caption property d. Cascade Delete Related Records e. Cascade Update Related fields f. Comparison Operator 8. Criteria row h. Data redundancy i. Data type 1. Field property o. OR condition p. Query q. Referential Integrity r. Simple Query Wizard 5. Wildcard Special character that can represent...

  • You will develop an E-Commerce database used to maintain customers, products and sales information. You are...

    You will develop an E-Commerce database used to maintain customers, products and sales information. You are required to 1) gather and analyze requirements 2) design logical structure of the database 3) create stored procedures to develop the tables and insert the data 4) write SQL statements for data extraction and reporting. Throughout the course of this semester you have analyzed the requirements for an eCommerce database, designed and developed your database. As a class we have gone through the process...

  • Hospital Patient Reglstration System Hospltal Patient Registration System Part 2: Relational Sche...

    Hospital Patient Reglstration System Hospltal Patient Registration System Part 2: Relational Schema: Description of Tables 1) 2) Patient Table: Contains detail information about patients. Patient Address: Contains list of patients addresses. Each Patient can have more than one Address. However, an address can belong to only one patient. DOD DATETM 3) Provider Table: Contains detail information about Service Provider's, 4) Provider Address: Contains list of provider's addresses. 5) Provider Department: Contains information about which provider are in which department. Provider...

  • Access 2016 Quiz 1) What view normally appears when you double-click a table? (1 point) a.Datasheet...

    Access 2016 Quiz 1) What view normally appears when you double-click a table? (1 point) a.Datasheet view b.Form view c.Design view d.Layout view 2) What type of filter displays records based on a criterion you choose? (1 point) a.Exact Match filter b.Selection filter c.Toggle filter d.Filter by Report 3) Which of the following is not a valid criteria in a filter? (1 point) a. Is Null b. =>14 c. ="Fred" d. <>125 4) To view or modify a table's structure...

  • Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database,...

    Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database, the first question users should ask themselves is O A. How much information is going to be stored in this database? B. Where should this database be stored? O C. Who is going to use this database? O D. What questions should this database be able to answer? Question 2 of 38 When linking two tables in a relational database, a user will use...

  • 484 Core Concepts of Accounting Information Systems a. Using Access, create an employee table sim- ilar...

    484 Core Concepts of Accounting Information Systems a. Using Access, create an employee table sim- ilar to the one shown in Figure 15-4. Create created. (Hint You can use the aforemen- tioned expression for the department code as a validation rule.) at least one record for this table b. Create validation rules for the listed restric tions and an accompanying validation text for each. Document your work by provid- ing a table outlining exactly what rules you c. Test each...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT