Exam 3: Building a Database and Defining Table Relationships

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

What is the maximum character length of a field name?

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut . _________________________

The way field values are stored, displayed, and processed in an Access database is determined by the ____________________.

In the accompanying figure, the default value property for the State field is "CT". _________________________

Which data type allows both positive and negative numbers as field values?

By choosing the Definition Only option in the Import Objects dialog box, the ____ of a table is imported, but not the ____.

Case-Based Critical Thinking Questions Case 2-3 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. Based on the information to be included in the database, which of the following possible field names would be the best common field to include in two or more tables?

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

All fields in a database should be contained in one table.

Field value maximum storage size is defined by the Field Size property for the data types including Short Text, Number, and ____________________ only.

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

Access automatically assigns the Number data type to all new fields.

Case-Based Critical Thinking Questions Case 2-2 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 Each parks and recreation employee must keep a copy of parent contact information for all campers with them at all times.  Using the figure above, which two tables must have a relationship established to allow Leah to print a report of all campers and the their parents' contact information?

Changing the order of fields in a database table is an example of changing a table's ____.