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...
-
Gretta Company holds a debt investment at amortized cost of $ 8,500. At December 31, 2014, the fair value of the investment is $ 8,000 and the present value of the future cash flows from the debt...
-
Bob is a 50 percent owner of Barco Enterprises. During 2016, Barco earned $80,000 in net income after subtracting Bob's $50,000 salary. Bob also withdrew $20,000 from Barco during the year. Bob would...
-
Why is it important for an organization to have a high PMTQ? And, how can they maintain it?
-
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: (a) Develop a 3-year moving average to forecast registrations from year 4...
-
Understanding the internals of SQL Server and how it stores data is extremely important. This information is invaluable and helps DBAs, Engineers, and the organization plan for the future through...
-
Include a reflection to the client that discusses the tax recommendations and consequences of your newly chosen energy-friendly initiative. Specifically, you must address the following: Identify the...
-
The Allen Corp. acquired inventory on account. Allens current ratio and quick ratio are both greater than 1-to-1. Required : What will be the immediate effect of this purchase of inventory on Allens ...
-
Identify a scientific topic that interests you. This might be something that you want to learn more about or perhaps something that has always fascinated you. Summarize the topic in 13 sentences....
-
As you come to the end of the financial accounting modules, provide a reflection on your experience of studying towards your MPA so far. Content 1. You are expected to introduce your refection in the...
-
Calculate the present value of the following single payments: Present value formula : PV = FV/(1+ r ) n $10,000 received five years in the future given a discount rate of 4% $10,000/(1.04 $10,000...
-
Suppose there are two jobs in the economy: lawyers and fisherman. To be a lawyer, one must obtain a law degree. Firms set wages to equal the average productivity of those employed in the industry....
-
You work at a large grocery chain that prides itself on having food that is grown organically by farmers who earn a fair wage. Describe why you believe the concepts in a blockchain network could help...
-
During a week-long sale, a store reduced its prices on sale items by 10% each day. A coat that was priced $80 on the first day of the sale was sold on the fourth day. At what price was the coat sold?
-
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 ...
-
Discuss the approach you would take to building a system for playing Scrabble or another word game of the sort. What limitations does your system have? How likely do you think it is that your system...
-
Discuss the current state of the art of game-playing computer systems in relation to the following games: chess, checkers, Go, bridge, Othello, tic-tac-toe. What advances are likely in the near...
-
What problems did the developers of Chinook face? What new techniques did they add to simple Minimax with alpha-beta pruning? Would these techniques extend well to other games?
Study smarter with the SolutionInn App