Computer Programming-B.Com.–Sem–IV

UNIT – I : COMPUTER COMMUNICATION SYSTEMS

1. Computer Communication Systems 

UNIT – II : PRINCIPLES OF DBMS

2. Principles of DBMS 

UNIT – III : CASE STUDY OF DBMS USING MS-ACCESS

3. Microsoft Office Workspace Basics and Access Interface

4. Starting with Microsoft Access Database 

5. Microsoft Access – Working with Tables 

UNIT – IV : MS-ACCESS QUERIES

6. Microsoft Access Queries and Table Joins 

7. Microsoft Access Forms 

8. Microsoft Access Reports 

LABORATORY TRAINING

Lab 1 : Microsoft Access 2007 – Access Menu and Ribbon 

Lab 2 : Microsoft Access Databases 

Lab 3 : Creating Tables And Adding Details (Design View) 

Lab 4 : Using A Form as A Data Entry Object 

Lab 5 : Using Access Tables 

Lab 6 : Understanding Different Views 

Lab 7 : Adding and Saving Records, Deleting and Modifying Fields

Lab 8 A: Sorting & Filtering Tables 

Lab 8 B : Working with Queries 

Lab 9 : Importing Data from Excel Sheet 

Lab 10 : Access Reports 

Model Question Paper

Mumbai Univ. Ques. Paper (March 2018) 

Mumbai Univ. Ques. Paper (April 2019)