MS Access Assignment Sem -II(BCA)

Introduction MS Access 2003 

Above Link is used for Introduction of MS Access 2003

MS Access Assignment

Submitted Date is 15/12/2011

1. How to create Table in Ms Access?
2. What is MS Access?
3. What is Object?
4. What is Data?
5. What is Information?
6. What is Difference between Data and Information?
7. Explain All Data Type in Ms Access?
8. What is the extension of Ms Access?
9. What is Database?
10. What is Field/Attribute/Column?
11. What is Row/Tuple?
12. What is Column?
13. What is Record?
14. What is Table?
15. What is Schema?
16. What is File?
17. What is Instance?
18. What is Database Management System?
19. Create Following Table and Insert at least 10 appropriate records:

1.      Product (ProductId,Name,Price,Qty,TotalAmount)

2.      Student_Master(Std_Id,SName,Address,DateOfBirth,ContactNo)

3.      Employee_Master(EmpId,EmpName,DoJ,Salary,Designation,Address)

4.      Department(DeptNo,DeptName)

5.      Book_Master(BookId,BookName,Author,Publisher,ISBN)

6.      Medice_Master(Med_Id,Med_Name,Mfg_Company,Expiry_Date,Price)

7.      Customer_master(Cust_ID,Cust_Name,Address,ContactNo,EmailID,IDProof)

8.      Room_Master(RoomId,RoomType,Rate)