Instructor: Irfan Ahmed Ilyas

 Lab Sessions   

  Topic Covered

Lab #1

WebCT Usage Tutorials
 

 - Practices in Microsoft Windows 2000
- Use of WebCT

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


Lab# 8

 

Chapter2:
Working with Microsoft Access Tables 
LookAhead.mdb


Lab# 9
 

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)  

 Lab Sessions  (Mr. Raza)