ACC 3300- Access Assignment
Table: Customer, field name customer phone number.
I placed a validation rule and a text rule where the area code of a customer’s telephone number can only contain 303 or 720. I did because I felt that the company was too small and did not have the resources to ship baskets outside Colorado. If the company should grow and expand and if revenue increases, the validation rule will no longer exist.

Table: Custom Gift Basket Order/ Design, field name order date.
One of the controls that I placed in this field was that the date needed to be entered in the system a specific way. I placed an input mask of the format for the date that I wanted the system to recognize. The format for the date is 99/99/0000, once a date is added to Access; Access will then rewrite it and display it in a written format of the date and the month. An example will look something like this 04/16/2013 will equal out to be Wednesday, April 16, 2013.

Table: Customer, field customer name, customer address.

Another control added to these fields is that a limit was placed on how many characters a field would contain; instead of having the limit that Access provides which are 255 characters in a field. I thought was too much and decided to shorten the length requirement. In the fields the customers name can only contain 12 characters and customers address is only limited to 50 characters. Basic information is needed from the customers; the company doesn’t need any explanations in which it would require a 255 character limit.

Forms: Both Forms
Both forms contain a combo box; the first form is designed for an employee to pull up all records just by selecting down on a customer’s name. Everything can be viewed, how much a customer ordered, who is designing the order, customer’s personal information and so on. The second form has a combo box that is designed to see which designer is assigned to which sales number. Both combo boxes are located on the top right.