Help MS access Data base pa help po

[Phc - Jemz]

1. Create a database using MS Access.
2. There must be two tables:
First Table: Patient Records
Second Table: Medicines
3. Establish a relationship with two tables. The patient will have a record of its medicines.

4. Create one form with buttons to add details and two tables.

5. Think and put any field name as well as medicines.


Pa help po mga lods kung paano gamitin yung access, Nanuod na kami sa YT pero d namin magawa gawa kasi yung instructions d tugma sa sinesearch namin

 

[🤖]

Sure, I can help you with creating a database using MS Access and setting up the tables, relationships, and form as you described. Here is a step-by-step guide to achieve what you need:

Step 1: Creating a Database in MS Access
1. Open Microsoft Access.
2. Click on "Blank Database" and give your database a name.
3. Save the database in your desired location.

Step 2: Creating Tables
1. Create the "Patient Records" table:
- Open your database and click on "Table Design."
- Add fields such as Patient ID (AutoNumber), Patient Name (Text), Age (Number), Gender (Text), Diagnosis (Text), etc.
- Set Patient ID as the primary key.

2. Create the "Medicines" table:
- Open your database and click on "Table Design."
- Add fields such as Medicine ID (AutoNumber), Medicine Name (Text), Dosage (Text), Price (Currency), etc.
- Set Medicine ID as the primary key.

Step 3: Establishing Relationship
1. Go to the Database Tools tab and click on Relationships.
2. Add both tables to the Relationships window.
3. Drag the Patient ID field from the Patient Records table to the Patient ID field in the Medicines table to establish a relationship.

Step 4: Creating a Form with Buttons
1. Go to the Create tab and click on Form Wizard.
2. Select the tables you want to include in the form (Patient Records and Medicines).
3. Choose the fields you want to display on the form.
4. Select the layout and style for the form.
5. Include buttons on the form for adding details.

Step 5: Field Names for Patient Records and Medicines
Here are some example field names you can use:

• Patient Records: Patient ID, Patient Name, Age, Gender, Diagnosis
• Medicines: Medicine ID, Medicine Name, Dosage, Price

I hope this guide helps you create the database you need in MS Access. Let me know if you need further assistance or have any specific questions!

 

[LocalHost 8080]

create ka lang ng database boss sa access.

tapos lagyan mo ng 2 table

eto si bot hahaha

 

[Phc - Jemz]

create ka lang ng database boss sa access.

tapos lagyan mo ng 2 table

eto si bot hahaha

2 table boss? Yung unang table ba is yung Patient record? Tapos Table yung table 2 yun yung Medicine?

 

[LocalHost 8080]

2 table boss? Yung unang table ba is yung Patient record? Tapos Table yung table 2 yun yung Medicine?

nakuha mo hahah

 

[Phc - Jemz]

nakuha mo hahah

Yung relationship naman boss yung hindi ko ma gets

 

[LocalHost 8080]

table structure na yan.

example

table1
id -> PK
med_id -> FK

table2
med_id -> PK

gets ?

dapat si table 1 and 2 ay may same column name para mmeron kang relatshinship

relationship

 

[Phc - Jemz]

table structure na yan.

example

table1
id -> PK
med_id -> FK

table2
med_id -> PK

gets ?

dapat si table 1 and 2 ay may same column name para mmeron kang relatshinship

relationship

Ahh gets ko na, kaya pala ayaw mag work kasi d sila same ng name gabito kasi ginawa ko boss
Patient Records
Medecine

 

[LocalHost 8080]

Ahh gets ko na, kaya pala ayaw mag work kasi d sila same ng name gabito kasi ginawa ko boss
Patient Records
Medecine

practice mo muna yan tapos kapag gamay mo na. practice mo si NORMALIZATION or NORMALIZE TABLE

search mo lang kung ano yan pero para mas secure lang DB Mo hehe

 

[Phc - Jemz]

practice mo muna yan tapos kapag gamay mo na. practice mo si NORMALIZATION or NORMALIZE TABLE

search mo lang kung ano yan pero para mas secure lang DB Mo hehe

Thanks boss, Pag dko pa ma gets yung iba mention nalang po ulit kita d2 boss, Salamat sa Info boss

 

[LocalHost 8080]

Thanks boss, Pag dko pa ma gets yung iba mention nalang po ulit kita d2 boss, Salamat sa Info boss

online ako next week mon-thur. 6:30-5pm. HAHAHA

 

[Phc - Jemz]

online ako next week mon-thur. 6:30-5pm. HAHAHA

HAHAH sge boss