- (24 points) Create a new table called âComputerBrandsInfoâ in the database in the starter
Access file
a. Create a new table in design view in the database in Access (4 pts)
b. Create a new field named as âComputerBrandâ in the design view of the table. And
also, please assign the data type âShort Textâ to the âComputerBrandâ field (8 pts)
c. Assign the primary key to the âComputerBrandâ field of the table (4 pts)
d. Save the table as âComputerBrandsInfoâ (4 pts)
e. Switch to datasheet view of the table. Add the below information to the
âComputerBrandâ field of the âComputerBrandsInfoâ table (4 pts)
Apple
HP
Lenovo
Razer - (16 points) Import data from the âComputerSalesInfo.xlsxâ file
a. Import data from the âComputerSalesInfo.xlsxâ file to the âComputerSalesInfoâ table
(8 pts)
b. Rename the primary key of the âComputerSalesInfoâ table from âIDâ to âSaleIDâ (4
pts)
c. Change the data type of the âSalePriceâ field of the âComputerSalesInfoâ table from
âNumberâ to âCurrencyâ (4 pts) - (8 points) Modify the âComputersâ table so that the âComputerProcessorâ field in the
âComputersâ table uses a combo box lookup field with the following four values:
Intel Core i5, Intel Core i7, Intel Core i9, AMD Ryzen 7 - (8 points) Create a relationship between the âComputersâ table and the
âComputerSalesInfoâ table
(Hint: the âComputerIDâ field is the primary key of the âComputersâ table. The
âComputerIDâ field is also the foreign key of the âComputerSalesInfoâ table;
Also please make sure the âComputersâ table and the âComputerSalesInfoâ table are
closed before you create a relationship for the two tables) - (16 points) Create a query named â5 – Computer Sale Informationâ that can show the
following information for computer sales:
a. ComputerYear
b. ComputerBrand
c. ComputerProcessor
d. ComputerColor
3
e. ComputerCondition
f. ComputerCost
g. SalePrice
h. SaleDate
(Hint: the fields above come from the âComputersâ table and the âComputerSalesInfoâ
table) - (10 points) Create a summary query named â6 – Summary of Cost by Brandâ to
summarize information about costs of computers by their brand. Specifically, this
summary query can group information about computer cost by:
a. ComputerBrand
and also show the following summarized information about computer cost:
b. Average ComputerCost
c. Maximum ComputerCost
(Hint: the fields, âComputerBrandâ and âComputerCostâ come from the âComputersâ
table; use the Max aggregate function for Maximum ComputerCost) - (14 points) Create a new query named â7 – Discountâ with the following information:
a. ComputerYear
b. ComputerBrand
c. ComputerProcessor
d. ComputerCondition
e. SalePrice
f. Create a calculated field called Discount which is equivalent to 15 percent of SalePrice
(Hint: the fields, âComputerYearâ, âComputerBrandâ, âComputerProcessorâ and
âComputerConditionâ come from the âComputersâ table; the âSalePriceâ field comes
from the âComputerSalesInfoâ table) - (4 points) Save and Submit your work
a. Save your answers in the Access file, and name it as
ânnn00000_access_assignment.accdbâ where nnn00000 is your NetID (AKA the account
you log into HuskyCT with) (2 pts)
b. Go back to the Access Assignment section in HuskyCT course website. You should
see the file uploading part similar to the screenshot below
4
Please submit your completed file to HuskyCT to finish your assignment (2 pts)
Note: Itâs recommended that you close the database file after you save the file in Access.
When the database file is still open, another associated middle file with icon and .laccdb
file name extension can be shown in your folder with the Access file with icon and .accdb
file name extension. Please donât submit the .laccdb file! Your submission Access file should
be the one with the .accdb file name extension.
Sample Solution
Firstly, Vittola discusses one of the just causes of war, most importantly, is when harm is inflicted but he does mention the harm does not lead to war, it depends on the extent or proportionality, another condition to jus ad bellum (Begby et al (2006b), Page 314). Frowe, however, argues the idea of âjust causeâ based on âSovereigntyâ which refers to the protection of political and territorial rights, along with human rights. In contemporary view, this view is more complicated to answer, given the rise of globalisation. Similarly, it is difficult to measure proportionality, particularly in war, because not only that there is an epistemic problem in calculating, but again todayâs world has developed (Frowe (2011), Page 54-6). Furthermore, Vittola argues war is necessary, not only for defensive purposes, âsince it is lawful to resist force with force,â but also to fight against the unjust, an offensive war, nations which are not punished for acting unjustly towards its own people or have unjustly taken land from the home nation (Begby et al (2006b), Page 310&313); to âteach its enemies a lesson,â but mainly to achieve the aim of war. This validates Aristotleâs argument: âthere must be war for the sake of peace (Aristotle (1996), Page 187). However, Frowe argues âself-defenceâ has a plurality of descriptions, seen in Chapter 1, showing that self-defence cannot always justify oneâs actions. Even more problematic, is the case of self-defence in war, where two conflicting views are established: The Collectivists, a whole new theory and the Individualists, the continuation of the domestic theory of self-defence (Frowe (2011), Page 9& 29-34). More importantly, Frowe refutes Vittolaâs view on vengeance because firstly it empowers the punisherâs authority, but also todayâs world prevents this action between countries through legal bodies like the UN, since we have modernised into a relatively peaceful society (Frowe (2011), Page 80-1). Most importantly, Frowe further refutes Vittola through his claim that âright intention cannot be used as an excuse to wage war in response to anticipated wrong,â suggesting we cannot just harm another just because they have done something unjust. Othe>
Firstly, Vittola discusses one of the just causes of war, most importantly, is when harm is inflicted but he does mention the harm does not lead to war, it depends on the extent or proportionality, another condition to jus ad bellum (Begby et al (2006b), Page 314). Frowe, however, argues the idea of âjust causeâ based on âSovereigntyâ which refers to the protection of political and territorial rights, along with human rights. In contemporary view, this view is more complicated to answer, given the rise of globalisation. Similarly, it is difficult to measure proportionality, particularly in war, because not only that there is an epistemic problem in calculating, but again todayâs world has developed (Frowe (2011), Page 54-6). Furthermore, Vittola argues war is necessary, not only for defensive purposes, âsince it is lawful to resist force with force,â but also to fight against the unjust, an offensive war, nations which are not punished for acting unjustly towards its own people or have unjustly taken land from the home nation (Begby et al (2006b), Page 310&313); to âteach its enemies a lesson,â but mainly to achieve the aim of war. This validates Aristotleâs argument: âthere must be war for the sake of peace (Aristotle (1996), Page 187). However, Frowe argues âself-defenceâ has a plurality of descriptions, seen in Chapter 1, showing that self-defence cannot always justify oneâs actions. Even more problematic, is the case of self-defence in war, where two conflicting views are established: The Collectivists, a whole new theory and the Individualists, the continuation of the domestic theory of self-defence (Frowe (2011), Page 9& 29-34). More importantly, Frowe refutes Vittolaâs view on vengeance because firstly it empowers the punisherâs authority, but also todayâs world prevents this action between countries through legal bodies like the UN, since we have modernised into a relatively peaceful society (Frowe (2011), Page 80-1). Most importantly, Frowe further refutes Vittola through his claim that âright intention cannot be used as an excuse to wage war in response to anticipated wrong,â suggesting we cannot just harm another just because they have done something unjust. Othe>
Is this question part of your Assignment?
We can help
Our aim is to help you get A+ grades on your Coursework.
We handle assignments in a multiplicity of subject areas including Admission Essays, General Essays, Case Studies, Coursework, Dissertations, Editing, Research Papers, and Research proposals
Header Button Label: Get Started NowGet Started Header Button Label: View writing samplesView writing samples