BIS245 Chapter 1 Exam Bank Solution Manual (Rated 100%)
A database management system (DBMS) is a collection of programs that - Answers store data, manage
data, use collections of data. The answer is All of the above
Which database object would you use to find customers who are located in the same state? - Answers
Query
To create a filtered list on a particular field in a record - Answers click on the home tab, filter, selection,
and then pick your criteria
To locate the tool to compact an Access database, click on the - Answers database tools tab, and select
compact and repair database tools.
Which view best describes the image below? This is a picture from the Access program with the Home
tab selected. The file that is shown is the Employee Form with fields shown for First Name, Last Name,
Title, Reports to, Hire Date and Education along with a picture of the employee who's records are being
shown. On the lower tool bar, the numbers are 3 of 9. - Answers Form
To add, delete, and edit fields in a table, use which of the following? - Answers Design view of a table
When building a database, you should first - Answers determine the output and then design the tables
You should use Excel over Access when
a. you have a large amount of data
b. you need to group, sort, and total data based on various parameters.
c. you need multiple related tables to store data
d. none of the above - Answers d. none of the above
When running a query, it is important to
a. remember that the information can not be used for decision making
b. remember that the information can not be used in a report
c. evaluate the results for accuracy
d. return multiple text messages - Answers c. evaluate the results for accuracy
When constructing criteria for a query, you should use
a. no delimiters for number data types
b. quotes to enclose date/time data types
A database management system (DBMS) is a collection of programs that - Answers store data, manage
data, use collections of data. The answer is All of the above
Which database object would you use to find customers who are located in the same state? - Answers
Query
To create a filtered list on a particular field in a record - Answers click on the home tab, filter, selection,
and then pick your criteria
To locate the tool to compact an Access database, click on the - Answers database tools tab, and select
compact and repair database tools.
Which view best describes the image below? This is a picture from the Access program with the Home
tab selected. The file that is shown is the Employee Form with fields shown for First Name, Last Name,
Title, Reports to, Hire Date and Education along with a picture of the employee who's records are being
shown. On the lower tool bar, the numbers are 3 of 9. - Answers Form
To add, delete, and edit fields in a table, use which of the following? - Answers Design view of a table
When building a database, you should first - Answers determine the output and then design the tables
You should use Excel over Access when
a. you have a large amount of data
b. you need to group, sort, and total data based on various parameters.
c. you need multiple related tables to store data
d. none of the above - Answers d. none of the above
When running a query, it is important to
a. remember that the information can not be used for decision making
b. remember that the information can not be used in a report
c. evaluate the results for accuracy
d. return multiple text messages - Answers c. evaluate the results for accuracy
When constructing criteria for a query, you should use
a. no delimiters for number data types
b. quotes to enclose date/time data types
