Tuesday, 21 February 2012

Friday, 10 February 2012

My Own Thought TagLine

" 'Who am i ?' that I know"
                                         -Ronak Panchal

Wednesday, 8 February 2012

Wednesday, 28 December 2011

Wild Card Character MS Access

http://office.microsoft.com/en-us/access-help/access-wildcard-character-reference-HP005188185.aspx

Thursday, 8 December 2011

MS Access 2003 Material

http://www.gslis.utexas.edu/technology/tutorials/office/access03/access2003.pdf

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)