89
ACC
3
Battle of the Bands
Database
important NOTE
Priortocompletingthis
project,youmustfirst
completeProjectEXL-1
BattleoftheBandsList
intheMicrosoftExcel
sectionofthisbook.
your TASK
Your task is to import
the Excel spreadsheet
into Access and create
a query. The first row
of the spreadsheet will
be used as field names.
the SKILLS
· ImportfromExcel
· Createaquery
A
sabusinessgetsstarted,manytimesaspreadsheetprogramisusedin
placeofadatabase.Itisn'talwayseasytoseetheneedforsomeofthe
advantagesofstoringyourdatainadatabase.Butonceabusinessrealizesa
needforarelationaldatabase,thenaspreadsheetjustwon'tdo.Forinstance,
atthebeginning,alistofvendorsinExcelmightbefineforabusiness,but
latertheymayneedanotherlistofordersfromthatvendorandyetanother
listofpossibleproductsthatcanbebought.Switchingovertoadatabase
sooner,ratherthanlater,preparesforneedsthatmayyettoberealized.
1. WhenimportingdatafromExcel,ithelpsifthefirstrowofthespreadsheet
containsfieldnames.Thatway,thedatabasestructurewillbesetup.
2. Readthroughallinstructionspriortocompletingtheproject.
1. UsingMicrosoftAccess,createanewdatabase.
2. SavethedatabaseasProjectACC-3BattleoftheBandsDatabaseinyour
"Access"folderunder"TheHub"folder.
3. ImporttheExcelfileyousavedfromProjectEXL-1BattleoftheBandsList.Since
yourspreadsheetcontainsfieldnamesinthefirstrow,importthedataintoa
newtableinthecurrentdatabaseandallowAccesstocreatethefieldnames
fromthespreadsheetcolumnheadings.
4. SavethetableasBANDSwithoutdefiningaprimarykey.
5. GototheDatasheetViewandadjusttheFieldNamecolumnwidthsas
necessary.
6. Resavethetable.
7. Carefullyproofreadyourworkforaccuracyandformat.
8. PrintacopyoftheBANDStableifrequiredbyyourinstructor.
9. ClosetheBANDStable.
10. CreateaNEWqueryinDesignViewthatshowsonlythebandsthatplayFunk.
11. YourqueryshouldshowBandName,FirstName,LastName,Phone,andType
ofMusic.
12. SavethequeryasFUNKBANDS.
13. PrintacopyoftheFUNKBANDSqueryifrequiredbyyourinstructor.
For Evaluation Purposes Only