BIS245 Chapter 1 Exam Bank Solution Manual (Rated 100%)
4 views 0 purchase
Course
BIS245 Chapter 1
Institution
BIS245 Chapter 1
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...
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller TutorJosh. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.