Direction: Using MS Access, Make a Database with 2 tables that are related to each other and input dat for each fleld for at least 5 entry or record. Create a relationship between 2 tables and make a least 1 query. Make a report for the said query. Make a screenshot for each said activity and submit it. Database Filename should be your Full Name. Example: Table1 Name: Doctor Table2 Name: Patient 1. You should put data into their fields as many as you can with at least 5 data entry. 2. Their ID number should have a fomat like this example (TI-COLL-000), make your own format of ID number. 3. Appled the Input Mask in 1 of the flelds.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Direction:
Using MS Access, Make a Database with 2 tables that are related to each other and input data
for each fleld for at least 5 entry or record. Create a relationship between 2 tables and make at
least 1 query. Make a report for the said query.
Make a screenshot for each said activity and submit it.
Datakase Filename should be your Full Name.
Example: Table1 Name: Doctor
Table2 Name: Patient
1. You should put data into their fields as many as you can with at least 5 data
entry.
2. Their ID number should have a fomat like this example (TI-COLL-000), make
your own format of ID number.
3. Appled the Input Mask in 1 of the flelds.
Transcribed Image Text:Direction: Using MS Access, Make a Database with 2 tables that are related to each other and input data for each fleld for at least 5 entry or record. Create a relationship between 2 tables and make at least 1 query. Make a report for the said query. Make a screenshot for each said activity and submit it. Datakase Filename should be your Full Name. Example: Table1 Name: Doctor Table2 Name: Patient 1. You should put data into their fields as many as you can with at least 5 data entry. 2. Their ID number should have a fomat like this example (TI-COLL-000), make your own format of ID number. 3. Appled the Input Mask in 1 of the flelds.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY