Background This week, the IT team is working on user interface design for the new C3...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Background This week, the IT team is working on user interface design for the new C3 system. One goal is to reduce input errors by using validation rules and input masks. The team leader has assigned you to do research and develop a recommendation. To perform these tasks, you must navigate to the Microsoft Access Help area, where you will see examples of validation rules and input masks. Based on requirements modeling, you know that the new C3 system will store personal data about customers, their buying habits, and their interests. To reduce errors, the C3 user interface will use various input masks. Here are five sample data items, with descriptions and examples: Data Item Description Examples First Name Must start with a capital letter followed by at least one, and up to nine more lowercase letters. Li Stephanie Middle Initial May have up to one capital letter, or none. Must start with a capital letter followed by at least one, and up to 11 more lowercase letters. Last Name Steinbrenner Но Must start with two capi- tal letters followed by two digits. Category AB12 XY01 Postal Code Must have five digits, and may be followed by a hy- phen and four more digits. In addition to input masks, the team leader wants you to learn about validation rules. Specifically, she wants you to go back to the Microsoft Access Help area and review the 12345 12345-9999 explanation of validation rules and the examples. Practice Tasks Task 1. Create an input mask for each data item shown in the table. Task 2. Develop a brief handout that explains the concept of validation rules. Include an example of a validation rules that will only accept the letters A or B. Challenge Tasks After you complete the Practice Tasks, you learn about new developments at Game Technology. Now that you are familiar with input masks and validation rules, your team leader wants you to review two more data items. Customer ID Must include the first capital letter of the customer's R0118 last name, followed by the last four digits of the customer's Social Security Number. Must include at least six, and no more than 12 letters 1X2y3Z or digits. B1234 Password 123456789999 Task 1. Create input masks for the two additional items in the table. Task 2. Create a validation rule that will only accept numbers greater than 10 and less than 20. Background This week, the IT team is working on user interface design for the new C3 system. One goal is to reduce input errors by using validation rules and input masks. The team leader has assigned you to do research and develop a recommendation. To perform these tasks, you must navigate to the Microsoft Access Help area, where you will see examples of validation rules and input masks. Based on requirements modeling, you know that the new C3 system will store personal data about customers, their buying habits, and their interests. To reduce errors, the C3 user interface will use various input masks. Here are five sample data items, with descriptions and examples: Data Item Description Examples First Name Must start with a capital letter followed by at least one, and up to nine more lowercase letters. Li Stephanie Middle Initial May have up to one capital letter, or none. Must start with a capital letter followed by at least one, and up to 11 more lowercase letters. Last Name Steinbrenner Но Must start with two capi- tal letters followed by two digits. Category AB12 XY01 Postal Code Must have five digits, and may be followed by a hy- phen and four more digits. In addition to input masks, the team leader wants you to learn about validation rules. Specifically, she wants you to go back to the Microsoft Access Help area and review the 12345 12345-9999 explanation of validation rules and the examples. Practice Tasks Task 1. Create an input mask for each data item shown in the table. Task 2. Develop a brief handout that explains the concept of validation rules. Include an example of a validation rules that will only accept the letters A or B. Challenge Tasks After you complete the Practice Tasks, you learn about new developments at Game Technology. Now that you are familiar with input masks and validation rules, your team leader wants you to review two more data items. Customer ID Must include the first capital letter of the customer's R0118 last name, followed by the last four digits of the customer's Social Security Number. Must include at least six, and no more than 12 letters 1X2y3Z or digits. B1234 Password 123456789999 Task 1. Create input masks for the two additional items in the table. Task 2. Create a validation rule that will only accept numbers greater than 10 and less than 20.
Expert Answer:
Answer rating: 100% (QA)
Practice task Data item input mask First name L last name L LLO0 Postal code 000009999 HANDOUT VALID... View the full answer
Related Book For
Basic Marketing Research
ISBN: 978-1133188544
8th edition
Authors: Tom J. Brown, Tracy A. Suter, Gilbert A. Churchill
Posted Date:
Students also viewed these accounting questions
-
Design an inferior user interface design for its intended purpose. Retail and Shopping: Walmart, Amazon Sample the action prompts below to perform on each of the websites provided above: Find...
-
A research team is working on an important project that was implemented using personal interviews. The team has decided to use double-entry to identify and eliminate blunders. The following are data...
-
The goal of a team leader is to develop a productive team. Their goal is to identify and develop members who want to participate, to share ideas freely, and who know what they need to accomplish....
-
According to the American Red Cross, 11.6% of all Connecticut residents have Type B blood. A random sample of 28 Connecticut residents is taken. X = the number of Connecticut residents that have Type...
-
Discuss the probable justification for each of the following provisions of the tax law. a. A tax credit allowed for electricity produced from renewable sources. b. A tax credit allowed for the...
-
Carry out a full decision analysis for Classical Reproductions Ltd, using the following information: Calculation of expected profit with perfect information Prior probabilities for the various events...
-
Which of the following factors is most likely to cause the differences that separate Mexican accounting from the more traditional European systems? a. Tax rates b. Education level c. Language d....
-
What are the major factors considered in determining what depreciation method to use?
-
The following is a partial trial balance for the Green Star Corporation as of December 31, 2021: Account Title Debits Sales revenue Credits 1,500,000 Interest revenue 37,000 Gain on sale of...
-
Determine the force in members GF, CF, and CD of the roof truss and indicate if the members are in tension or compression. 1.5 kN 1.70 m 2 kN 1.5 m 0,8 m G. -1 m- 2 m 2 m
-
Supplies for Headboard Wood: live edge walnut slab Conditioning oil: nonfood grade Wax: nonfood grade Sandpaper for current sanders Sandpaper for drum sander Utilities Cost One of a lot of 15 that...
-
Explain the doctrine of the corporate separation of powers, and provide two examples of exclusive powers.Support your answer with the law; and provide a real or hypothetical example.
-
What role do intrusion detection and prevention systems (IDS/IPS) play in safeguarding against network attacks and anomalous behavior, and how do they leverage techniques such as signature-based...
-
1. Give a definition of law. Explain in not less than 30 words. 2. Explain in your own words at least 3 categories of people/institutions that can make laws. 3. Explain what is a constitution. (a)...
-
You are valuing ChickenCousins, a chain of fast food restaurants focusing on processed chicken dishes. You assume the following forecasts of items in the free cash flows of ChickenCousins: Year 1...
-
Think about an event or work experience, where you were satisfied or unsatisfied (or committed or not committed) in the workplace. What led you to your feelings of satisfaction and commitment, or...
-
QUESTION 4: (20 marks) CLO 4 Joan and Jake are in partnership trading as Jamaica Jolly. On January 1, 2014 the following information was extracted from the partnership's books: Details Current...
-
Linda Lopez opened a beauty studio, Lindas Salon, on January 2, 2011. The salon also sells beauty supplies. In January 2012, Lopez realized she had never filed any tax reports for her business and...
-
You are the assistant director of political research for the ABC television network, and two candidates, Joseph Thomas and Ann Martin, are running for president of the United States. You need to...
-
Friendship is a national manufacturer and distributor of greeting cards. The company has recently begun distributing a low-priced line of cards using a lower-grade paper. Quality differences between...
-
Identify the level of measurement (nominal, ordinal, interval, ratio) used in each of the following questions. Justify your answer. a. During which season of the year were you born? Winter Spring ...
-
What is the Euro Areas total for Groups A through C? Use the following balance of payments data for the Euro Area from the IMF to answer this problem. Assumptions (billion US$) 2000 2001 2002 2003...
-
What is the Euro Areas total for Groups A through D? Use the following balance of payments data for the Euro Area from the IMF to answer this problem. Assumptions (billion US$) 2000 2001 2002 2003...
-
Trade Deficits and J-Curve Adjustment Paths. Assume that the United Arab Emirates has the following import/ export volumes and prices. It undertakes a major devaluation of the UAE Dirham (AED) by 6%...
Study smarter with the SolutionInn App