Download
1 / 2
20 likes | 29 Views
DBM 280 Week 4 Individual Assignment Creating Queries//tutorfortune.com<br><br>Click on below link to buy<br>https://tutorfortune.com/products/dbm-280-week-4-individual-assignment-creating-queries<br><br>DBM 280 Week 4 Individual Assignment Creating Queries<br> <br> <br>Instructions:<br>Before completing this assignment you will need to have:<br>u2022tImported the Custom and Item data<br>u2022tCreated entries in the Orders and Order Items tables<br>u2022tVerified the tables have proper ID values to ensure they are joined<br>properly<br>Using the database you created in Week One, create the following<br>queries:<br>u2022tA query showing all customers. Name the query, 'All Customers'.<br>Include all customer columns in the query.<br>u2022tA query showing all customers whose last name is 'Miller'. Include<br>all customer columns in the query. Name the query, 'Customers by<br>Name'.<br>u2022tA query showing all Items with a price less than $5.00. Name the<br>query, 'Less Expensive Items'. Include all columns in the query.<br>u2022tA query showing all orders for a particular customer (you may<br>choose the customer and use the name or ID to select the customer).<br>Address the following:<br>u2022tDisplay only the order ID, the order date, and the customer name.<br>u2022tName the query, 'Customer Orders'. Note: You will only return<br>orders for a single customer.<br>Make a copy of the 'Customer Orders' query you created. Name it,<br>'Customer Invoice', and include the items for the order.<br>Address the following:<br>u2022tInclude the following for the items: Item Name, Quantity, and Price.<br>u2022tDisplay the columns: Order ID, Order Date, Ship Date, Item Name,<br>Item Price, Quantity, Customer First and Last Name, Address, City,<br>State, and Zip.<br>u2022tAdd a calculated field called, 'Total', for the item total (the number of<br>items (Quantity) multiplied by the ItemPrice). The field in the design<br>view should look like the following: Total: [Quantity]*[ItemPrice]<br>Submit your Accessu00ae database file, as your deliverable for this<br>assignment, to the Assignment Files tab above.<br><br>Click on below link to buy<br>https://tutorfortune.com/products/dbm-280-week-4-individual-assignment-creating-queries<br>
E N D
DBM 280 Week 4 Individual Assignment Creating Queries//tutorfortune.com Click on below link to buy https://tutorfortune.com/products/dbm-280-week-4-individual-assignment-creating-queries D B M 2 8 0 We e k 4 I n d i v i d u a l A s s i g n me n t C r e a t i n g Q u e r i e s I n s t r u c t i o n s : B e f o r e c o mp l e t i n g t h i s a s s i g n me n t y o u w i l l n e e d t o h a v e : I mp o r t e d t h e C u s t o m a n d I t e m d a t a C r e a t e d e n t r i e s i n t h e O r d e r s a n d O r d e r I t e ms t a b l e s V e r i fi e d t h e t a b l e s h a v e p r o p e r I D v a l u e s t o e n s u r e t h e y a r e j o i n e d p r o p e r l y U s i n g t h e d a t a b a s e y o u c r e a t e d i n We e k O n e , c r e a t e t h e f o l l o w i n g q u e r i e s : A q u e r y s h o w i n g a l l c u s t o me r s . N a me t h e q u e r y , ' A l l C u s t o me r s ' . I n c l u d e a l l c u s t o me r c o l u mn s i n t h e q u e r y . A q u e r y s h o w i n g a l l c u s t o me r s w h o s e l a s t n a me i s ' Mi l l e r ' . I n c l u d e a l l c u s t o me r c o l u mn s i n t h e q u e r y . N a me t h e q u e r y , ' C u s t o me r s b y N a me ' . A q u e r y s h o w i n g a l l I t e ms w i t h a p r i c e l e s s t h a n $ 5 . 0 0 . N a me t h e q u e r y , ' L e s s E x p e n s i v e I t e ms ' . I n c l u d e a l l c o l u mn s i n t h e q u e r y . A q u e r y s h o w i n g a l l o r d e r s f o r a p a r t i c u l a r c u s t o me r ( y o u ma y c h o o s e t h e c u s t o me r a n d u s e t h e n a me o r I D t o s e l e c t t h e c u s t o me r ) . A d d r e s s t h e f o l l o w i n g :
D i s p l a y o n l y t h e o r d e r I D , t h e o r d e r d a t e , a n d t h e c u s t o me r n a me . N a me t h e q u e r y , ' C u s t o me r O r d e r s ' . N o t e : Y o u w i l l o n l y r e t u r n o r d e r s f o r a s i n g l e c u s t o me r . Ma k e a c o p y o f t h e ' C u s t o me r O r d e r s ' q u e r y y o u c r e a t e d . N a me i t , ' C u s t o me r I n v o i c e ' , a n d i n c l u d e t h e i t e ms f o r t h e o r d e r . A d d r e s s t h e f o l l o w i n g : I n c l u d e t h e f o l l o w i n g f o r t h e i t e ms : I t e m N a me , Q u a n t i t y , a n d P r i c e . D i s p l a y t h e c o l u mn s : O r d e r I D , O r d e r D a t e , S h i p D a t e , I t e m N a me , I t e m P r i c e , Q u a n t i t y , C u s t o me r F i r s t a n d L a s t N a me , A d d r e s s , C i t y , S t a t e , a n d Z i p . A d d a c a l c u l a t e d fi e l d c a l l e d , ' T o t a l ' , f o r t h e i t e m t o t a l ( t h e n u mb e r o f i t e ms ( Q u a n t i t y ) mu l t i p l i e d b y t h e I t e mP r i c e ) . T h e fi e l d i n t h e d e s i g n v i e w s h o u l d l o o k l i k e t h e f o l l o w i n g : T o t a l : [ Q u a n t i t y ] * [ I t e mP r i c e ] S u b mi t y o u r A c c e s s ® d a t a b a s e fi l e , a s y o u r d e l i v e r a b l e f o r t h i s a s s i g n me n t , t o t h e A s s i g n me n t F i l e s t a b a b o v e . Click on below link to buy https://tutorfortune.com/products/dbm-280-week-4-individual-assignment-creating-queries
