IS 201 - Access Project Part Three The goal of this part of the project is to create a final database that includes:
IS 201 â€“ Access Project Part Three
The goal of this part of the project is to create a final database that includes: (1) a database structure with
related tables that are populated with data that you can use for testing; (2) forms suitable for casual
computer users to add, change, and delete data; (3) queries that can be used by forms and reports to
provide information; and (4) forms and reports to display information from tables and queries in a format
suitable for casual computer users.
Some of the requirements for this part of the project require that you have a working database and queries
developed in parts one and two of the project. If you were not able to get everything to work correctly in
Part 2 of the project, I recommend that you read the requirements for this part and fix anything in your
database that you will need.
I will not provide a database with the required queries from Part 2
check out the requirements in this document and see what queries you need to have working correctly.
This part of the project will be evaluated both on the content and the format of the forms and reports you
create. The forms you create can be ugly, pretty, simple, complex, easy-to-use, hard-to-use, etc. but your
grade will reflect the amount of time and effort you put into creating visually appealing easy-to-use
forms and reports. Take this opportunity to learn how to incorporate the concepts of effective
information visualization that we have discussed in class into your business application.
I recommend that you choose a style (color, formatting, etc.) and stick with that style for all your forms
and reports. Feel free to use a pre-defined theme in Access. The screens and reports should include a
picture logo (find something appropriate from a free image that you find on the web), a meaningful title,
and use a consistent look-and-feel. Consistency is important - you are creating these forms and reports
for one company so all the forms and reports should have the same look-and-feel.
Upon completion upload your database named in the format LastNameFirstInitialAccessProj3.accdb to
frm1: Create a form that allows a user to add, delete, change and view data in the database about
a customer. Make use of record navigation and operation buttons as reviewed in the lab.
Include a combo box to navigate to a specific customer. Name this form â€œfrm1â€.
frm2: Create a form that allows a user to add, delete, change and view data in the database
about a training event.
This form should allow a user to enter training events by customer, rather than
simply adding individual training events. The customer data should be in the main form, while the data
for training events for that customer should be in a subform. Make use of record navigation and
operation buttons you believe are appropriate and helpful for the form. Include totals in the main form
to provide some information about the training events for that customer â€“ choose which totals you
believe are relevant for your business application. Name this form â€œfrm2â€.
An idea of the overall look of this form is shown on the next, but do NOT duplicate this form because it is
not especially great - just use it as a guideline to understand the content of the form. The sample below
does not show any buttons â€“ you should include navigation and/or operation buttons on your form.
This question was answered on: Jan 02, 2020Buy this answer for only: $15
This attachment is locked
Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
About this QuestionSTATUS
Jan 02, 2020EXPERT
YES, THIS IS LEGAL
We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.
You can also use these solutions:
- As a reference for in-depth understanding of the subject.
- As a source of ideas / reasoning for your own research (if properly referenced)
- For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
NEW ASSIGNMENT HELP?
Order New Solution. Quick Turnaround
Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.
WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.