Exercise1
Create a new database file "Access-Visit" then perform the following:
1. Create table with name "visit Details" contains the following fields:
• VisitNo: Number and make it as a Primary Key
• VisitType: Short Text
• TreatmentCode: Number
• Treatment Price: Currency
• TreatmentDate: Date/Time
2. Insert the first record in the table
Visit Details
Visit No Visit Type Treatment Code Treatment Price Treatment Date Add New Field
1 HOSPITAL 301 $75.00 2/4/3013
2 INJURY 500 $57.00 6/1/2014
3 PHYSICAL 100 $10.00 5/7/2015
Exercise 2
Create a new database file "Access-Student" then perform the following:
1. Create table with name "Student" contains the following fields:
• SID: data type is number and make it as a primary key
• Sname: data type is short text
• Joindate: data type is date/time
• Payment: data type is currency
• Gender: data type is yes/no
2. Insert the second record in the table
*
student
SID Sname Joindate Payment Gender Click to Add
17020 ahmed 1/9/2017 $10,000.00 ?
17021 rashed 1/1/2017 $12,000.00 ?
1801 muna 1/1/2018 $15,000.00 ?