"> (Answered) IS 201 - Access Project Part Three The goal of this part of the project is to create a final database that includes: - Tutorials Prime

Question Details

(Answered) 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:


It is MS access assginment. Please read all the instructions!2

 

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

 

, so

 

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

 

WebCampus.

 

Forms

 

1)

 

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”.

 

2)

 

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.

 


Solution details:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Jan 02, 2020

EXPERT

Tutor

ANSWER RATING

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).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

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.

Order Now
WP2Social Auto Publish Powered By : XYZScripts.com