Lab Manual
Database management system
Fall 2021
Instructor
Student Name
CMSID
Department
Section
Introduction to Database system and
Lesson Set Tools for Database system and their Installation
1
Purpose 1. To get basic awareness of MS Access
2. To understand database system and why we are using it
3. To learn the basics of an editor and create simple database and add data to
the tables.
4. File Handling
Procedure 1. Students should read the Pre-lab Reading assignment before coming to lab.
2. Students should complete the Pre-lab Writing assignment before coming to
lab.
3. In the lab, students should complete Labs 1.1 through 1.4 in sequence.
Your instructor will give further instructions as to grading and completion of
the lab.
4. Students should complete the set of lab tasks before the next lab and get
them checked by their lab instructor.
Contents Pre-requisites Completion Page
Time Number
Pre-lab Reading Assignment - 20 min 3
Pre-lab Writing Assignment Pre-lab Reading 10 min 4
Lab 1
Lab 1.1 Pre-lab reading 30 min 5
Installing MS Access
Lab 1.2 Awareness of - 9
Lab Tasks GUI and Rules
2|Page
PRE-LAB READING ASSIGNMENT
MS Access
Microsoft Access is a Database Management System (DBMS) from Microsoft
that combines the relational Microsoft Jet Database Engine with a graphical
user interface and software development tools. It is a member of the Microsoft
Office suite of applications, included in the professional and higher editions.
Microsoft Access is just one part of Microsoft’s overall data
management product strategy.
It stores data in its own format based on the Access Jet
Database Engine.
Like relational databases, Microsoft Access also allows you to
link related information easily. For example, customer and
order data. However, Access 2013 also complements other
database products because it has several powerful
connectivity features.
It can also import or link directly to data stored in other
applications and databases.
As its name implies, Access can work directly with data from
other sources, including many popular PC database
programs, with many SQL (Structured Query Language)
databases on the desktop, on servers, on minicomputers, or
on mainframes, and with data stored on Internet or intranet
web servers.
Access can also understand and use a wide variety of other
data formats, including many other database file structures.
You can export data to and import data from word processing
files, spreadsheets, or database files directly.
Access can work with most popular databases that support
the Open Database Connectivity (ODBC) standard, including
SQL Server, Oracle, and DB2.
Software developers can use Microsoft Access to develop
application software.
File Processing
In Computer Science, File Processing System (FPS) is a way of storing,
retrieving and manipulating data which is present in various files.
Files are used to store various documents. All files are grouped based on
their categories. The file names are very related to each other and arranged
properly to easily access the files. In file processing system, if one needs to
insert, delete, modify, store or update data, one must know the entire
hierarchy of the files.
3|Page
Pre lab writing assignment
Fill in the blanks 1. What is RDBM _______________________
2. MS Access is a ___________________
3. In database data stored in a _____________ form
4. MongoDB is a type of ______________ database
5. Flicker, Pinterest and Wikipedia is using __________ for storing and
retrieving data.
4|Page
Lab 1
Lab 1.1
Installing MS Access
for database
Log in to Office 365. You can get to login page by clicking the Email
tab or the Office 365 tab in AccessBCC or by going to:
http://office365.bristolcc.edu.
Sign in with your student email and password.
AccessBccUserName@bristolcc.edu
Once you have signed in, click on Office 365 in the upper left-hand
corner to navigate to the home page.
Uncheck the Bing and MSN browser setting options. Click on Install
now.
Just a few more steps to install. Once the setup file is downloaded,
click Run, Say Yes and stay online until the installation is complete.
5|Page
(Click to close this window)
Download and Run the installer (Browser Examples):
Wait while the installer loads…
Wait while Office Installs…
6|Page
Launch an Office application like Word, Excel, or Powerpoint and
click Accept to agree to the license terms
Click Sign in to get the most out of Office on the top right to register
your software.
Enter your email address to sign in and click Next. NOTE -- Signing
into your Office 365 account is required to register your software!
7|Page
The Installation is Complete! Look for Access 2016 under installed
programs and Click to run
8|Page
Lab 1.2 Lab Tasks
1. Create a Database with your name and make a table by name Friend List. The field should
be ID, First Name, Last Name, Phone Number, Email Address, Picture. And then add
records minimum 5.
Screenshot of database should be paste here
2. Define the Terms:
Queries
Forms
Reports
3. Modify the code to create a txt file. The file name should be your name. Add all the data to
the file (ID, First Name, Last Name, Phone Number, Email Address). Now you need to read
the email address in the file exist.
4. #include <iostream>
5. #include <fstream>
6. using namespace std;
7. int main() {
8. string ID, first_name, last_name, phone_number,
email_address;
9. fstream username;
10. username.open("my_file", ios::out);
11. if (!username) {
12. cout << "File not created!";
13. }
14. else {
15. cout << "File created successfully! Now Enter
the Fields to insert in file";
16. cout << "ID: "; cin>>ID;
17. cout << "First Name: "; cin>>first_name;
18. cout << "Last Name: "; cin>>last_name;
19. cout << "Phone Number: "; cin>>phone_number;
20. cout << "Email Address: "; cin>>email_address;
21. username.close();
22. }
23. return 0;
24. }
9|Page
25.
10 | P a g e
