微信客服：xiaoxionga100
微信客服：ITCS521
程序代写案例-INF001
时间：2021-05-08
INF001 – Information Systems Page 1 of 4
Assessment – Lab Assignment – Microsoft Access
INF001
1. Background
Microsoft Access Skill is a summative assessment that also provide
formative feedback on student progress. This assessment assesses the
knowledge of Microsoft Access concepts and theories discussed in the lab
session, examine the students’ ability to apply and analyse given scenarios
using Microsoft Access.
2. Learning Outcome/s and Assessment Overview
For this assessment, you will be able to Gain competence with a database
software including Skills learned from Access Tutorials #1, #2, #3 and #4
Basic Access operations, create a table, add fields (make sure field types
are correct), add records, using input masks, create a relationship (make
sure same data type for primary and foreign keys), create a form, create a
query, combine fields in a query, calculate with fields in a query, create a
report, modifying reports, working with layout of reports and forms.
3. Academic Integrity
At UC International College, Academic Integrity is about acting honestly,
fairly and responsibly in all of your academic work. As a student you are
expected to only submit original work that is your own and always give
credit or acknowledge other peoples’ ideas. If you fail to do this, then you
are in breach of the UC International College Academic Integrity Policy and
this will be treated as Academic Misconduct.
For further information, please read the policy on the Axis Portal for
more details - https://www.ucic.ac.nz/policies
Details
This is an assignment submitted
through Moodle.
To do list:
1. Read the background, learning
outcomes and assessment
overview in this document.
2. Login to the INF001 course
page in Moodle. You will find
this assessment under
“Assessments” section.
3. Read instructions on the
Moodle and check the
deadlines.
4. Complete your assignment by
the due date.
5. When the assignment
submission period is closed,
you will NOT be able to
submit.
INF001-20S3 MS Access Assignment Page 1
INFO123 Lab Assignment – Microsoft Access
Sem 1 2021 Due Sunday 9th May at 11:55pm Course Weighting 7.5%
Before you begin: -
• Login to MOODLE
• Copy the file MS Access Assignment from MOODLE and SAVE to your drive.
• Open the MS Access Assignment file. This is the file you will work in and upload when finished.
NOTE: Save your file regularly. Once finished, you will need to upload the assignment to Learn.
Background: You are required to help Power Plus Ltd., an online Battery Supplier, keep track of its
customers, products, orders and shipping details for each order.
Required: Using the file you have saved then opened, make alterations to the database you have
downloaded and add the features requested below:
IMPORTANT: When Access is open it creates a small “swap” file. Please close Access before you upload
the files as often the swap file is accidently uploaded rather than the database itself.
INF001-21S1 MS ACCESS Assignment
TABLES (10 marks)
1. In your database:
• Create a new Table called Shipping Details, with the field names shown below in Figure 1.
(2 marks)
• Choose a relevant data type for each field in the Shipping Details table
that is consistent with Figure 1. (2 marks)
• Add Default Value for the Courier Company field as “Courier Post”. (1 mark)
• Create a relevant Primary Key for the Shipping Details table. (1 mark)
2. Enter the data shown below in Figure 1 into the Shipping Details table. (2 marks)
Save your changes and close the Shipping Details table.
3. Modify the current relationships in your database to include the newly
created Shipping Details table. (2 marks)
Save your changes and close the Relationships window.
(Continue next page …)
Figure 1: Shipping Details
Tracking
Code
Shipping
Date
Courier Company Left Warehouse?
CP1 29/05/2017 Courier Post
CP2 29/05/2017 Courier Post
CP3 29/05/2017 Courier Post
CP5 30/05/2017 Courier Post
TNT1 30/05/2017 TNT
INF001-20S3 MS Access Assignment Page 2
FORMS (7 marks)
4. Create a form using the Customers table, displaying all the available fields.
(Recommend using the form wizard) (2 marks)
5. Change the title of your form to ‘Customers Details’. (1 mark)
6. Edit your newly created form and replace the Preferred Contact Method Textbox with a Combo Box.
a) Enter the following values (Row Source) that the user can select from later on.
• 1
• 2
• 3
b) Store the values (Control Source) in the field, Preferred Contact Method.
c) Rename the Combo Box field as Preferred Contact Method.
d) Resize the newly created Combo Box so that it is in-line (roughly) with the other Text Boxes.
(4 marks)
Save your changes and close the Customer Details form.
QUERY (8 marks)
7. Create a query called “Total Watch Batteries Sales”. Select the appropriate tables for your query,
so that the results include the following fields:
• Product Name
• Quantity (2 marks)
8. Add selection criteria to Product Name that returns only the results only for ‘Watch Battery’.
(1 mark)
9. Add a field to your query, called Total Price that calculates the total price for each item,
that is Total Price = Price Quantity.
Select a suitable Total method for the Total Price field you have just added. (3 marks)
10. Customise the query results so that the Totals are displayed as follows (Example shown in Figure 2)
• Product Name: Grouped by
• Quantity: Sum
• Total: Sum (2 marks)
(If you run your query it should look like Figure 2. The column labels and order of the columns and rows
do not matter)
Save your changes and close the Total Watch Batteries Sales query.
Figure 2: Query – Total Watch Batteries Sales
(Continue next page …)
INF001-20S3 MS Access Assignment Page 3
REPORT (8 marks)
11. Using the Sales Report query in your database, create a report that looks like the example in
Figure 3, below. (Recommend using the report wizard).
In this report you will need to:
• Select all the available fields from the Sales Report query
• Add a grouping level by the Customer Name
• Sort the records in descending order by the Order ID
• The Layout will be Stepped, and Orientation in Portrait
• Add a title to your report: ‘Online Sales Report’
• Format your report title so it displays as Italics.
• If needed, adjust your report so that all fields display properly
(e.g. no overlapping fields, the date displayed in full).
(5 marks)
12. Using the Group & Sort Tool, include a Group Footer showing the Total Order amount for
each Customer.
Display the Total Order amount using the Currency Format.
(See example in Figure 3) (3 marks)
Save your changes.
Figure 3
Note: You are not required to include shading, bolding or horizontal lines as shown in the example.
学霸联盟
Assessment – Lab Assignment – Microsoft Access
INF001
1. Background
Microsoft Access Skill is a summative assessment that also provide
formative feedback on student progress. This assessment assesses the
knowledge of Microsoft Access concepts and theories discussed in the lab
session, examine the students’ ability to apply and analyse given scenarios
using Microsoft Access.
2. Learning Outcome/s and Assessment Overview
For this assessment, you will be able to Gain competence with a database
software including Skills learned from Access Tutorials #1, #2, #3 and #4
Basic Access operations, create a table, add fields (make sure field types
are correct), add records, using input masks, create a relationship (make
sure same data type for primary and foreign keys), create a form, create a
query, combine fields in a query, calculate with fields in a query, create a
report, modifying reports, working with layout of reports and forms.
3. Academic Integrity
At UC International College, Academic Integrity is about acting honestly,
fairly and responsibly in all of your academic work. As a student you are
expected to only submit original work that is your own and always give
credit or acknowledge other peoples’ ideas. If you fail to do this, then you
are in breach of the UC International College Academic Integrity Policy and
this will be treated as Academic Misconduct.
For further information, please read the policy on the Axis Portal for
more details - https://www.ucic.ac.nz/policies
Details
This is an assignment submitted
through Moodle.
To do list:
1. Read the background, learning
outcomes and assessment
overview in this document.
2. Login to the INF001 course
page in Moodle. You will find
this assessment under
“Assessments” section.
3. Read instructions on the
Moodle and check the
deadlines.
4. Complete your assignment by
the due date.
5. When the assignment
submission period is closed,
you will NOT be able to
submit.
INF001-20S3 MS Access Assignment Page 1
INFO123 Lab Assignment – Microsoft Access
Sem 1 2021 Due Sunday 9th May at 11:55pm Course Weighting 7.5%
Before you begin: -
• Login to MOODLE
• Copy the file MS Access Assignment from MOODLE and SAVE to your drive.
• Open the MS Access Assignment file. This is the file you will work in and upload when finished.
NOTE: Save your file regularly. Once finished, you will need to upload the assignment to Learn.
Background: You are required to help Power Plus Ltd., an online Battery Supplier, keep track of its
customers, products, orders and shipping details for each order.
Required: Using the file you have saved then opened, make alterations to the database you have
downloaded and add the features requested below:
IMPORTANT: When Access is open it creates a small “swap” file. Please close Access before you upload
the files as often the swap file is accidently uploaded rather than the database itself.
INF001-21S1 MS ACCESS Assignment
TABLES (10 marks)
1. In your database:
• Create a new Table called Shipping Details, with the field names shown below in Figure 1.
(2 marks)
• Choose a relevant data type for each field in the Shipping Details table
that is consistent with Figure 1. (2 marks)
• Add Default Value for the Courier Company field as “Courier Post”. (1 mark)
• Create a relevant Primary Key for the Shipping Details table. (1 mark)
2. Enter the data shown below in Figure 1 into the Shipping Details table. (2 marks)
Save your changes and close the Shipping Details table.
3. Modify the current relationships in your database to include the newly
created Shipping Details table. (2 marks)
Save your changes and close the Relationships window.
(Continue next page …)
Figure 1: Shipping Details
Tracking
Code
Shipping
Date
Courier Company Left Warehouse?
CP1 29/05/2017 Courier Post
CP2 29/05/2017 Courier Post
CP3 29/05/2017 Courier Post
CP5 30/05/2017 Courier Post
TNT1 30/05/2017 TNT
INF001-20S3 MS Access Assignment Page 2
FORMS (7 marks)
4. Create a form using the Customers table, displaying all the available fields.
(Recommend using the form wizard) (2 marks)
5. Change the title of your form to ‘Customers Details’. (1 mark)
6. Edit your newly created form and replace the Preferred Contact Method Textbox with a Combo Box.
a) Enter the following values (Row Source) that the user can select from later on.
• 1
• 2
• 3
b) Store the values (Control Source) in the field, Preferred Contact Method.
c) Rename the Combo Box field as Preferred Contact Method.
d) Resize the newly created Combo Box so that it is in-line (roughly) with the other Text Boxes.
(4 marks)
Save your changes and close the Customer Details form.
QUERY (8 marks)
7. Create a query called “Total Watch Batteries Sales”. Select the appropriate tables for your query,
so that the results include the following fields:
• Product Name
• Quantity (2 marks)
8. Add selection criteria to Product Name that returns only the results only for ‘Watch Battery’.
(1 mark)
9. Add a field to your query, called Total Price that calculates the total price for each item,
that is Total Price = Price Quantity.
Select a suitable Total method for the Total Price field you have just added. (3 marks)
10. Customise the query results so that the Totals are displayed as follows (Example shown in Figure 2)
• Product Name: Grouped by
• Quantity: Sum
• Total: Sum (2 marks)
(If you run your query it should look like Figure 2. The column labels and order of the columns and rows
do not matter)
Save your changes and close the Total Watch Batteries Sales query.
Figure 2: Query – Total Watch Batteries Sales
(Continue next page …)
INF001-20S3 MS Access Assignment Page 3
REPORT (8 marks)
11. Using the Sales Report query in your database, create a report that looks like the example in
Figure 3, below. (Recommend using the report wizard).
In this report you will need to:
• Select all the available fields from the Sales Report query
• Add a grouping level by the Customer Name
• Sort the records in descending order by the Order ID
• The Layout will be Stepped, and Orientation in Portrait
• Add a title to your report: ‘Online Sales Report’
• Format your report title so it displays as Italics.
• If needed, adjust your report so that all fields display properly
(e.g. no overlapping fields, the date displayed in full).
(5 marks)
12. Using the Group & Sort Tool, include a Group Footer showing the Total Order amount for
each Customer.
Display the Total Order amount using the Currency Format.
(See example in Figure 3) (3 marks)
Save your changes.
Figure 3
Note: You are not required to include shading, bolding or horizontal lines as shown in the example.
学霸联盟
