Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
3D References - Formulas that Reference Multiple Sheets at Once in Excel
Tutorial: Have one simple formula that will reference the same cell or range of cells on multiple w...

Office 2010 Class #48: Import Excel Data Into Access & Compare & Contrast Formulas in Access & Excel

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
This video goes with the Highline Community College Busn 216 Computer Applications Class Access 2010.
Topics Covered In Video:
1. Import Excel Data Into Access
2. See how to skip columns during import
3. Create calculated Fields in a table and a query
4. Compare and contrast how Excel and Access formulas are created.
5. Create Percentage Grade Formula In Access
6. Learn how to use Build Expression to construct formulas in Access.

Got a Question? Ask it Here in the Forum.