B.Sc. (Information Technology) Office Tools for Data Management Syllabus - Mumbai University

This is the FY BSc IT syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based papers alongside it for ATKT candidates, so check which scheme your exam form names before you revise.

Loading syllabus...

Syllabus for Office Tools for Data Management

Skill enhancement course · Semester 1 · FY BSc IT · 2 credits · 50 marks

Module I: Practical 1

A. Getting familiar with MS Access Ribbon options. B. With the help of access wizard Create Database. Add 2 Tables. In each table add 5 columns of different data types. Add 10-10 entries in each table. Add necessary integrity constraints. C. Use the Table Wizard to create a table. Add and delete fields in an existing table. Establish an input mask and validation rule for fields within a table. Switch between the Design and Datasheet views of a table. Practical 2: A. Create and use an Input Mask to enter the data in sample table. B. Adding records in table by using Datasheet View, using a Form and using SQL. C. Create the Employee Database with necessary table and data and then implement the following transitions:
Delete the record for Kelly Marder.
Change Pamela Milgrom's salary to $59,500.
Use the Replace command to change all occurrences of "Manager" to "Supervisor". Practical 3: A. Create the Bookstore database with necessary table and data and modify the database to accommodate the following:
i Add the book Exploring Microsoft Office 2000 Vol II (ISBN: 013-011100-7) by Grauer/Barber, published in 1999 by Prentice Hall, selling for $45.00. ii. Change the price of Memory Management for All of Us to $29.95. iii. Delete The Presentation Design Book. B. Create a table employ with (idno, name, job, age, salary). Insert 10 records. Create a query to display the information of all managers. Create a query to display the names of employs who‟s salary is >15000. C. Use the Form Wizard to create a form, Move and size controls within a form. Use the completed form to enter data into the associated table. Practical 4: A. Add fields to an existing table. Use the Lookup Wizard to create a combo box. Add controls to an existing form to demonstrate inheritance. Add command buttons to a form. B. Generate and use various the queries using Query Wizards. C. Generate and use various the Query with User Input. D. Demonstrate use of Expression Builder. Practical 5: A. Use the report wizard to create a new report. Modify an existing report by adding, deleting, and/or modifying its controls. B. Create a query containing a calculated control. Then, create report based on that query. Use the Sorting and Grouping command to add a group header and group footer to a report. C. Use action queries to modify a database. Create a crosstab query to display summarized values from a table.

Module II: Practical 6

A. Create and Open a database with multiple tables; Identify the one-to-many relationships within the database and to produce reports based on those relationships. B. Create and Open a database with multiple tables; Identify the one-to-one relationships within the database and to produce reports based on those relationships. C. Create and Open a database with multiple tables; Identify the Many-to-Many relationships within the database and to produce reports based on those relationships. Practical 7: A. Demonstrate use of look up tables. B. Use the Report Wizard to create a report having the following requirements:
i Select the LastName field from the Author table. ii. Select the Title and Price fields from the Book table. iii. Select the PubName field from the Publisher table. iv. View the data by Publisher.
v Add a grouping level using LastName. vi. Sort the report by the Title field in ascending order. vii. Choose Stepped layout and Portrait orientation. viii. Type Book List as the report’s title. C. Define the relationship between two tables and add a subform to a form. Practical 8: A. Import an Access table from an Excel workbook. Create a one- to-many relationship between tables in a database. Create a multiple-table query. B. Import external data from the Excel spreadsheet file Bookstore.
i Make sure Import the source data into a new table in the current database is selected. ii. Select the Author worksheet. iii. Make sure that First Row Contains Column Headings is selected. iv. For the AuthorID field, set the Data Type option to Long Integer and set the Indexed option to Yes (No Duplicates).
v Select Choose my own primary key and make sure the AuthorID field is selected. vi. Save the table with the name Author. C. Export data from access to various formats. Practical 9: A. Relationships: Create and Use Author and Book Table.
i Create a relationship between the AuthorID field in the Author table and the AuthorCode field in the Book table. Put a checkmark in the box labeled Enforce Referential Integrity. ii. Create a relationship between the PubID field in the Publisher table and the PubID field in the Book table. Put a checkmark in the box labeled Enforce Referential Integrity. B. Create a switchboard; Use the Link Tables command to associate tables in one database with the objects in a different database. C. Create an AutoExec and a Close Database macro and demonstrate the use. Practical 10: A. Create the College Library database find out the following: -
i Total no. of copies of books subject wise. ii. A report displays all books group by Publisher. iii. A report displays all books group by Book Title. iv. A report displays all books group by Book Edition B. Demonstrate the use of Database Splitter Wizard by splitting database. C. Make Access database as an executable-only

Reference Books

1 MICROSOFT ACCESS 2019 by David Murray, Kendall Hunt Publishing, 1 st Edition, 2020.
2 Step by Step Microsoft Access 2013, by Joyce Cox and Joan Lambert, 1 st Edition, Microsoft Press, 2013
3 Access 2019 Bible, by Michael Alexander, Richard Kusleika, Wiley, 1 st Edition, 2018
4 Access 2019 For Dummies, by Laurie A. Ulrich, Ken Cook, Wiley, 1 st Edition, 2018

Reproduced from the University of Mumbai syllabus for B.Sc. (Information Technology) under NEP 2020, in force from the academic year 2024-25. Wording is as printed in that syllabus. Module numbering is as printed there too.

The complete syllabus

This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.

PDF BSc IT SEM I & II (2024 25) NEP NEP 2020 syllabus, in force from 2024-25 Read full PDF Read

PDF BSc IT V & VI 2024 25 Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read

PDF SY BSc IT 23 24 Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read

BSc IT Syllabus Study Path

Start with the year folder.
Use FYBSc IT, SYBSc IT, or TYBSc IT first so your syllabus check matches the semester you are preparing for.

Check units before opening notes.
Use the syllabus to confirm topics, then open BSc IT notes for the same semester.

Practice after the syllabus check.
Move to BSc IT question papers after reviewing the module scope.

FYBSc IT Syllabus SYBSc IT Syllabus TYBSc IT Syllabus BSc IT Notes BSc IT Papers

Report or request