Access Tutorial 2 Complete Exam Test.

Access Tutorial 2 Complete Exam Test. It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file. - CORRECT ANSWER delimited A database management system is a useful tool only if it meets which of the following criteria? - CORRECT ANSWER meets the needs of its users Relationship integrity is a set of rules used by Access to maintaain consistency between related tables when data in either table is updated. - CORRECT ANSWER False In order to define table relationships, each table being joined must contain a common field. - CORRECT ANSWER True When choosing field names, it is best to choose names that ____. - CORRECT ANSWER describe the content or purpose of the field A database system determines how to store, display, and process field values based on which of the following? - CORRECT ANSWER field properties Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables: · Participant Information · Parent Information · Employees · Activities After printing a report of parent information for camper pick-up monitors, Santana decides some of the field names displayed on the report are hard to read. For example, she prefers the field MotherMobilePhone to be displayed as Mother Cell on the report. Which field property should be changed to modify the field name display on the report? - CORRECT ANSWER Caption Which of the following is the most logical data type to use if a field will contain long comments or explanations? - CORRECT ANSWER Long Text Syed and Marino Li own a small furniture consignment shop in Atlanta, GA. Syed is designing a database that will allow them to keep track of item information and seller information. Each item is assigned to one seller; however, each seller may be assigned multiple items in the database. The database will contain the following information: item identification number, item description, seller code, condition of item, retail price of item, item quantity, date item received, condition of item, date the item is sold, the final sale price of the item, seller name, seller address, and seller contact information. Using appropriate database design guidelines, answer the following questions.