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...
Formula to Count Occurrences of a Word in a Cell or Range in Excel
Tutorial: Formula to count how many times a word appears in a single cell or an entire range in Exce...
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...

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.