Access Assignment

Data has a way of accumulating in various formats, files, and locations, which makes it hard to actually get any use out of it. In this assignment, datais in a spreadsheet; therefore, import theclient and financial spreadsheets located in the above resources folder into an Access database. Using the data, do the following: Modify the client and financial tables using Design view, create a relationship that enforces referential integrity, create a Client form and insert the following values: B260 as client number, insert your contact information data into the name, street, city, state, and zip fields, enter 1, 200.00 in the current due field and 27 in the business analyst field. Next, create a query for the Client table to display all clients that have a current due amount > 1,000.00. Finally, create a report using the query results.
access_rubric.docx

business_analyst.xlsx

Don't use plagiarized sources. Get Your Custom Essay on
Access Assignment
Just from $13/Page
Order Essay

camashaly_client_data.xlsx

Unformatted Attachment Preview

Grading Rubric – Access
Business Analyst & Client Database
Class: BUIS 260
Professor Yorkman
Notes:
Description
Part 1:
Imported data from the Client worksheet and created Client table. Do
not save the export steps
Imported data from the Analyst worksheet and created Business
Analyst table. Do not save the export steps
Identified a unique column to be the primary key in the Client table
and Business Analyst table
Columns in the Client table and Business Analyst table are of
appropriate data types and lengths
Created Client form and entered contact information data correctly.
Save the form as frmClient
Part 2:
Created the relationship between Business Analyst and Client. Check
Enforcement Integrity
Created Current-Due query that include the Client name in ascending,
client number, client name, current due > $1,000.00. Save the query as
qryCurrentDue
Created a query that lists all the client names in ascending order,
street, city, zip, amount pay > 2,999.00. Save the query as
qryAmountPay
Part 3:
Created a report that uses the results of the current due Query in Part
2. In report design view – change the report header to read Client
Listing for insert your lastname. For Example, Client Listing for
Yorkman. Save the report as Client Due Report
The database is saved using the students’ lastname for example
Yorkman and submitted in the folder by the due date
TOTAL POSSIBLE POINTS:
YOUR SCORE: _______________
Pts
5
5
5
10
10
10
15
10
25
5
100
Your
Score
BA
11
14
27
35
Lastname
Kerry
Martinez
Liu
Scott
Firstname
Cordelia
Manuel
Jan
Jeff
Street
251 painter
3125 steel
265 Marble
1925 Pine
City
Georgetown
Kyle
Byron
Georgetwon
State
NC
SC
SC
Nc
Zip
28794
28797
28795
28794
SalaryYTD
$3,200.00
$3,100.00
$3,400.00
$500.00
IncentiveYTD
$3,450.00
$2,430.00
$2,280.00
$0.00
ClientNumber
ClientName
Street
City
State
BA53
Bavant Animal Hospital
134 Main
Burles
NC
Zip
28817
Amount Paid
$0,00
Current Due
$7.500,00
BB32
Babbage CPA Firm
464 Linnell
Austin
SC
28796
$1.500,00
$500,00
BC76
Buda Community Clinic
867 Ridge
Buda
NC
27032
$2.500,00
$750,00
CJ29
Catering by Jenna
123 Second
Granger
NC
27036
$3.000,00
$1.000,00
GA74
Grant Antiques
78 Catawba
Georgetown
NC
28794
$5.500,00
$3.200,00
GF56
Granger Foundation
65 Simpson
Granger
NC
27036
$0,00
$6.500,00
HC10
Hendley County Hospital
216 Rivard
Austin
SC
28796
$3.100,00
$1.200,00
KD21
KAL Design Studio
116 Pine
Georgetown
NC
28794
$6.000,00
$3.200,00
KG04
Kyle Grocery Cooperative
421 First
Kyle
SC
28798
$3.200,00
$0,00
ME14
Mike’s Electronic Stop
234 Gilham
Georgetown
NC
28794
$2.500,00
$1.500,00
PJ34
Patricia Jean Florist
345 Magee
Kyle
SC
28798
$0,00
$5.200,00
SL77
Smarter Law Associates
764 Main
Burles
NC
28817
$3.800,00
$0,00
TB17
The Bikeshop
346 Austin
Buda
NC
27032
$2.750,00
$1.200,00
WE05
Walburg Energy Alternatives
12 Polk
Walburg
NC
28819
$4.500,00
$1.450,00
WS01
Woody Sporting Goods
578 Central
Walburg
NC
28819
$2.250,00
$1.600,00
Contract Hours YTD Business Analyst Number
0,00
11
5,00
14
2,50
11
15,50
27
34,50
14
0,00
11
12,00
27
30,50
14
5,00
11
8,50
27
0,00
27
10,50
11
14,00
27
19,50
14
18,50
14

Purchase answer to see full
attachment

GradeAcers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

Order your essay today and save 15% with the discount code DISCOUNT15