$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

FNDS015 Foundation Information Technology

tag 0 Download1 Pages / 1 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

A-TECH is an automotive service and repair company that receives a range of customer requests which include: regular vehicle servicing, repairs, performance modifications and Road Worthy Certificate inspections.A-TECH employs mechanics (called Technicians) who are able to carry out a broad range of automotive activities for the company. Depending on the type of a customer request, it can completed by either one or several of the technicians at a time, however each technician can only be assigned to one request at a time.

A customer may make one or more requests (‘Job’) when they call A-TECH, and details about the customer and the type of requests (‘Jobs’) need to be tracked. Requests are identified by a RequestID field. Also A-TECH needs to know the details of the technician who completed a request. Upon completion of a request, the customer receives an invoice that details the work done and the amount that must be paid. A-TECH needs to track all the invoices sent to customers and ensure payment for completed requests is received.
 
Create an appropriate relationship between the 2 tables and enforce referential integrity.
Create a Form:
1. Create a new form, ‘Columnar style’ based on the ‘Invoice’ table and include all the fields from the Invoice table. Name the form Invoice
2. Modify the look of the form and place a SIMPLE and CLEAR image of a car being repaired (find this image from an online search) in the header section of the form. Add a company name to yourform. Add your full name and student ID in the footer section of the form. Don’t forget to type it in likethis: FirstName LastName YAPAC1702
3. Change the background colour of all sections in the ‘Property Sheet section of the form.
 
1. Create a calculated field in the Invoice table in a new column with the name ‘Discounted Invoice Amount’ with a data type of currency (in the Field Properties window). Use this field to work out the 10% discount that is removed from the total of the Invoice amount.
Create Queries:
Create these queries to answer the questions below:
1. List all the customers who live in area ‘4216’ and include all the fields. Save the query as ‘Customer Area’.
2. The total value of all discounted invoices for each customer, showing the field CustomerID, LName inthe Customer table, and the fields Discounted Invoice Amount in the Invoice table. Save the query as ‘Invoice_Total’. Hint: you will need to use the in the Show/Hide toolbox in the Design Tab. Alongwith

3. List all the invoices (showing all the fields) that have an Amount of $3,999 or less. Savethe query as 
Create a Report
1. Create a Tabular report based on the query ‘Invoice_Total’ and sort in ascending order by, and order by 
2. Save as‘Job_Total’.
 
SubmissionInstructions:
This assignment is to be submitted through the ‘Assignment 3 submission link’ in week 12 ofthe portal. You will be shown this process in Week 11. Students must submit a zipped folder containing the Access Database file and the ERDtemplate document. The file must be zipped using Winzip or 7ZIP (as a .zipfile). Name each file with your Name and ID number, then name the FOLDER asshown.

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Foundation Information Technology. Retrieved from https://myassignmenthelp.com/free-samples/fnds015-foundation-information-technology/automotive-activities.html.

My Assignment Help (2020) Foundation Information Technology [Online]. Available from: https://myassignmenthelp.com/free-samples/fnds015-foundation-information-technology/automotive-activities.html
[Accessed 26 July 2021].

My Assignment Help. 'Foundation Information Technology' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/fnds015-foundation-information-technology/automotive-activities.html> accessed 26 July 2021.

My Assignment Help. Foundation Information Technology [Internet]. My Assignment Help. 2020 [cited 26 July 2021]. Available from: https://myassignmenthelp.com/free-samples/fnds015-foundation-information-technology/automotive-activities.html.


At MyAssignmenthelp.com, we are committed to deliver quality assignment assistance in the fastest way possible. To make our service delivery fast, we have hired subject matter experts to work on different subject specific assignments. We have hired experts who owe in-depth knowledge in their respective subjects. As per their expertise, they provide geography assignment help, Physics assignment help, Strategic assignment help, history assignment help, art architecture assignment help and assistance with other subjects as well.

Latest Other Samples

PM302 Project

Download : 0 | Pages : 35

Answer: The frontline staff of police sector in the UK. In England, a fall of 8% was seen and 6% and 5% fall was seen in Humberside and South Yorkshire respectively.  There were several reasons found behind this fall. One of them was stress and pressure of the officers.  In the views of Smith (2015), the budget cuts are made in the office roles of frontline police staff. This is the reason why there has been a fall in the total numbe...

Read More arrow

C19RH Business Research Methods

Download : 0 | Pages : 6

Answer: Will focus on discussing how and why the human resource is important in retail so as to enhance the knowledge regarding the topic of the dissertation Theoretical body of knowledge used  Human resource is crucial and this dissertation has been initiated with a motive to develop the knowledge regarding the importance of HR and reasons behind the importance of human resource in the retail industry (Reddy & Chandra, 2011). Human...

Read More arrow

MBA505 Business Psychology Coaching And Mentoring

Download : 0 | Page : 1

Answer: Path goal theory: The model of “path goal theory” describes the goal which helps the entrepreneur to achieve the chain market business within 2020 in supermarket (Phillips and Phillips 2016) · After completing the course of MBA, I want to be the Human Resource manager of a modern company.· I have set my aim to be a manager in the Human Resource department in a reputed business organisation, which is in Australi...

Read More arrow Tags: Australia Cowandilla Management Business Psychology  Coaching and Mentoring University of Queensland MBA 

COIT 20246 Internet Of Things

Download : 0 | Pages : 8

Answer: This article describes about one particular individual, who played an important role in the development of modern computing architecture, artificial intelligence. I chose this article as it states about the father of artificial intelligence, John McCarthy. He was the person behind the development of Artificial Intelligence. In this article, the author describes about the role of John McCarthy in the field of Artificial Intelligence. T...

Read More arrow

ITC 568 Cloud Privacy And Security

Download : 0 | Pages : 25

Answer: Management of personal information Personal information is defined in the Privacy Act 1988 as: “...information or an opinion (including information or an opinion forming part of a database), whether true or not, and whether recorded in a material form or not, about an individual whose identity is apparent, or can reasonably be ascertained, from the information or opinion. Management of personal information is an important proce...

Read More arrow
Next

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?