1 / 3

DBM 280 Week 2 Individual Assignment Visual Aid Project, Part I//tutorfortune.com

DBM 280 Week 2 Individual Assignment Visual Aid Project, Part I//tutorfortune.com<br><br>Click on below link to buy<br>https://tutorfortune.com/products/dbm-280-week-2-individual-assignment-visual-aid-project-part-i<br><br>DBM 280 Week 2 Individual Assignment Visual Aid Project, Part I<br><br> <br>Instructions:<br>Based on this week's collaboration discussion, create a visual aid that<br>explains the obstacles associated with creating tables, modifying fields,<br>establishing primary keys and relationships, and importing data into a<br>table. Include solutions to overcome them.<br>Address the following:<br>u2022tChoose two obstacles and their solutions that you personally want to<br>remember and believe will help you going forward working with<br>Microsoftu00ae Accessu00ae databases.<br>u2022tUse a software that allows you to create a visual description of your<br>obstacles and solutions. Examples of software you may use include<br>Microsoftu00ae PowerPointu00ae or Piktochart. You may choose any software<br>that creates an electronic file you will be able to submit.<br>u2022tCreate at least one slide or page per obstacle/solution.<br>u2022tDescribe the obstacle and provide at least one solution. In total, your<br>file should have at least two slides or pages when this week's<br>assignment is complete.<br>Save your file in a format you can submit. Examples include the original<br>software file format such as PowerPointu00ae or PDF file format.<br>Submit your Visual Aid file, as your deliverable for this assignment, to<br>the Assignment Files tab above. <br>DBM 280 Week 2 Individual Assignment Creating Tables<br> <br>Instructions:<br>Using the database you created in Week One, complete the following:<br>u2022tCreate the tables that will support an invoicing system for the online<br>store.<br>u2022tInclude the following tables:<br>u2022t"Orders"<br>u2022t"OrderItems"<br>u2022t"Items"<br>u2022tNote: Make sure you have the following fields associated to the<br>correct table. These will be used in the following weeks (Order ID,<br>Order Date, Ship Date, Item Name, Item Price, Quantity, Customer First<br>and Last Name, Address, City, State, and Zip).<br>u2022tImport the data for "Customers", using a Microsoftu00ae Excelu00ae<br>document (Customer_Data).<br>u2022tImport the data for "Items", using a Microsoftu00ae Excelu00ae document<br>(Item_Data).<br>u2022tCreate the necessary fields with the appropriate data types, select<br>primary keys, and establish the relationships between tables.<br>u2022tInclude a description for each field, relevant validation rules,<br>formatting, and other properties.<br>u2022tAdd data for at least five orders. Each order should contain at least<br>three items.<br>u2022t"Customers"<br>Submit your Accessu00ae database file, as your deliverable for this<br>assignment, to the Assignment Files tab above.<br>SupportingMaterial:Customer Data FileItem Data FileIndividual: Create<br>a New Accessu00ae Database<br><br>Click on below link to buy<br>https://tutorfortune.com/products/dbm-280-week-2-individual-assignment-visual-aid-project-part-i<br>

hitnit
Download Presentation

DBM 280 Week 2 Individual Assignment Visual Aid Project, Part I//tutorfortune.com

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBM 280 Week 2 Individual Assignment Visual Aid Project, Part I//tutorfortune.com Click on below link to buy https://tutorfortune.com/products/dbm-280-week-2-individual-assignment-visual-aid-project-part-i D B M 2 8 0 We e k 2 I n d i v i d u a l A s s i g n me n t V i s u a l A i d P r o j e c t , P a r t I   I n s t r u c t i o n s : B a s e d o n t h i s w e e k ' s c o l l a b o r a t i o n d i s c u s s i o n , c r e a t e a v i s u a l a i d t h a t e x p l a i n s t h e o b s t a c l e s a s s o c i a t e d w i t h c r e a t i n g t a b l e s , mo d i f y i n g fi e l d s , e s t a b l i s h i n g p r i ma r y k e y s a n d r e l a t i o n s h i p s , a n d i mp o r t i n g d a t a i n t o a t a b l e . I n c l u d e s o l u t i o n s t o o v e r c o me t h e m. A d d r e s s t h e f o l l o w i n g : C h o o s e t w o o b s t a c l e s a n d t h e i r s o l u t i o n s t h a t y o u p e r s o n a l l y w a n t t o  r e me mb e r a n d b e l i e v e w i l l h e l p y o u g o i n g f o r w a r d w o r k i n g w i t h Mi c r o s o f t ® A c c e s s ® d a t a b a s e s . U s e a s o f t w a r e t h a t a l l o w s y o u t o c r e a t e a v i s u a l d e s c r i p t i o n o f y o u r  o b s t a c l e s a n d s o l u t i o n s . E x a mp l e s o f s o f t w a r e y o u ma y u s e i n c l u d e Mi c r o s o f t ® P o w e r P o i n t ® o r P i k t o c h a r t . Y o u ma y c h o o s e a n y s o f t w a r e t h a t c r e a t e s a n e l e c t r o n i c fi l e y o u w i l l b e a b l e t o s u b mi t . C r e a t e a t l e a s t o n e s l i d e o r p a g e p e r o b s t a c l e / s o l u t i o n . D e s c r i b e t h e o b s t a c l e a n d p r o v i d e a t l e a s t o n e s o l u t i o n . I n t o t a l , y o u r   fi l e s h o u l d h a v e a t l e a s t t w o s l i d e s o r p a g e s w h e n t h i s w e e k ' s a s s i g n me n t i s c o mp l e t e . S a v e y o u r fi l e i n a f o r ma t y o u c a n s u b mi t . E x a mp l e s i n c l u d e t h e o r i g i n a l

  2. s o f t w a r e fi l e f o r ma t s u c h a s P o w e r P o i n t ® o r P D F fi l e f o r ma t . S u b mi t y o u r V i s u a l A i d 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 .   D B M 2 8 0 We e k 2 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 T a b l e s   I n s t r u c t i o n s : 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 o mp l e t e t h e f o l l o w i n g : C r e a t e t h e t a b l e s t h a t w i l l s u p p o r t a n i n v o i c i n g s y s t e m f o r t h e o n l i n e  s t o r e . I n c l u d e t h e f o l l o w i n g t a b l e s : " O r d e r s " " O r d e r I t e ms " " I t e ms " N o t e : Ma k e s u r e y o u h a v e t h e f o l l o w i n g fi e l d s a s s o c i a t e d t o t h e      c o r r e c t t a b l e . T h e s e w i l l b e u s e d i n t h e f o l l o w i n g w e e k 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 ) . I mp o r t t h e d a t a f o r " C u s t o me r s " , u s i n g a Mi c r o s o f t ® E x c e l ®  d o c u me n t ( C u s t o me r _ D a t a ) . I mp o r t t h e d a t a f o r " I t e ms " , u s i n g a Mi c r o s o f t ® E x c e l ® d o c u me n t  ( I t e m_ D a t a ) . C r e a t e t h e n e c e s s a r y fi e l d s w i t h t h e a p p r o p r i a t e d a t a t y p e s , s e l e c t  p r i ma r y k e y s , a n d e s t a b l i s h t h e r e l a t i o n s h i p s b e t w e e n t a b l e s . I n c l u d e a d e s c r i p t i o n f o r e a c h fi e l d , r e l e v a n t v a l i d a t i o n r u l e s ,  f o r ma t t i n g , a n d o t h e r p r o p e r t i e s . A d d d a t a f o r a t l e a s t fi v e o r d e r s . E a c h o r d e r s h o u l d c o n t a i n a t l e a s t 

  3. t h r e e i t e ms . " C u s t o me r s "  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 . S u p p o r t i n g Ma t e r i a l : C u s t o me r D a t a F i l e I t e m D a t a F i l e I n d i v i d u a l : C r e a t e a N e w A c c e s s ® D a t a b a s e Click on below link to buy https://tutorfortune.com/products/dbm-280-week-2-individual-assignment-visual-aid-project-part-i

More Related