Database Management MS Access Ke Saath: Step-by-Step Guide

Microsoft Access: Complete Course Notes (Part 1)

1. Introduction to Microsoft Access

Microsoft Access ek Database Management System (DBMS) hai. Ye Excel se zyada powerfull hota hai kyunki ismein hum hazaron logon ka record link (Relationship) ke zariye manage kar sakte hain.

Access ke 4 Aham Hisse (Pillars):

1. Tables (Buniyad): Access mein sab se pehla kaam Table banana hota hai. Tables mein hamara sara data mehfooz (save) hota hai. Har Table mein Rows aur Columns hote hain.

o Misal: Student ka Naam, Roll Number, aur Course.

2. Queries (Sawalaat): Jab hamare paas bahut zyada data ho jaye aur humein usmein se kuch khaas dhundna ho, to hum Query chalate hain.

o Misal: "Sirf un students ki list dikhao jo Computer Course kar rahe hain."

3. Forms (Interface): Table mein direct data entry karna thoda mushkil lagta hai. Forms humein ek saaf-suthra box bana kar dete hain jahan hum asani se typing kar sakte hain. Ye dekhne mein software ki tarah lagta hai.

4. Reports (Final Result): Jab humein data print nikalna ho ya result taiyar karna ho, to hum Report banate hain. Isse hamara data professional lagta hai.

Pehla Practical Step: Table Kaise Banayein?

Table banane ke liye humein do cheezon ka pata hona chahiye:

· Field Name: Column ka naam (Jaise: Student_Name).

· Data Type: Us column mein kya likha jayega (Jaise: Text, Number, ya Date).

2. Table Design & Data Types

Table banane ke liye Design View ka istemal hota hai. Yahan hum Field Name aur Data Type set karte hain.

Example 1: Student Information Table

Ye table students ka buniyadi record rakhne ke liye hai.

Student_ID: AutoNumber (Isse har student ko ek unique number mil jata hai).
Student_Name: Short Text (Naam likhne ke liye).
Date_of_Birth: Date/Time (Tareekh-e-paisaish ke liye).
Contact_Number: Short Text ya Number (Phone number ke liye).
Address: Long Text (Bada pata likhne ke liye).

Example 2: Course Details Table

Ye table institute mein chalne wale courses ki maloomat ke liye hai.

Course_ID: AutoNumber (Har course ka apna code).
Course_Name: Short Text (Jaise: CIT, Graphics, Web Design).
Course_Duration: Short Text (Jaise: 3 Months, 6 Months).
Course_Fee: Currency (Fees likhne ke liye ye best data type hai).

Example 3: Employee/Teacher Record Table

Ye table aapke staff ya teacher’s ka record rakhne ke liye hai.

Teacher_ID: AutoNumber.
Teacher_Name: Short Text.
Qualification: Short Text (Jaise: Graduation, Masters).
Joining_Date: Date/Time.
Salary: Currency.
Active_Status: Yes/No (Kya teacher abhi kaam kar rahe hain ya nahi?).

Field Name	Data Type	Purpose (Kyun?)
ID	AutoNumber	Unique identity ke liye.
Name	Short Text	Naam likhne ke liye.
Fee	Currency	Paiso ka record rakhne ke liye.
Date	Date/Time	Admission date ke liye.
Status	Yes/No	Checkbox lagane ke liye.

Data Types Kya Hain aur Kyun Use Hoti Hain?

"Data Type ka matlab hai computer ko ye batana ke hum is column mein kya likhne wale hain. Agar hum sahi data type nahi chunenge, to computer calculations ya searching sahi se nahi kar payega."

MS Access: Data Types Mukammal Notes

1. Short Text:

Kyun: Chote naam, addresses, ya mobile numbers likhne ke liye.
Limit: Ismein aap 255 characters tak likh sakte hain.
Misal: Student Name, Father Name, Mobile Number.

2. Long Text:

Kyun: Jab aapko lambi tafseel (details) ya koi lamba note likhna ho.
Limit: Ismein 65,535 characters tak ka lamba data aa sakta hai.
Misal: Home Address, Course Remarks, Medical History.

3. Number:

Kyun: Aisi cheezon ke liye jinhein hum jama (plus) ya minus karna chahte hon, jaise Marks ya Age.
Limit: Ye sirf numbers accept karta hai (no alphabets).
Misal: Obtained Marks, Age, Total Students.

4. Date/Time:

Kyun: Tareekh (Date) ya waqt likhne ke liye. Isse computer khud calendar manage kar leta hai.
Misal: Admission Date, Date of Birth.

5. Currency:

Kyun: Paise (Money) ka record rakhne ke liye. Iske saath khud-ba-khud Rupees (Rs/$) ka sign aa jata hai.
Misal: Course Fees, Monthly Salary, Registration Fee.

6. AutoNumber:

Kyun: Ye sab se mazedaar hai! Computer khud hi har naye record ko 1, 2, 3... karke ek number de deta hai.
Limit: Isay aap khud badal nahi sakte (Unique Number).
Misal: Roll Number, Student ID.

7. Yes/No:

Kyun: Jab sirf do hi options hon (Haan ya Naa). Ismein table mein ek checkbox ban jata hai.
Misal: Fees_Paid?, Is_Regular?, Document_Submitted?.

8. Hyperlink:

Kyun: Kisi bhi website ka address ya email save karne ke liye jis par click karke direct wo page khul jaye.
Misal: Student Email, Facebook Profile Link.

9. Attachment:

Kyun: Database ke andar hi kisi ki tasveer ya file save karne ke liye.
Misal: Student Photo, CNIC Copy (PDF).

Students ke liye Tip:

"Hamesha yaad rakhein, agar aapne column mein 'Number' select kiya hai aur aap wahan apna naam likhenge, to Access Error de dega. Isliye pehle se sochna zaroori hai ke column mein kya aayega."

3. Primary Key (Unique ID)

"Primary Key table mein kisi ek aisi field ko kehte hain jo har record ko doosre se alag banati hai."

Rule: Ismein data repeat nahi ho sakta (No Duplicates).
Example: Student Roll Number ya CNIC Number.

4. Queries (The Brain)

Query ka matlab hai "Filter Lagana".

Kaise Karein: Query Design mein jayein -> Table add karein -> Criteria mein apni shart likhein.
Example: Agar aapne Fee_Status ke niche "Pending" likha, to sirf wahi bacche nazar ayenge jinki fees rehti hai.

5. Student Activity: "Detective Query"

Task: Library Management Table banayein aur niche di gayi Queries chalaein:

Un kitabon ki list nikaalein jin ki price 500 se zyada ho.
Un kitabon ko filter karein jin ka status "Available" hai.

Book_ID	Book_Title	Author	Category	Price	Status
1	Database Basics	Ahmed Ali	Education	450	Available
2	Graphic Design Pro	Sara Khan	Arts	1200	Issued
3	Web Development	Bilal Sheikh	IT	850	Available
4	Urdu Poetry	Faiz Ahmed	Literature	300	Available
5	Master MS Excel	Farzana	Software	550	Available
6	History of Pakistan	J. Qureshi	History	400	Issued
7	Freelancing Guide	Hassan Raza	Career	700	Available
8	Digital Marketing	Amna Zee	Business	950	Available
9	Kids Stories	Mehak Gill	Children	250	Available
10	Advanced Access	K. Malik	IT	1100	Issued

Microsoft Access: Course Notes (Part 2)

6. Forms: The User Interface

"Form ka matlab hai ek aisa 'Box' ya 'Window' jahan se hum table mein data enter karte hain. Ye bilkul waisa hi lagta hai jaise hum kisi website par apna account banate hain."

Forms Kyun Zaruri Hain?

Easy Entry: Table ke andar typing karna mushkil hota hai, Form mein asani se kaam hota hai.
Professional Look: Isse database ek software ki tarah nazar aata hai.
Security: User ko main table dikhaye baghair hum data entry karwa sakte hain.

7. Reports: The Final Result

"Jab hamein apna data print karna ho ya kisi manager ko dikhana ho, to hum Report banate hain. Report data ko ek professional aur saaf-suthre layout mein convert kar deti hai."

Reports ki Khasiyat:

Ismein hum Sum ya Total nikaal sakte hain (Maslan: Total Fees kitni jama hui?).
Isay PDF mein save kiya ja sakta hai ya print nikaala ja sakta hai.

8. Final Student Project: "Mini Management System"

(Ye activity students ko Microsoft Access ka expert bana degi!)

Scenario: Apne Institute ke liye ek chota sa software taiyar karna hai.

Step 1: Table Design (Dhancha)

Niche di gayi fields ke sath ek table banayein:

ID (AutoNumber) - Primary Key
Student_Name (Short Text)
Course (Short Text)
Admission_Fee (Currency)
Is_Regular (Yes/No)

Step 2: Form Create (Entry Interface)

Create tab par jayein aur Form Wizard ka istemal karte hue ek khoobsurat Form banayein.
Is Form ke zariye kam az kam 5 naye students ka data enter karein.

Step 3: Query (Filter)

Ek aisi Query banayein jo sirf un bacchon ko dikhaye jinhone 1000 se zyada fees di ho.

Step 4: Report (Printing)

Ek final Report taiyar karein jismein sab students ke naam aur unki fees nazar aaye. Niche Total Fee ka formula lagayein.

Microsoft Access: Mazeed 2 Practice Activities

In activities ka maqsad students ki logic ko mazboot karna hai:

Activity 1: "Inventory Management System" (Dukan ka Record)

Students ko kahein ke wo ek aisi database banayein jahan kisi dukan ka saaman manage ho sake.

Table: Item_ID (Primary Key), Item_Name, Category, Quantity_In_Stock (Number), Unit_Price (Currency).

Item_ID (PK)	Item_Name	Category	Quantity_In_Stock	Unit_Price
101	Wireless Mouse	Electronics	25	1500
102	Gel Pen (Blue)	Stationery	150	50
103	A4 Paper Rim	Stationery	40	1200
104	USB Drive 32GB	Electronics	15	850
105	LED Desk Lamp	Home Office	8	2200
106	Office Chair	Furniture	5	8500
107	Stapler HD-45	Stationery	20	450
108	Keyboard K120	Electronics	12	1800
109	Water Bottle	Lifestyle	30	650
110	Notebook (Spiral)	Stationery	60	350

Challenge: Ek Query banayein jo sirf un items ko dikhaye jo khatam hone wale hain (Stock less than 5).
Form: Ek professional Form design karein.

Activity 2: "Hospital Patient Record"

Table: Patient_ID, Patient_Name, Disease, Doctor_Name, Admit_Date.

Patient_ID (PK)	Patient_Name	Disease	Doctor_Name	Admit_Date
P-001	Ali Ahmed	Fever	Dr. Asim	01-May-2026
P-002	Sara Khan	Allergy	Dr. Mehak	03-May-2026
P-003	Bilal Yousuf	Fracture	Dr. Irfan	05-May-2026
P-004	Zainab Bibi	Infection	Dr. Asim	08-May-2026
P-005	Usman Ghani	Flu	Dr. Mehak	10-May-2026
P-006	Maryam Ijaz	Headache	Dr. Irfan	12-May-2026

Challenge: Ek Report banayein jismein Doctor ke naam ke hisab se patients ki grouping ho (Group by Doctor). Isse students ko samajh aayega ke data ko organize kaise karte hain.

Challenge: Doctor-Wise Patient Grouping Report

Is activity mein students seekhenge ke kaise 100 mareezon ka data bhi ho, to usey Doctors ke naam ke mutabiq alag alag sections mein kaise baanta jata hai.

Step-by-Step Guide for Students:

Report Wizard ka Istemal: Sab se pehle Create tab mein ja kar Report Wizard par click karein.
Fields Choose Karein: Patients_Record table se tamam fields (Patient_Name, Disease, Doctor_Name) ko select karein.
Grouping Level (Sab se Aham Step): Jab Wizard aap se pooche "Do you want to add any grouping levels?", to wahan Doctor_Name ko select karke > button dabayein.
- Isse Doctor ka naam heading ban jayega aur uske neeche uske mareezon ki list aayegi.
Sorting: Agar zaroorat ho to mareezon ke naam ko Ascending order mein set karein.
Layout: Stepped ya Outline layout select karein taake grouping saaf nazar aaye.

Report ka Visual Preview (Example):

Jab report tayyar hogi, to wo kuch is tarah nazar aayegi:

Doctor Name: Dr. Asim

Ali Ahmed — Fever — 01-May-2026
Zainab Bibi — Infection — 08-May-2026

Doctor Name: Dr. Irfan

Bilal Yousuf — Fracture — 05-May-2026
Maryam Ijaz — Headache — 12-May-2026

Doctor Name: Dr. Mehak

Sara Khan — Allergy — 03-May-2026
Usman Ghani — Flu — 10-May-2026

Final Home Assignment: "Personal Expense Tracker" (Ghar ka Kharcha)

Bacchon ko kahein ke wo apne ghar ke mahana kharche (Monthly Expenses) ka aik chota sa system banayein. Iske liye unhein ye 3 kaam karne honge:

1. Table Design (Data Planning)

Table ka naam rakhein: Monthly_Expenses Fields ye honi chahiye:

· Expense_ID (AutoNumber & Primary Key)

· Item_Name (Short Text) - Jaise: Bijli ka Bill, Rashan, Petrol.

· Category (Short Text) - Jaise: Bills, Food, Travel.

· Amount (Currency) - Kitne paise kharch huay.

· Expense_Date (Date/Time) - Kis din kharch huay.

2. Form Creation (The Interface)

Ghar ja kar wo aik Form banayein jise wo apne mobile ya laptop par dekh kar rozana ka kharcha enter kar sakein. Form ka title hona chahiye: "Mera Rozana ka Kharcha".

3. The Query Challenge (The Filter)

Aik Query banayein jo sirf un kharchon ko dikhaye jo 1000 se zyada hain. Isse pata chalega ke unka paisa sab se zyada kahan ja raha hai.

Microsoft Access Job Search Platforms

1. Remotely (Puri Duniya ke liye)

In websites par dollar mein kamai hoti hai aur kaam ghar se karna hota hai:

· Upwork: Ye dunya ka sab se bada freelancing platform hai. Students wahan "MS Access Developer" ya "Database Specialist" search kar sakte hain.

· Fiverr: Jaisa ke humne discuss kiya, yahan wo apne "Gigs" bana kar puri duniya se orders le sakte hain.

· Freelancer.com: Yahan database projects ke liye "Contests" aur "Bidding" hoti hai.

2. Physical & Remote (Pakistan & Karachi ke liye)

Karachi mein boht saari choti aur badi companies (trading, schools, hospitals) ko database manage karne ke liye logon ki zaroorat hoti hai:

· Rozee.pk: Pakistan ki sab se badi job site hai. Yahan "Data Entry Specialist" ya "Database Administrator" search karein.

· Indeed Pakistan: Karachi ki local jobs dhoondne ke liye ye behtareen hai. Search bar mein likhein: "Microsoft Access Jobs in Karachi".

· LinkedIn: Ye aik professional social media hai. Students apni profile banayein aur Karachi ki IT companies ko follow karein. LinkedIn par remote jobs ka alag se filter bhi hota hai.

· Mustakbil.com: Pakistan mein office jobs ke liye ye bhi kafi purana aur bharosa-mand portal hai.

Students ke liye apply karne ki 3 Tips:

1. Choti Companies Target Karein: Karachi mein jo log kapre ka karobar (Textiles) ya trading karte hain, unhein aksar Microsoft Access mein inventory manage karne ke liye bandon ki zaroorat hoti hai.

2. Portfolio Dikhayein: Sirf CV na bhejein, balki jo activities (Library System, Expense Tracker) unhone class mein ki hain, unki screenshots ya file saath attach karein taake employer ko unka kaam nazar aaye.

3. Keywords ka Istemal: Apply karte waqt apne hunar mein ye alfaaz zaroor likhein: Data Integrity, Relational Database, SQL Queries, and Customized Forms.

Karachi mein rehte hue unke liye Saddar, I.I. Chundrigar Road, aur Shahrah-e-Faisal par maujood offices mein kafi scope hai.

How to create account on fiverr in 2026

https://www.youtube.com/watch?v=_i9ucN1ZMwE

How To Setup a Seller Profile On Fiverr 2024 | Fiverr 2.0 Complete Course

https://www.youtube.com/watch?v=SJSutEEYXmc

Fiverr Gig Template (For MS Access Experts)

Gig Title: I will design a professional Microsoft Access Database for your business.

Gig Description (About This Gig): "Hi! Are you looking for someone to organize your messy data into a professional system? You are at the right place!

I am a Microsoft Office expert and I can create a custom MS Access Database tailored to your needs.

What I offer:

Custom Table design with proper Data Types.
Advanced Queries to filter your data easily.
User-friendly Forms for easy data entry.
Professional Reports for printing and analysis.
Database Relationships for better data management.

Why hire me?

Fast delivery.
Accurate and clean work.
100% satisfaction guarantee.

Please message me before placing an order so we can discuss your project requirements. Looking forward to working with you!"

Fiverr par Kamyabi ke liye 3 Tips (Students ke liye):

Professional Thumbnail: Apne Gig ki tasveer (Image) bohat saaf banayein. Us par bade huroof mein likha ho: "MS ACCESS EXPERT".
Stay Online: Fiverr ki mobile app download karein aur zyada waqt online rahein. Jo seller jaldi jawab deta hai, usay order jaldi milta hai.
Low Price at Start: Shuruat mein apni qeemat kam rakhein (e.g., $5 ya $10) taake log aap par bharosa karein aur reviews mil sakein.

Fiverr Gig: Sahi Category aur Tags ka Intekhab

Jab students Gig banayenge, to unse pucha jayega ke unka kaam kis category mein aata hai. Agar wo galat category chunenge, to unka Gig ghum ho jayega.

1. Sahi Category (Important):

· Main Category: Data

· Sub-Category: Databases

· Service Type: Database Design ya Database Development

2. Search Tags (Keyword Search):

Ye wo 5 alfaaz hain jo log Fiverr par search karte hain. Students ko yehi 5 tags lagane chahiye:

1. MS Access

2. Database Design

3. Microsoft Access

4. Data Entry

5. VBA Access (Agar wo thoda advanced programming jaante hon).

Gig Packages (Qeemat aur Kaam)

Fiverr par teen tarah ke packages hote hain (Basic, Standard, Premium). Students ise is tarah set kar sakte hain:

· Basic ($5 - $10): "Main aapka simple 1-Table database aur Form banaoonga." (Delivery: 1 Day)

· Standard ($20 - $30): "Main 3 Tables, Relationships aur 2 Reports banaoonga." (Delivery: 2 Days)

· Premium ($50+): "Mukammal Business System (Tables, Forms, Queries, aur Reports)." (Delivery: 4-5 Days)

Ek Aham Baat (Scam se Bachna):

Fiverr par kabhi bhi kisi ko Fiverr se bahar paise na dein aur na hi apna personal WhatsApp/Phone number share karein. Fiverr ki policy hai ke saari baat aur payment Fiverr ke andar hi honi chahiye, warna account block ho sakta hai.

========================================================================================

MS Access – Behance Project Idea

MS Access par kaam karna aik technical skill hai, aur Behance par isay dikhanay ka tariqa thoda mukhtalif hota hai kyunkay ye "visual" se zyada "logical" kaam hai. Students ko chahiye kay wo apnay database projects ko aik Case Study ki tarhan pesh karain.

MS Access kay liye ye cheezain upload kar saktay hain:

1. User-Friendly Forms (UI Design)

MS Access mein "Forms" front-end ka kaam kartay hain. Students ne jo interface banaya hai, usay dikhayen:

Navigation Dashboard (Switchboards): Aik main menu jahan se poora software control hota ho.
Data Entry Forms: Aesthetic aur saaf-suthray forms jis mein dropdown menus (Combo Boxes) aur buttons hon.

2. Professional Reports

Reports hi Access ka asal output hoti hain. Behance par inke prints ya PDF views upload karain:

Invoice Generation: Access se generate honay wali invoice.
Summary Reports: Monthly sales report ya student attendance summary (jis mein Grouping aur Totals ka istemal ho).

3. Search & Query Logic

Ye technical skill dikhanay ka tareeqa hai:

Search Filters: Aik aisi screen dikhayen jahan user koi naam ya date likhay aur niche result aa jaye.
Calculated Fields: Dikhaen kay kis tarhan Access khud ba khud calculations (Tax, Discount, ya Balance) kar raha hai.

Behance Layout Idea (Case Study Format):

Aik project ka page is tarhan banayen:

Project Title: Maslan "Pharmacy Management System" ya "School Library Database."
The Problem: Aik line likhain kay "Is database se pehlay kaam manually hota tha jo mushkil tha."
The Solution: Dikhaen kay Access ne isay kaisay asaan kiya.
Key Features: Bullet points mein likhain (e.g., Automatic Inventory Tracking, One-click Invoice generation).
The Visuals: Forms, Reports aur Relationships kay screenshots ko achay background colors kay saath set karain.

Behance Project Case Study Layout

1. Project Title

"Smart Pharmacy Management System" (Subtitle: A Custom Database Solution for Local Pharmacies)

2. The Problem

"Is database se pehlay, pharmacy ka sara record registers par manually likha jata tha, jis ki wajah se expiry dates ka pata lagana aur stock maintain karna intehai mushkil aur waqt talab kaam tha."

3. The Solution

"Microsoft Access ka istemal karte hue, hum ne ek aisa digital system banaya jo tamam manual mehnat ko khatam kar deta hai. Ab sirf ek click par stock update hota hai aur expiry alert mil jata hai, jis se pharmacy ka kaam 80% zyada tez aur ghaltiyon se pak ho gaya hai."

4. Key Features

Automatic Inventory Tracking: Stock khatam hone se pehle system khud hi alert deta hai.
One-Click Invoice Generation: Mareezon ke liye fori bill tayyar karne ki sahalat.
Expiry Date Alerts: Expire hone wali dawaiyon ki alag list jo nuqsan se bachati hai.
Daily Sales Report: Pure din ki kamayi ka mukammal aur saaf hisab kitab.

5. The Visuals (Layout Guide)

Aap jab screenshots lagayengi, to unhe directly mat rakhein. Adobe Illustrator ya Canva mein ek acha sa background (maslan Light Blue ya Gray) lekar us par in screenshots ko 'Shadow' ke saath set karein:

Section A: Database ki Relationships ka screen (taake pata chale system kitna mazboot hai).
Section B: Data Entry Form (jo dekhne mein saaf aur asaan ho).
Section C: Final Monthly Sales Report (jo professional dikhayi de).

6. Pro Tip

"Hamesha project ke aakhir mein ek 'Conclusion' ya 'Client Feedback' ki farzi line likhein. Isse dekhne wale ko lagta hai ke aap ne waqayi kisi real client ka masla hal kiya hai, jo freelancing mein order milne ke chances barha deta hai."

MS Access Seekhein: Data Entry se Freelancing tak ka Safar