Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

GE-161L

Laboratory 09
Introduction to Microsoft ® Access - I

Version: 1
...
0

Release Date: 12-03-2022

Department of Information Technology
University of the Punjab

GE-161L Introduction to ICT

FALL 2021

Contents:











Learning Objectives
Required Resources
General Instructions
Background and Overview
o What is a Database?
o Microsoft ® Access
Activities
o Pre-Lab Activity
 Open Microsoft ® Access
 Using Navigation Pane
 Change Views
 Creating Database
 Creating Table
 Record Navigation
 Task 01: Adding Tables to Database
o In-Lab Activity
 Add Record
 Delete Record
 Primary Key
 Find & Replace data
 Sort Data
 Filter Data
 Tables Relationship
 Input Masks
 Create Forms
 Apply theme
 Create Reports
 Apply theme
 Task 01: Teacher-Student Relation
 Task 02: Creating Forms & Reports
o Post-Lab Activity
 Task 01: Customers Record
Submissions
Evaluations Metric
References and Additional Material
Lab Time and Activity Simulation Log

Laboratory 09 – Microsoft ® Access - I

Page 2 of 27

GE-161L Introduction to ICT

FALL 2021

Learning Objectives:






Familiarization with Microsoft ® Access Environment
Creating Database in Microsoft ® Access
Creating Tables in Microsoft ® Access
Creating Forms in Microsoft ® Access
Creating Reports in Microsoft ® Access

Resources Required:



Computer / Laptop
Microsoft ® Access

General Instructions:



This is an individual lab, you are NOT allowed to discuss your solution with your colleagues,
not even allowed to ask how is he/she doing, this may result into negative marking
...

Your TAs will be available in the lab for your help
...


Teachers:

Course Instructor

Prof
...
Syed Waqar ul Qounain
Usman Ali

Teacher Assistants

Saad Rahman
Mahreen Asama

Laboratory 09 – Microsoft ® Access - I

Page 3 of 27

GE-161L Introduction to ICT

FALL 2021

Background and Overview:
What Is a Database?
People often need to retrieve specific data rapidly while on the job
...
The registrar at a university may have to look up a student’s grade point average or rapidly
determine if the student has any outstanding fees before processing his or her class registration
...
The type of software used for such tasks is a database management system
...
The most common type of database used with personal
computers today is a relational database
...

A database is a collection of related data that is stored on a computer and organized in a manner that
enables information to be retrieved as needed
...
Typically data in a database is organized into fields, records, and
files
...
A record (today more commonly called a row) is a
collection of related fields, for example, the ID number, name, and address
...

Microsoft ® Access stores data in its own format based on the Access Database Engine (formerly Jet
Database Engine)
...


Laboratory 09 – Microsoft ® Access - I

Page 4 of 27

GE-161L Introduction to ICT

FALL 2021

Activities:
Pre-Lab Activities:
Open Microsoft ® Access:


Type “Access” in the search bar

Fig
...
2 (Open Blank Database)
Using Navigation Pane:

Fig
...
The table is displayed in Design View

Fig
...

Creating a Database using a Template:


On the top of the startup screen window, in the “Search for online templates” search box,
type “personal”, and then press “Enter

Fig
...
6 (Database Templates)


Click the “Create button” at the bottom of the preview pane

Fig
...
8 (Blank Database)




In the “File Name” box, type “Database”
If you want to save the file in a location other than the one shown beneath the File Name box,
click the “folder icon” to the right of the File Name box and browse to a different location
Click “Create button” to create the blank database
...
9 (Blank Database)
Creating a Table:



On the “Create” tab in the “Templates” group, click the “Application Parts” button to
display the gallery
In the “Quick Start” section of the gallery, click “Comments”

Laboratory 09 – Microsoft ® Access - I

Page 9 of 27

GE-161L Introduction to ICT

FALL 2021

Fig
...
11 (Creating Table)



In the “Create Relationship” dialog box that appears, select the “There is no relationship”
option button
Click “Create”

Laboratory 09 – Microsoft ® Access - I

Page 10 of 27

GE-161L Introduction to ICT

FALL 2021

Fig
...


Fig
...
14 (Navigation buttons)







Click the “First record” button
...
The selection moves t

---