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 | |
Lab# 10 |
Chapter 3: Reports & Queries OurStudents.mdb |
| Lab# 11/ 12 |
Chapter 7 (Volume II): Macros and Switchboards OurStudents SportsObjects |
|
Entering data in Multiple Tables with a single Form - How to use more a single Form to enter data in more than one tables (having 1-to-many relationships)? |
||
|
Use of Startup Options in Microsoft Access: - How to configure the options? - For bypassing the configured options, use Shift+Enter (to open the mdb file) |
||
| Lab#13 | Lab Exam #2: Microsoft Access (Tables, Queries, Forms, Reports & Table Relationships ) |
|
| Lab #14 |
Creating More Powerful Applications: Introduction to VBA I -Working with Form Objects using Visual Basic Coding -Use of DoCmd Object -Use of VB-Routines like msgbox, inputbox -Creating simple VB applications Database File |
|
| Lab# 15 | Chapter 8 (Volume II): Creating More Powerful Applications: Introduction to VBA (Facilitating Data Entry) DatabaseFile VBA Tutorial |
|
| Lab#15 | Lab Exam #3: Microsoft Access ( Macros, Switchboard & Visual Basic Coding) | |