These questions are pulled from my lab manual for MGMT 345 Computer Information

Question

These questions are pulled from my lab manual for MGMT 345 Computer Information Systems. It is to be completed using Microsoft Access.

1. A facility of Access mostly designed for use in decision making by managers is?
a. report
b. table
c. form
d. query
e. all of the above
f. none of the above

2. A facility of Access which is sometimes used for one time unique output for managers is?
a. report
b. table
c. form
d. query
e. all of the above
f. none of the above

3. A facility of Access which must be used before a report is produced is?
a. report designer
b. table designer
c. relationship designer
d. query wizard
e. all of the above
f. none of the above

4. What is a query?
a. it's a method for displaying data contained in one or more tables
b. it's the relationship between two Access tables
c. It's a method of joining two Access tables in a many-many relationship
d. It's the same as an Access table
e. All of the above
f. None of the above

5. An Access report is mainly used by what type of user?
a. clerical input users
b. clerical output users
c. management
d. office staff
e. all of the above
f. none of the above

6. Where do you find the Query Wizard?
a. on the create tab
b. On the report tab
c. On the database tools tab
d. On the external data tab
e. All of the above
f. None of the above

7. I want to create a query that lists students and the classes that they take. How many tables will I need?
a. One
b. Three
c. Four
d. Two
e. All of the above
f. None of the above

8. I need to add a student into the student table. How can I do this?
a. Use the form wizard
b. Use the query wizard
c. Use the students form
d. Use the report wizard
e. All of the above
f. None of the above

9. Now I want to create a report that says what instructors teach which classes. How many tables will I need?
a. One
b. Three
c. Four
d. Two
e. All of the above
f. None of the above

10. Now I want to create a report that lists all the classes possible. How many tables will I need?
a. One
b. Three
c. Four
d. Two
e. All of the above
f. None of the above

Explanation / Answer

1)a.report

2)d.query

3)a.report designer

4)e.all of the above

5)a. clerical input users

6)a.on the create tab

7)b. Three

8)Use the form wizard

9)d. Two

10)b. Three

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

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