Chat with us, powered by LiveChat To complete the project, you will submit the final version of your - EssayAbode

01 Dec To complete the project, you will submit the final version of your

Posted at 11:15h in computer science by

 To complete the project, you will submit the final version of your database. Before you begin work on your database, make sure to review your instructor’s feedback on the original Client Request Worksheet, making any necessary changes. Once your Client Request is finalized, review the CIS 225 Project Guidelines and begin constructing your database. Note: This part of the project takes a lot of planning and attention to detail.

Look at guidelines and make a 2019 access database following the guidelines.

CIS 225 Project Guidelines

Based on your Client Request Worksheet, create an Access database that follows the guidelines listed for each of the following areas.

Database Table Design

Create your database tables using the methods that were discussed over the course of this semester. Remember, Access is a Relational Database Managements System, make sure to create valid relationships between tables, each containing the necessary primary and foreign keys. Design your database to the Third Normal Form. Consider all the field properties while designing your database tables.

Data Entry

Create all the necessary forms and sub-forms to allow a user to enter new customer and/or product information. Be sure to implement all the necessary data validation features to reduce errors and ensure high quality data is being entered into the database. Be sure to design forms that are appealing to the eye and not the default form layout provided in Access.

Custom Queries and Reports

Your Client Request outlines three custom reports and queries that are necessary for the company to operate efficiently. When creating these reports, do not use the default report designs. Customize them and make them look appealing to the user.

Switchboard

Once you have created your database and are able to enter all the necessary data and run reports and queries, create a switchboard to make it easy for any user to quickly navigate to necessary functions and reports.

,

first_name last_name address city county state zip phone email Toppings Visits a Year Rating
James Butt 6649 N Blue Gum St New Orleans Orleans LA 70116 504-621-8927 [email protected] 1 40 5
Josephine Darakjy 4 B Blue Ridge Blvd Brighton Livingston MI 48116 810-292-9388 [email protected] 1 25 5
Art Venere 8 W Cerritos Ave #54 Bridgeport Gloucester NJ 8014 856-636-8749 [email protected] 1 74 5
Lenna Paprocki 639 Main St Anchorage Anchorage AK 99501 907-385-4412 [email protected] 2 4 5
Donette Foller 34 Center St Hamilton Butler OH 45011 513-570-1893 [email protected] 2 52 4
Simona Morasca 3 Mcauley Dr Ashland Ashland OH 44805 419-503-2484 [email protected] 2 15 4
Mitsue Tollner 7 Eads St Chicago Cook IL 60632 773-573-6914 [email protected] 3 14 4
Leota Dilliard 7 W Jackson Blvd San Jose Santa Clara CA 95111 408-752-3500 [email protected] 3 45 2
Sage Wieser 5 Boston Ave #88 Sioux Falls Minnehaha SD 57105 605-414-2147 [email protected] 3 74 2
Kris Marrier 228 Runamuck Pl #2808 Baltimore Baltimore City MD 21224 410-655-8723 [email protected] 1 2 1
Minna Amigon 2371 Jerrold Ave Kulpsville Montgomery PA 19443 215-874-1229 [email protected] 1 23 5
Abel Maclead 37275 St Rt 17m M Middle Island Suffolk NY 11953 631-335-3414 [email protected] 1 1 5
Kiley Caldarera 25 E 75th St #69 Los Angeles Los Angeles CA 90034 310-498-5651 [email protected] 2 7 5
Graciela Ruta 98 Connecticut Ave Nw Chagrin Falls Geauga OH 44023 440-780-8425 [email protected] 2 75 5
Cammy Albares 56 E Morehead St Laredo Webb TX 78045 956-537-6195 [email protected] 2 5 4
Mattie Poquette 73 State Road 434 E Phoenix Maricopa AZ 85013 602-277-4385 [email protected] 3 5 4
Meaghan Garufi 69734 E Carrillo St Mc Minnville Warren TN 37110 931-313-9635 [email protected] 3 6 4
Gladys Rim 322 New Horizon Blvd Milwaukee Milwaukee WI 53207 414-661-9598 [email protected] 3 52 4
Yuki Whobrey 1 State Route 27 Taylor Wayne MI 48180 313-288-7937 [email protected] 1 4 4
Fletcher Flosi 394 Manchester Blvd Rockford Winnebago IL 61109 815-828-2147 [email protected] 1 4 4
Bette Nicka 6 S 33rd St Aston Delaware PA 19014 610-545-3615 [email protected] 1 78 4
Veronika Inouye 6 Greenleaf Ave San Jose Santa Clara CA 95111 408-540-1785 [email protected] 2 5 4
Willard Kolmetz 618 W Yakima Ave Irving Dallas TX 75062 972-303-9197 [email protected] 2 20 5
Maryann Royster 74 S Westgate St Albany Albany NY 12204 518-966-7987 [email protected] 2 25 5
Alisha Slusarski 3273 State St Middlesex Middlesex NJ 8846 732-658-3154 [email protected] 3 62 5
Allene Iturbide 1 Central Ave Stevens Point Portage WI 54481 715-662-6764 [email protected] 3 50 5
Chanel Caudy 86 Nw 66th St #8673 Shawnee Johnson KS 66218 913-388-2079 [email protected] 3 10 3
Ezekiel Chui 2 Cedar Ave #84 Easton Talbot MD 21601 410-669-1642 [email protected] 1 12 3
Willow Kusko 90991 Thorburn Ave New York New York NY 10011 212-582-4976 [email protected] 1 45 3
Bernardo Figeroa 386 9th Ave N Conroe Montgomery TX 77301 936-336-3951 [email protected] 1 23 2
Ammie Corrio 74874 Atlantic Ave Columbus Franklin OH 43215 614-801-9788 [email protected] 2 12 5
Francine Vocelka 366 South Dr Las Cruces Dona Ana NM 88011 505-977-3911 [email protected] 2 45 5
Ernie Stenseth 45 E Liberty St Ridgefield Park Bergen NJ 7660 201-709-6245 [email protected] 2 12 5
Albina Glick 4 Ralph Ct Dunellen Middlesex NJ 8812 732-924-7882 [email protected] 3 42 5
Alishia Sergi 2742 Distribution Way New York New York NY 10025 212-860-1579 [email protected] 3 42 5
Solange Shinko 426 Wolf St Metairie Jefferson LA 70002 504-979-9175 [email protected] 3 52 5
Jose Stockham 128 Bransten Rd New York New York NY 10011 212-675-8570 [email protected] 1 63 5
Rozella Ostrosky 17 Morena Blvd Camarillo Ventura CA 93012 805-832-6163 [email protected] 1 82 5
Valentine Gillian 775 W 17th St San Antonio Bexar TX 78204 210-812-9597 [email protected] 1 75 5
Kati Rulapaugh 6980 Dorsett Rd Abilene Dickinson KS 67410 785-463-7829 [email protected] 2 99 4
Youlanda Schemmer 2881 Lewis Rd Prineville Crook OR 97754 541-548-8197 [email protected] 2 75 4
Dyan Oldroyd 7219 Woodfield Rd Overland Park Johnson KS 66204 913-413-4604 [email protected] 2 25 4
Roxane Campain 1048 Main St Fairbanks Fairbanks North Star AK 99708 907-231-4722 [email protected] 3 74 4
Lavera Perin 678 3rd Ave Miami Miami-Dade FL 33196 305-606-7291 [email protected] 3 36 4
Erick Ferencz 20 S Babcock St Fairbanks Fairbanks North Star AK 99712 907-741-1044 [email protected] 3 45 4
Fatima Saylors 2 Lighthouse Ave Hopkins Hennepin MN 55343 952-768-2416 [email protected] 1 75 4
Jina Briddick 38938 Park Blvd Boston Suffolk MA 2128 617-399-5124 [email protected] 1 39 4
Kanisha Waycott 5 Tomahawk Dr Los Angeles Los Angeles CA 90006 323-453-2780 [email protected] 1 42 5
Emerson Bowley 762 S Main St Madison Dane WI 53711 608-336-7444 [email protected] 2 42 5
Blair Malet 209 Decker Dr Philadelphia Philadelphia PA 19132 215-907-9111 [email protected] 2 75 5

Related Tags

Academic APA Assignment Business Capstone College Conclusion Course Day Discussion Double Spaced Essay English Finance General Graduate History Information Justify Literature Management Market Masters Math Minimum MLA Nursing Organizational Outline Pages Paper Presentation Questions Questionnaire Reference Response Response School Subject Slides Sources Student Support Times New Roman Title Topics Word Write Writing