Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.
6 Pages
Assignment - Access-B
Course: BMGT 301, Spring 2012School: University of Maryland
Rating:
Word Count: 1289
Document Preview
Usethisversion(A)ifyourstudentIDnumberendsin1,3,5,7,or9.Nocreditwill begivenifyousubmitthewrongversionoftheassignment. 2. BMGT301:ACCESSASSIGNMENTversionB Spring2012Prof.Stewart DueFridayMarch16at11:55pm INSTRUCTIONS: 1. Thisisanindividualassignment.Donotsharefileswithanyoneelse. 3. Submityour.accdbfileintheassignmenttabinblackboard.A10%penaltywill bedeductedforeachdayorpartofadaythatanassignmentislate.Preparein...
Unformatted Document Excerpt
Coursehero >> Maryland >> University of Maryland >> BMGT 301Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Usethisversion(A)ifyourstudentIDnumberendsin1,3,5,7,or9.Nocreditwill
begivenifyousubmitthewrongversionoftheassignment.
2. BMGT301:ACCESSASSIGNMENTversionB
Spring2012Prof.Stewart
DueFridayMarch16at11:55pm
INSTRUCTIONS:
1. Thisisanindividualassignment.Donotsharefileswithanyoneelse.
3. Submityour.accdbfileintheassignmenttabinblackboard.A10%penaltywill
bedeductedforeachdayorpartofadaythatanassignmentislate.Preparein
advancesothatyouwillnotencounterdifficultiesthatwillresultinyourwork
receivingalatepenalty.Ifyouhaveaconflictwiththeduedate,assignmentscan
besubmittedearly.
CoffeeAddict.com
Background
SeanandMiraarefriendswhoshareatasteforspecialtycoffees.Thetwostartedasmall
localcoffeeshop,CoffeeAddict,topursuetheirpassion.Someloyalcustomerswho
movedawayaskedthemtoshiptheircoffee,sotheybeganacoffeeclub,sendingunique
blendsouttotheircustomersoncepermonth.Althoughbusinesshasbeengood,difficult
financialtimesareforcingthemtofindnew,innovativewaystomarketthebusiness.
TheyarelookingtotheWebtostrengthenthebusinessbyreachingawideraudience.
Aftersomeinitialmarkettesting,theyplantostartCoffeeAddict.com,aclubthatships
coffeeandrelatedproductstomembersonamonthlybasis.Tomakethebusinesswork,
theyneedtoupgradetheirIT.Astheystartedtheclubonasmallbasiswithjustafew
customers,theytrackedinformationusingExcelspreadsheets.Nowtheyneedadatabase
thatwillallowthemtolearnabouttheirgrowingmembership,investigatepotential
marketingopportunitiesandidentifyareasforexpansion.Theyhireyoutocreatea
prototype.
BusinessModel
1
CoffeeAddict.comwilloffermembersawideselectionofbothdomesticandimported
coffees.Totakeadvantageoftheonlinecoffeestore,acustomerwillsubscribeandpaya
monthlymembershipfee.Thememberisthenshippedapackageofcoffeesatthe
beginningofeachmonth.Themembershipfeeisbasedonthepackageselected.Each
packageincludesadifferentnumberofcoffeesandcomplementaryproductssuchas
cookiesorothersnacks.Theselectionofcoffeesincludedvarieseverymonth.Untilthe
membershipsubscriptioniscancelled,thecoffeeclubmemberscreditcardisbilleda
monthlymembershipfee.Amemberisfreetochangeorcancelhermembershipplanat
anytime.
Theenrollmentformcollectsbasiccustomerinformation,includingcreditcardnumber,
shippingaddress,andemailaddress.Atthetimeofenrollment,asubscriberselectsa
membershipplanthatissuitabletohertastes.Duringthesubscriptionprocess,anew
memberindicateswhetherornotshewouldliketoreceivetheCoffeeAddictnewsletter.
Thisnewsletterprovidescoffeereviews,offerspromotions,identifiesnewselectionsthat
willbeincludedinfuturemonths,andisagoodwayforthefriendstokeepintouchwith
currentcoffeeclubmembers.
PotentialcoffeeclubmembersmaydiscoverCoffeeAddict.cominavarietyofways.
Friends,televisionandprintadvertisements,otherWebsites,andsearchenginesare
expectedtocontributetothenewonlinestoressuccess.Whensubscribing,anew
memberisaskedhowshelearnedaboutthestore.Thisinformationisthenstoredinthe
membersrecord.Thefriendswillusethisinformationtobettermarkettheirstoreinthe
future.
Thefollowingsectiondescribestheinformationandthemodificationsthatyouhavebeen
taskedwithcompleting.
ProjectSpecifications
Youhavebeenhiredtoaddressseveralspecificneeds.Theseare:
1. Createappropriaterelationshipsamongthetables,makingsuretoenforce
referentialintegrity.(5points).
2. Createaformtoalloweasyaddition,deletion,navigation,andeditingofPlansby
CoffeeAddictemployees(hint:usebuttons).Makesuretheformiswelldesigned
anduserfriendly.Placethetitleoftheformandyournameintheheaderofthe
form.(10points).
2
3. CreateaformtobeusedbyCoffeeAddictemployeestomanagemembersdata.
Placethetitleandyournameintheheaderoftheform.Bydefault,thenewsletter
fieldshouldbesettoyesfornewrecords.Makesurethatphonenumbersall
appearinaconsistentformat.(Hint:useaninputmask).Makesureonlyexisting
plansandcontactcodescanbeentered.Allowforeasyaddition,deletion,editing
andnavigation.Addasmallpictureintheheaderofthisformtorepresentthe
business.(15points)
4. ThefriendsareconsideringopeninganewphysicalstoreinTexas.Createa
reporttohelpthemassessthebestlocations.Placeyournameintheheaderofthe
report.ThereportshouldshowthetotalnumberofmembersineachcityinTexas
andthetotalannualrevenuegeneratedfromeachcityinTexas,aswellasagrand
total.Seetheexamplebelowforadraftmockupofwhatthisreportshouldlook
like.(20points).(Hint:createaquerytogettheinformationbeforecreatingyour
report).
5. Toplantheirmarketingcampaignforthenewyear,thefriendswanttoknow
whichtypeofcontactmechanism(e.g.,magazine,radio,etc)attractsthegreatest
numberofnewmembersduringthefirstquarteroftheyear.Provideareportthat
allowsthemtoseehowmanymembersaregeneratedfromeachsourceduring
Q1.(Note:thisreportwillbemorechallenging;youwillneedtothinkaboutwhat
youwanttoaccomplishandfigureouthowtodoit.Youmaywanttosearchfor
helpfulfunctionsinAccess).(20points)
6. Thefriendswouldliketoaddfunctionalitytoallowuserstoratethecoffeesthey
receive.Ratingswillbeonascaleof17.Theywanttostoretheseratingsand
thenprintoutareportoftheaverageratingsforeachcoffeeoverallandbystate.
Implementthisfunctionality.Hints:youwillneedtocreatenewtablestostorethe
newdata,createaformtoallowtheratingsdatatobeentered,thencreateaquery
toprovidedataforthereport.Enter1015ratingssoyouwillhavedatatotest
yourqueryandreport.Youdonotneedtointegratethenewdatabeyondwhatis
specifiedinthisrequiremente.g.,youdonotneedtotrackwhichcoffeesare
includedinwhichplans.Sketchesofwhattheformandreportshouldlooklike
arebelowyourreportshouldincludeallinformationonthesketch,thoughyour
datamaybedifferent.(30points).
IMPORTANT:Downloadthe.accdbfiletoyourcomputer,saveit,and
renameit:"YourSection#_B_YourLastName_YourFirstName.accdb"
Thisfilecontainsinitialtablesandtestdata.Doyourworkinthisfile,then
3
submititviaBlackboard.Makesureyouclosethefilebeforeyousubmitit.
Makesureyousubmitthecorrectversionwiththecorrectextension
(Accessmaycreateatemporaryfilewiththesamenamebuta.laccdb
extensiondonotsubmitthataccidentallyasitcannotbegraded).Savea
backupincasethereisanyproblemwithyoursubmission.
NOTE: examples below are provided to give you a starting point. These examples
contain sample data the data that shows in your actual forms/reports may be different.
Makesureyourformsandreportsareneatandprofessional(sloppinesswillloweryour
grade).
Texas Membership Report
City
Austin
Dallas
Houston
Salinas
Texas City
Waco
Wimberly
Number of Members
3
1
1
1
2
3
1
Total
12
4
Annual Revenue
$863.64
$299.88
$791.88
$431.88
$731.76
$863.64
$299.88
$4,282.56
Q1 New Members by Contact Type
Initial Contact Description
Q1 New Members
Friend
2
Newspaper
2
Other
1
Radio
2
Search Engine
2
Television
Total Q1 Members
5
1
10
Coffee Ratings By State
Coffee Name
Cinnamon
State
KS
OK
TX
Overall Average
Average Rating
3.5
3.5
3.25
3.42
Decaf
OK
TX
Overall Average
2
3.5
2.75
1
2
Mocha
KS
OK
TX
Overall Average
4
3
5
4.00
1
1
2
Average for All Coffees
3.47
6
Number of ratings
2
2
4
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more.
Course Hero has millions of course specific materials providing students with the best way to expand
their education.
Below is a small sample set of documents:
Below is a small sample set of documents:
University of Maryland - BMGT - 301
BMGT 301 Article Review AssignmentProf. StewartAs you prepare to begin your career after graduation, you should be keeping current ontrends and issues in business, especially those related to your major. This assignment isdesigned to encourage you to
University of Maryland - BMGT - 301
BMGT 301 Poster AssignmentProf. StewartYou will be randomly assigned to one of the 4 subjects described below. Assume you have beenhired by a company that provides a product or service related to your assigned subject. As one ofyour first assignments,
University of Maryland - BMGT - 301
Access Lab Forms and Reports1. We want a report that shows orders that have shipped recently (within the last week) or are not yetshipped. The report will list the order number, shipping method, customer number and name, and thedate shipped. First, we
University of Maryland - PHYS - 121
Homework # 1, PHYS 1212.5, 2.9, 2.10, 2.12, 2.18, 2.21, 2.33, 2.77Spring 2012Mastering Physics: P2.17, P2.22, P2.19, P2.25, P2.37, P2.67, P2.72P2.17. Prepare: The graph in Figure P2.17 shows distinct slopes in the time intervals: 0 1s, 1 s 2 s, and 2
University of Maryland - PHYS - 121
Homework # 2, PHYS 121Spring 20122.5, 2.9, 2.10, 2.12, 2.18, 2.21, 2.33, 2.77Mastering Physics: P2.12, P2.15, P2.29, P2.65, P2.69, P2.59, P2.70, 2.16P2.12. Prepare: Assume that Richard only speeds on the 125 mi stretch of the interstate. We then need
University of Maryland - PHYS - 121
'Martarv,a Pha rn., lcfw_rnr3Probt.* J,*"=#-tlYsta,e=+.tan Gl6 )t1-vrruakegurs ca['ealdor' t\0'ldeqree rnode 'Prubte*n 3- tgof $sovr*ftrwr'rt *h $Let dx = x -co*forae*-t6**-1G)If.rstq .vlil-l$J.6kwr49km [srn+o)d*' 2,6 k*
University of Maryland - PHYS - 121
'Martarv,a Pha rn., lcfw_rnr3Probt.* J,*"=#-tlYsta,e=+.tan Gl6 )t1-vrruakegurs ca['ealdor' t\0'ldeqree rnode 'Prubte*n 3- tgof $sovr*ftrwr'rt *h $Let dx = x -co*forae*-t6**-1G)If.rstq .vlil-l$J.6kwr49km [srn+o)d*' 2,6 k*
University of Maryland - PHYS - 121
+W-vw z.zzlL+ ) 3^ - lrue -fuULg =Ioon'llrvfrto6vL|AL +fuqrfcfw_v :/= tg:Omaqe[em,tyL/t.6q-*m/s,g:zE l,r,rc. =30"'ffi'A) S b :-fru,.I Ur, : t/; srnP C g-,o-poruil* -t rn]u-aL+ VytD= Vs, -3^t) A*).= VwL-+6-t, -o-+ L vgo- *g-t)
University of Maryland - PHYS - 121
PHYS 121 QUIZ No. 'lSection No.1.Name0101[2 points] [Figure I] shows the position graphroad. Theand thevelocity at instant I isvelocity at instant 2 isof a car traveling on a straightA. positive, positiveR. positive, negative@D.E.ur#'nega
University of Maryland - PHYS - 121
PHYSICS 121Name:Summer 2011Exam1The exam is worth 100 points. Some of the equations are given below.1 dimensional kinematic Equations:vf = vi+atvf2 = vi2 + 2a(xf-xi)xf = xi+ vit+ 1/2axt2Projectile Motionvfy = viSinvfx = vixxf = xi+ vixtvix =
University of Maryland - PHYS - 121
SUGGESTED PROBLEMSP2.6. Prepare: The slope of the position graph is the velocity graph.Solve:(a) Looking at the position graph we see the ball start at 6m and go up to 6m so that must be where thechildren are.(b)Assess: We can see that the first chi
University of Ottawa - PHYS - 101
12/7/11 My Research:I use satellite observations and computer models of the atmosphereto study the transport of pollution in the atmosphereProf. Dylan Jones Atmospheric Physicist Department of Physics Oce: MP 707B Tel: 416-978-4992
University of Ottawa - PHYS - 101
120109 PHY132S: Introduction to Physics IIProf. Dylan Jones Office: MP 707B Tel: 416-978-4992 email: dbj@atmosp.physics.utoronto.ca I will teach classes 1 12 Office Hours:Thursday: 11 am noonFriday: 2 3 pmPHY132S: Introduction to Physics IIDr.
University of Ottawa - PHYS - 101
1/11/2012PHY132 Introduction to Physics IIClass 2 Outline:Reminder Practicals begin next week, Monday, January 16.SinusoidalWavesWavesin2Dand3DSphericalwavesandplanewavesPowerandIntensityofWavesTheDopplerEffect If you did not select a Practical
University of Ottawa - PHYS - 101
PHY132 Introduction to Physics IIClass 3 Outline: Doppler Effect Principle ofSuperposition Standing Waves on aStringTheDopplerEffectAlternate Sitting for Test 1 Students who have a conflict between an academicactivity and the upcoming test on Ja
University of Ottawa - PHYS - 101
PHY132 Introduction to Physics IIClass 4 Outline: Standing Sound Waves Wave InterferenceInterference BeatsAlternate Sitting for Test 1 Students who have a conflict between an academicactivity and the upcoming test on Jan. 31 (18:1019:30) can now r
University of Ottawa - PHYS - 101
1/24/2012PHY132 Introduction to Physics IIClass 5 Outline: Beats Wave OpticsTerm Test 1 (Jan 31, 2012) The test will cover everything through class on Wed. 25January, which corresponds to the following chapters:All of Chapter 20All of Chapter 21
University of Ottawa - PHYS - 101
1/26/2012PHY132 Introduction to Physics IIClass 6 Outline: Wave optics - Interference Ray OpticsOur everyday experiencethat light travels in straightlines is the basis of theray model of light. Rayoptics apply to a variety ofsituations, includin
University of Ottawa - PHYS - 101
PHY132 Introduction to Physics IITest 1 Review - WavesNOTE: The slides shown here cover only a subset of the material forwhich you are responsible - the test covers all the chapters that wereassigned as readingCopyright 2008 Pearson Education, Inc.,
University of Ottawa - PHYS - 101
PHY132 Introduction to Physics IIClass 8Reminder: Ray Op.cs Light rays travel in straight lines Ray Optics:Chapters 23.5 23.7 Optical Instruments:Chapters 24.1 24.4Light rays can crossA light ray travels forever unless it interactswith matter
University of Ottawa - PHYS - 101
PHY132 Introduction to Physics IIClass 9 Outline:Electromagne,c Forces Electromagnetic interaction caused by fundamental property ofmatter: matter contains chargesChapter 26 Compared to other forces in nature electromagnetic forces dominateForce
University of Ottawa - PHYS - 101
PHY132 Introduction to Physics IIClass 10 Outline:Chapter 27 The Electric Dipole Continuous Charge Distributions The Parallel Plate Capacitor Motion of a Particle in an ElectricFieldAnnouncement The marks for Test 1 will be posted thismorning.
University of Ottawa - PHYS - 101
12-02-14PHY132S Introduction to Physics II Class 11 Outline:Announcement Motion of a Particle inTest 1 marks:an Electric Field The long-answer problem was graded by one person to Electric Potentialensure consistency in the marks. Only i
University of Ottawa - PHYS - 101
2/15/2012PHY132S Introduction to Physics IIClass 12 Outline:Announcement I will be out of the office on Thursday and Electric PotentialFriday, so I will not have office hours at theusual time. However, I will be accessible byemail.Energy Electri
University of Houston-Victoria - ECON - 101
Experiencing MIS, 3e (Kroenke)Chapter 9: Business Intelligence and Information Systems for Decision MakingMultiple Choice1) _ is information containing patterns, relationships, and trends.A) Technical writingB) Raw dataC) Business intelligenceD) In
University of Phoenix - BUS - 212
for University of Phoenix associates in business administration class final project
Ashford University - ENG125 - 125
A Look WithinA Look WithinShelby GoodwinJanuary 13, 2012Professor Amy HartmannENG 125The short story A Worn Path by Eudora Welty shares a lot of similarities anddifferences with the poem written by Robert Frost The Road Not Taken. Both are aboutpe
Ashford University - POL - POL201
My representative is Democratic Jay Inslee, he is assigned to the Energy and Commercecommittee. He is very concerned with clean energy. He wants to promote his vision for cleanenergy future, the New Apollo Energy Act. The act is about Our New Apollo Ene
Ashford University - ENG - 125
Responses to a PoemResponses to a PoemShelby GoodwinJanuary 9, 2012ENG125Professor Amy HartmannA poem is a form of expression, not to be confused with a story. In the poem "SheDwelt among the Untrodden Ways" the specific tone given to the poem, is
University of Phoenix - ETH 125 - 125
Associate Level MaterialAppendix EAsian Americans According to the U.S. Census BureauPart IOrganize statistics from the U.S. Census Bureau on Asian American diversity using the matrixbelow and the Asian/Pacific American Heritage Month: May 2010 docum
University of Phoenix - HCA/210 - AAAA0NYSI8
HIPAA Compliance of 19961HIPAA Compliance of 1996HCA/210December 4, 2011Suzie MaysHIPAA Compliance of 1996HIPAA Compliance of 1996HIPAA, the Health Insurance Portability and Accountability Act of 1996, is all about theprotection of patient health
FIU - ACCOUNTING - 101
B-16.14Ozark Corporation reported net income of $100,000 for 20X5. The income statementrevealed sales of $1,000,000; gross profit of $520,000; selling and administrative costs of$340,000; interest expense of $20,000; and income taxes of $60,000.The se
American Dubai - ACCG - 101
Problem 1-1Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer.
American Dubai - ACCG - 101
Problem 1-2Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer.
American Dubai - ACCG - 101
Problem 1-4Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer.
American Dubai - ACCG - 101
Problem 1-5Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer.
American Dubai - ACCG - 101
Exercise 1-13Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answe
American Dubai - ACCG - 101
Exercise 1-14Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answe
American Dubai - ACCG - 101
Exercise 1-16Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answe
American Dubai - ACCG - 101
Exercise 1-20Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answe
American Dubai - ACCG - 101
Problem 2-1Name: Section: Score: 28% *Since some answer boxes are correct when left blank, the beginning score is greater than 0%. Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cann
American Dubai - ACCG - 101
Problem 2-3Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer.
American Dubai - ACCG - 101
Problem 2-4Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer.
American Dubai - ACCG - 101
Exercise 2-16Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answe
American Dubai - ACCG - 101
Exercise 2-17Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answe
American Dubai - ACCG - 101
Exercise 2-18Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answe
American Dubai - ACCG - 101
Exercise 2-19Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answe
American Dubai - ACCG - 101
Exercise 15-21Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear beside an incorrect answer.Apartment Complex Y
American Dubai - ACCG - 101
Problem 15-6Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear beside, below or above an incorrect answer.1. Pr
American Dubai - ACCG - 101
Exercise 15-6Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear beside an incorrect answer.a. Initial investmen
American Dubai - ACCG - 101
Problem 15-5Name: Section: Score: 0%Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the row immediately to the right of an incorre