Instructor: Irfan Ahmed
Ilyas
Lab Sessions
| Topic Covered | |
|
- Practices in Microsoft Windows 2000 |
|
| Lab #2 Practice 1 Practice 2 Practice 3 |
Excel Tutorial#1:
Introduction to Microsoft Excel - When should I use MSExcel? (Flash Animation- Speakers are needed) |
|
Lab#3 Practice 1 Practice 4 Practice 2 Practice 3 |
Excel Tutorial#2: Gaining Proficiency: The Web & Business Applications |
|
Lab #4 Practice 1 Practice 2 Practice 3 |
Excel Tutorial#3: Spreadsheets in Decision Making: What if? |
Lab #5 |
Excel Tutorial#4: Graphs and Charts Practice File docfile |
| Lab Exam 01 | Lab Exam 01 - Microsoft
Excel
Version 01 - Sec02 Version 02- Sec02 |
| Lab#7 | Chapter 1: Introducing Microsoft Access Practice File |
Chapter2:
|
|
| Relationships & Forms
Employees
OurStudents More Explanations on relationships |
|
Lab# 10 |
Chapter 3: Reports & Queries OurStudents.mdb |
| Lab# 11 |
Chapter 7 (Volume II): Macros and Switchboards OurStudents SportsObjects |
|
Startup Options in Microsoft Access: - How to configure the options? - For bypassing the configured options, use Shift+Enter (to open the mdb file) |
||
| Lab# 12 | Chapter 8 (Volume II): Creating More Powerful Applications: Introduction to VBA (Facilitating Data Entry) Database File VBA Tutorial |
|
| Lab#13 | Lab Exam #2: Microsoft Access (Tables, Queries, Forms, Reports & Table Relationships ) |
|
| Lab#14 | Chapter 8 (Volume II): Creating More Powerful Applications: Introduction to VBA (Data Validation) Introduction to VBA |
|
| Lab#15 | Lab Exam #3: Microsoft Access ( Macros, Switchboard & Visual Basic Coding) | |