Table 1-1

Question 3 using table 1-1

Info for Question 5

Question 5, also uses table 1-1

Relevant Reliable Complete Timely Understandable Verifiable Accessible Reduces uncertainty, improves decision making, or confirms or corrects prior expectations. Free from error or bias; accurately represents organization events or activities. Does not omit important aspects of the events or activities it measures. Provided in time for decision makers to make decisions. Presented in a useful and intelligible format. Two independent, knowledgeable people produce the same information. Available to users when they need it and in a format they can use. Required: Yes EMPCODE is the primary key of the employee table. Therefore, the Required attribute must be set to Yes. In other words, every employee record in the employee table must have an employee code. Your textbook describes on page 92 that primary keys cannot be null. This requirement is referred to as the entity integrity rule. Setting the Required attribute to yes provides an internal validation control within the database. When entering invoice data, Access will not allow you to go to the next record without entering a value for EMPCODE. This is logical, as an employee record without an EMPCODE would render the database almost useless for searching and sorting records. QUESTION #3 TO BE FORMALLY ANSWERED IN OUTPUT TURNED IN FOR DELIVERABLE #1: In your Word document, type "Response to Question #3:" and formally answer the following question: of the seven characteristics of information in Table 1-1 of the course textbook, identify the one that is most directly enhanced by requiring that every employee record in the table must have an employee code. Explain why. but that size specification would not allow for numbers to the right of the decimal point. Format: Percent Decimal Places: 2 Input mask: Leave blank for now. We will learn about this in a later section. Caption: Commission Rate Default Value: 0 to set the default value to zero so that if no value is entered, it will default to zero. Validation Rule: Assume the minimum commission rate for the company in this exercise is zero because middle managers sometimes make sales, but they receive no commission. The maximum commission rate is 25%. From the keyboard, enter >0 And