Experiencing MIS 4Th Ed by David M. Kroenke – Test Bank

Experiencing MIS 4Th Ed by David M. Kroenke – Test Bank

Experiencing MIS, 4e (Kroenke)

Chapter Extension 5: Using Microsoft Access 2010

Multiple Choice 1) Before using a DBMS, the user should have created a(n) ________. A) data model B) database C) identifier D) attribute Answer: A Page Ref: 404 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 2) Which of the following is the first activity to be performed on starting Microsoft Access? A) creating a database B) assigning field names C) creating a primary ID D) creating a table Answer: A Page Ref: 404 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 3) Which of the following statements is true about naming a new database in Microsoft Access? A) A user must type the name of his new database in the blank provided under File Name. B) A user must select the name of his new database from the drop down list provided next to the File name. C) Access opens the new database with the default name, database 1. D) Access opens the new database with the default name, database A. Answer: A Page Ref: 405 Difficulty: Moderate AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 4) Access opens the new database by ________. A) creating a default table named Table A1 B) creating a default table named Table A C) creating a default table named Table 1 D) asking the user to name his/her table Answer: C Page Ref: 405 Difficulty: Moderate AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 5) In Microsoft Access, different attributes are referred to as ________. A) data B) keys C) entities D) fields Answer: D Page Ref: 405 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 6) In Microsoft Access, the description of fields is used to ________. A) document the details of each field B) define rules for how each field should behave C) define how the fields should behave in case of exceptions D) characterize the fields in terms of their data types Answer: A Page Ref: 406 Difficulty: Moderate AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 7) Relationships can be defined in Microsoft Access by selecting the ________ tab in the ribbon. A) Database Tools B) External Data C) Connections D) Add-ins Answer: A Page Ref: 410 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 2 Learning Outcome: Discuss best practices for using and managing databases 8) In Access, to create a relationship between two tables, users must ________. A) drag the primary key in one table to the foreign key in another table B) create a link between the foreign keys from both the tables C) drag the foreign key in one table to the primary key in another table D) create a link between the primary key in one table to the primary key in another table Answer: A Page Ref: 410 Difficulty: Moderate AACSB: Multicultural and Diversity Understanding Study Question: Study Question 2 Learning Outcome: Discuss best practices for using and managing databases 9) The step after creating a relationship between two tables is ________. A) to create macros B) to enter data C) to provide descriptions to each of the tables D) to create queries Answer: B Page Ref: 410 Difficulty: Moderate AACSB: Multicultural and Diversity Understanding Study Question: Study Question 2 Learning Outcome: Discuss best practices for using and managing databases 10) In Access, after creating a relationship between two tables, the user cannot and need not assign values for the ________. A) primary key B) tracker C) foreign key D) add-ons Answer: C Page Ref: 410 Difficulty: Moderate AACSB: Use of Information Technology Study Question: Study Question 2 Learning Outcome: Discuss best practices for using and managing databases 11) Which of the following is one of the alternatives for creating a data entry form? A) using the data definition tab B) using the query wizard C) using the property sheet D) using the default table display Answer: D Page Ref: 412 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 3 Learning Outcome: Discuss best practices for using and managing databases 12) Which of the following options in Microsoft Access can be used to make the data entry form more pleasing for the users? A) Form B) Tab Order C) Property Sheet D) Add-ins Answer: A Page Ref: 413 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 3 Learning Outcome: Discuss best practices for using and managing databases 13) In Access, records can be deleted by clicking the down arrow next to Delete and selecting Delete Record, which is present in the Records section of the ________ tab. A) Database Tools B) Home C) Fields D) File Answer: B Page Ref: 413 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 3 Learning Outcome: Discuss best practices for using and managing databases 14) All modern DBMS products can process the ________ query language. A) SQL B) MySQL C) DB10 D) HTML Answer: A Page Ref: 415 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 4 Learning Outcome: Discuss best practices for using and managing databases 15) To create a report with data from two or more tables, we must use the ________. A) Report Wizard B) Navigation tab C) Report Design D) Share Point lists Answer: A Page Ref: 418 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 5 Learning Outcome: Discuss best practices for using and managing databases 16) Which of the following tabs in Microsoft Access is used to generate reports? A) Create B) Data C) Tools D) Format Answer: A Page Ref: 418 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 5 Learning Outcome: Discuss best practices for using and managing databases True or False 1) Before using any DBMS, the user should have created a data model from the users’ requirements. Answer: TRUE Page Ref: 404 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 2) An underlined attribute is the primary key and an italicized attribute is a foreign key. Answer: TRUE Page Ref: 404 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 3) Access opens a new database by creating a default table named Table A. Answer: FALSE Page Ref: 405 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 4) In Access, to modify the design of a default table, one must click View and select Design View in the upper right-hand corner of the Access window. Answer: FALSE Page Ref: 405 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 5) Every field in Microsoft Access must have a description associated with it. Answer: FALSE Page Ref: 406 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 6) The description field in Microsoft Access is used mainly for documentation. Answer: TRUE Page Ref: 406 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 7) In Microsoft Access, a user has to define the relationships between fields before creating the tables. Answer: FALSE Page Ref: 406 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 2 Learning Outcome: Discuss best practices for using and managing databases 8) In Microsoft Access, relationships can be defined by selecting the Database Tools tab. Answer: TRUE Page Ref: 410 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 2 Learning Outcome: Discuss best practices for using and managing databases 9) In Microsoft Access, users must drag the foreign key in one table to the primary key in another table to enforce a relationship. Answer: FALSE Page Ref: 410 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 2 Learning Outcome: Discuss best practices for using and managing databases 10) Unlike Microsoft Excel, users cannot key in data to Microsoft Access cells. Answer: FALSE Page Ref: 410 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 3 Learning Outcome: Discuss best practices for using and managing databases 11) Microsoft Access provides a default table display for entering the data. Answer: TRUE Page Ref: 412 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 3 Learning Outcome: Discuss best practices for using and managing databases 12) In Microsoft Access, the option to generate a data entry form is present in the Create ribbon. Answer: TRUE Page Ref: 413 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 3 Learning Outcome: Discuss best practices for using and managing databases 13) Microsoft Access can be used to process the SQL query language. Answer: TRUE Page Ref: 415 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 4 Learning Outcome: Discuss best practices for using and managing databases 14) Microsoft Access can be used to create and process queries. However, it does not provide a graphical interface for the queries. Answer: FALSE Page Ref: 415 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 4 Learning Outcome: Discuss best practices for using and managing databases 15) To create a query, one must drag columns out of the required tables into the grid in the lower part of the query definition form. Answer: TRUE Page Ref: 416 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 4 Learning Outcome: Discuss best practices for using and managing databases 16) By default, for queries of two or more tables, Access shows only those rows that have value matches in both tables. Answer: TRUE Page Ref: 417 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 4 Learning Outcome: Discuss best practices for using and managing databases 17) To create a report with data from not more than two tables, we must use the Report Wizard. Answer: FALSE Page Ref: 418 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 5 Learning Outcome: Discuss best practices for using and managing databases 18) In Microsoft Access, a report is created using a process similar to that for forms. Answer: TRUE Page Ref: 418 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 5 Learning Outcome: Discuss best practices for using and managing databases 19) The option to create reports can be found in the Database Tools ribbon of Microsoft Access. Answer: FALSE Page Ref: 418 Difficulty: Easy AACSB: Use of Information Technology Study Question: Study Question 5 Learning Outcome: Discuss best practices for using and managing databases Essay 1) What steps must a database designer take before using a DBMS? Answer: Designers need to first create a data model from a list of the users’ requirements. Then, the data model must be transformed into a database design. Only at this point should tables be created in a DBMS. Page Ref: 404 Difficulty: Moderate AACSB: Multicultural and Diversity Understanding Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 2) Explain the procedure for creating a database using Microsoft Access. Answer: To create a new database, select Blank database under the Available Templates in the center of the opening screen. Then, type the name of the new database under File Name. Access will suggest a directory; change it if you want to use another one, and then click Create. Access opens the new database by creating a default table named Table1. Page Ref: 405 Difficulty: Moderate AACSB: Multicultural and Diversity Understanding Study Question: Study Question 1 Learning Outcome: Discuss best practices for using and managing databases 3) Explain the procedure for establishing a relationship between two tables in Microsoft Access. Answer: After creating the tables in Microsoft Access, the next step is to define relationships. This can be done by clicking the Database Tools tab in the ribbon and then clicking the Relationships icon near the left-hand side of that ribbon. The Relationships window will open and the Show Table dialog box will be displayed. Double-clicking on two table names will cause both tables to be added to the Relationships window. Close the Show Table dialog box. To create the relationship between these two tables, click on the primary key attribute in the first table and drag that attribute on top of the primary key in the second table. In the dialog box, click Enforce Referential Integrity, then Cascade Update Related Fields, and then Cascade Delete Related Records. Close the Relationships window and save the changes when requested to do so. You now have a database with two tables and a relationship. Page Ref: 410-412 Difficulty: Moderate AACSB: Use of Information Technology Study Question: Study Question 2 Learning Outcome: Discuss best practices for using and managing databases 4) Explain the different alternatives provided by Microsoft Access for creating data entry forms. Answer: Access provides several alternatives for creating a data entry form. The first is to use the default table display. The default table display provided by Microsoft Access can be used to enter the required data. This display, although convenient, is limited in its capability. It also does not provide a very pleasing user interface. For more generality and better design, users can use the Access form generator. The form generator can generate a data entry form that is more pleasing to view and easier to use than the default table. Page Ref: 412-414 Difficulty: Moderate AACSB: Use of Information Technology Study Question: Study Question 3 Learning Outcome: Discuss best practices for using and managing databases 5) How can a user generate reports in Microsoft Access? Answer: To create a report with data from two or more tables, users should use the Report Wizard. Click the Create tab, and then in the Reports section click Report Wizard. Page Ref: 418-421 Difficulty: Moderate AACSB: Use of Information Technology Study Question: Study Question 5 Learning Outcome: Discuss best practices for using and managing databases