Excel file with sample data
Archive of posts filed under the Access category.
Access 2007 Introduction – Sample data files
Text Data Import.txt
Access 2007 – miscellaneous sources of online Access help
http://www.tek-tips.com/threadminder.cfm?pid=365
http://accessjunkie.com/helplinks2007.aspx
http://support.microsoft.com/kb/287658 How to build combo-box main/child form
Utteraccess.com
http://www.allenbrowne.com/casu-22.html
http://tech.groups.yahoo.com/group/MS_Access_Professionals/
http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx
http://www.accessmvp.com/DJSteele/AccessIndex.html
http://www.accessmvp.com/KDSnell/WebSiteLinks.htm
http://accesstips.datamanagementsolutions.biz/apps.htm
http://www.contextures.com/xlsampledata01.html
http://www.contextures.com/xlsampledata01.html
http://www.chicopee.mec.edu/pages/Excel%20-%20PPoint%20workshop/Excel%20samples/excel_samples.htm
Sample database Access 2003
Insurance_2003.mdb
Using Insurance_2003.mdb database, create the following reports
1. qryEmployeeListByLocation – Alphabetical phone list of employees by location, with hire date
2. Fix the column headings as shown below. Add a report Title header and date/time footer.
Create a list of prospective bonus recipients using “Excellent” performance as your criteria. If the performance is excellent, propose an award of [...]
Access 2003 Query Training
RealEstate_2003.mdb
Using RealEstate_2003.mdb, create the following queries:
1. PricePerSqFt: [SalePrice]/[SqFeet]
a. verify query results using Excel
b. format as currency in query results
2. Demonstrate query error – incorrect field name spelling sqSfet/sqSfeet
3. Three tables query linking SubDivisionID – and SellingAgent to ID
4. Expression builder: Create new field qryPricePerSqFt: [SalePrice]/[SqFeet]
5. Change agent Angela Scott to your name
6. Calculate calculated sale [...]
Introduction to Access 2003 Sample Soccer Database
Click the link for training tables using Access 2003.
Price_of_Electricity.XL.zip.xls
Price_of_Electricity.XL.zip.xls
Price_of_Electricity.XL.zip.xls
Price_of_Electricity.XL.zip.xls
Price_of_Electricity.XL.zip.xls
Price_of_Electricity.XL.zip.xls
Price_of_Electricity.XL.zip.xls
Price_of_Electricity.XL.zip.xls
Price_of_Electricity.XL.zip.xls
Price_of_Electricity.XL.zip.xls
Price_of_Electricity.XL.zip.xls
Access 2007 Intermediate – Training Files
Access 2007 Labryinth Student Files.pdf
Intermediate Access 2007
TechCache Forms.accdb
TC Logo.jpg
Introduction to Access 2007 – Stark State College Continuing Education
Click here for the SoccerLeague.accdb database which forms the basis of the Introduction to Access 2007 course.
For additional Access 2007 training, check out my video training links below. They are not directly related to this course; the examples come from a different training series. However, every concept applies to Access 2007. Viewers interested in seeing [...]
PDF file – Introduction to Access 2007
Introduction to Access 2007.pdf
CompuFiciency FREE eBook
By all means, click the link below to receive your personal FREE PDF file with TOC, internal and external hyperlinks, and a wealth of FREE CompuFiciency information.
CompuFiciency Training.pdf
CompuFiciency Training.pdf
