Click here for the latest eBook I’ve created for CompuFiciency 101. This is a FREE goldmine of helpful tips, tricks, etc.
SSCU CompuFiciency 101 Training Manual.pdf
Archive of entries posted on October 2009
Latest CompuFiciency eBook
Word 2007 quick text blocks
Word 2007 building blocks – quick text blocks
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
