Experiencing MIS, 3e (Kroenke)
Chapter Extension 8: 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: 398
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 1
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: 399
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 1
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
…show more content…
A) SQL
B) MySQL
C) DB10
D) HTML
Answer: A
Page Ref: 409
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 4
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: 412
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 5
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: 412
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 5
True or False
1) Before using any DBMS, the creators should have created a data model from the users' requirements.
Answer: TRUE
Page Ref: 398
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 1
2) An underlined attribute is the primary key and an italicized attribute is a foreign key.
Answer: TRUE
Page Ref: 398
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 1
3) Access opens a new database by creating a default table named Table A.
Answer: FALSE
Page Ref: 399
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 1
4) In Access, to modify the design of a default table, one must click View and select Design View in the upper
The lab begins with a simple example of query development using Access; then, evolves to more complex queries which the student should perform after completing the first exercise. The student can create a query with the wizard, with query design view, or with SQL statements. The Northwind database will be used again in this lab.
e. explain how the research found in the database relates to your topic of interest. This may be an additional paragraph, perhaps two or three sentences.
1. Make an observation – Based on the data in Table 4, describe the relationship between dissolved oxygen content and fish populations in the body of water. Discuss the
Articles: Actual information in form of table, stored procedure or a view that will be replicated
Team A of DBM/405 has chosen to look at Microsoft Access. This paper will examine Microsoft Access and its capabilities and benefits. It should show that Microsoft Access is one of the easiest user friendly database and cost effective database applications today. This paper will also examine the use of Access for a business called Parrothead Productions. It is a small one-man operation, which is a remote disc jockey business.
Microsoft Access is a database engine and development environment in one package. It is typically workstation-based, and designed to be easy to use, even for users
Yuka exported the student data that she was maintaining in another computer system to a text file, and she asks you to add this data to the end of the Student table.
A meeting with the programme manager, database technologist and users at AOne+ is held to discuss possibilities and the new requirements. The aspiration is to re-develop the database increasing speed and efficiency with more functional capabilities in MSAccess 2007 optionally MSAccess 2013. The client endorsed that the database will be used by multiple users and could be shared with other areas of AOne+.
One of the most critically important aspects of using personal productivity applications including Microsoft Excel is understanding and appreciating their limitations. The development of collaborative tools and technologies that expand and extend the functionality of personal productivity applications is one of the fastest growing and most diverse areas of enterprise software today (Kennedy, Mighell, Kennedy, 2010). For Party Plates to
2. Click Current Database, and then in the Display Form list, select the form that you want to display when the database starts.
Different databases use different naming conventions. Naming conflicts occur due to the use of different names for the same attribute like
Microsoft Access provides many functions for end users. While working in IT Support, many different situations may present from customers phoning in and requesting information or assistance. Following are three different situations that may be presented at a support desk. First, we will examine a veterinarian who wants to use Microsoft® Access® for his business, and has some questions regarding the functions of Access. Second, a man created a database to inventory his customers’ past due accounts to ensure that he receives payment. Third, a user has been using a Microsoft® Access® database and queries to track her commemorative
The DBMS will execute some vital functions that will promise the reliability and consistency of the information in the database. The vast majority of those functions are transparent to end clients, and most can be attained just through the utilization of a DBMS. They incorporate information dictionary management, data storage management, data transformation and presentation, security management, multiuser access control, backup and recovery management, data integrity management, database access languages and application programming interfaces and database communication interfaces. The following is a diagram that will give you an idea regarding my implementation of the database.