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...
-
The following data represent baseball batting averages for a random sample of National League players near the end of the baseball season. The data are from the baseball statistics section of the...
-
In Year 1, Utica Machinery Company uses the asset from RE11-4 for 7,500 hours. All of these hours are capitalized to an inventory account. Prepare the journal entry to record the depreciation. In...
-
Extreme Machine manufactures machines and parts for various industries; they have an office in Youngstown, Ohio. Avery Dennison manufactures and sells labels from a plant in Mentor, Ohio. They use...
-
Up. Up and Away is a producer of kites and wind socks. Relevant data on a bottleneck operation in the shop for the upcoming fiscal year are given In the following table: The shop works two shifts per...
-
Based on the Lease Obligations by Year visualization, do the results make sense? Select answer from the options below No. There is a decreasing trend in finance lease and operating lease obligations,...
-
Given a directed graph G = (V, E), explain how to create another graph G = (V, E) such that (a) G has the same strongly connected components as G, (b) G has the same component graph as G, and (c) E...
-
Brannon Company manufactures ceiling fans and uses an activity-based costing system. Each ceiling fan consists of 20 separate parts. The direct material cost is $95 and each ceiling fan requires 2.5...
-
What are the critical factors for ensuring successful implementation of business process reengineering in complex organizations?
-
Calculate the maximum traffic volume for the design lane (Directional Design hourly volume per lane: DDHV per lane) of Highway route no. 410, Ban Hua Taphan - Than-To section, which is a two-lane...
-
What is a good strategy for achieving and maintaining a healthy body weight?
-
According to "Are You Solving the Right Problem?", what is a common mistake in problem-solving?
-
The transactions in ABC Nation last year were: arked out of 5.00 Item Dollars Wages paid to labour Consumption expenditure 425,000 Net taxes 210,000 Profits 230,000 240,000 Investment Government...
-
7. PP & Co., a partnership engaged in the practice of accounting, had a gross income of 220,000 and expenses of 85,000 during the year 2020: Share in P/L ration Income from other business Expenses...
-
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 ...
-
Explore whether the original Bell inequality can be violated at large angles as well.
-
Consider an EPR state \(|\phiangle_{A B}\); Alice measures the spin on \(z\), then Bob measures it on \(x\), and then Alice measures it again on \(z\). Classify the possible answers for the second...
-
In quantum cosmology, one can define a "wave function of the Universe" \(\Psi[a(t)]\), whose variable is the expanding scale factor of the Universe, \(a(t)\), and which satisfies a general relativity...
Study smarter with the SolutionInn App