Scribd
Upload
83 views4 pages

Dbms Using Ms Access

The proposed syllabus for the SEC course on Database Management System using Microsoft Access at L.C.B. College is designed for Arts Stream students and includes 3 credits with a focus on both theory and practical skills. The course covers essential topics such as database concepts, Microsoft Access orientation, creating relationships, working with table data, querying databases, using forms, and generating reports. Recommended textbooks include 'MS-Access' by Narendra Tiwari and 'Learning MS Access 2007' by Ramesh Bangia.

Uploaded by

rofi.lcbc
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
83 views4 pages

Dbms Using Ms Access

The proposed syllabus for the SEC course on Database Management System using Microsoft Access at L.C.B. College is designed for Arts Stream students and includes 3 credits with a focus on both theory and practical skills. The course covers essential topics such as database concepts, Microsoft Access orientation, creating relationships, working with table data, querying databases, using forms, and generating reports. Recommended textbooks include 'MS-Access' by Narendra Tiwari and 'Learning MS Access 2007' by Ramesh Bangia.

Uploaded by

rofi.lcbc
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Proposed Syllabus for SEC Course

L.C.B. College

Department of Computer Science

1. Semester: 3
2. Course Name: SEC Database Management System using Microsoft
Access
3. Credit : 03
4. Credit Distribution: Theory 2; Practical 1
5. Content:

Target Group: Students from Arts Stream

Learning Objective : After completing this topics students will be able to


acquire knowledge of databases like students, employees, railway databases,
skills in creating and developing forms, queries and reports.

Unit 1( 6 classes)
Introduction to the concepts of database management system:
Concept of database, Table, fields, field types, insertion of data, sorting,
forming report, creating a form.

Unit 2 (8 classes)

Orientation to Microsoft Access: Create a Simple Access Database, Get Help


and Configure Options in Microsoft Access;

Unit 3(8 classes)

Create Relationships: One-To-One, One-To-Many, Many-To-Many, Built-In


Functions

Unit 4(8 classes)

Working with Table Data: Modify Table Data; Sort and Filter Records;

Unit 5(10 classes)


Querying a Database: Create Basic Queries; Sort and Filter Data in a Query;
Perform Calculations in a Query;

Unit 6(10 classes)

Using Forms Create Basic Access Forms Work with Data on Access Forms;

Unit 7(10 classes)

Generating Reports: Create a Report ; Add Controls to a Report; Enhance the


Appearance of a Report ; Prepare a Report for Print; Organize Report
Information; Format Reports;
6. Recommended books:
 MS-Access by Narendra Tiwari
 Learning MS Access 2007, by Ramesh Bangia

7. Paper offered by: Lalit Chandra Bharali College

You might also like