Name : Bazliah Agvyan D

Nrp : 2103181028

kelas : 2 D3 IT A

 

 

 

 

 

 

 

 

step :

  1. Open microsoft access
  2. Click an icon, such as Blank Database, or any database template. When you click a template, a window appears; you see a preview of your template.
  3. Click in the File Name text box and type a descriptive name for your database. If you click the folder icon that appears to the right of the File Name text box, you can open a dialog box that will let you define a specific drive and folder in which to store your database file.
  4. Click the Create button to create your database file.Access displays a blank database.
  5. Click view, and click view design
  6. Type a name for your field (such as Name , address, and number).
  7. The field name we fill with first name
  8. And than click the data type
  9. In data type have many type of data
  10. in the data type, which is often used is short text, longtext,number,date/time.
  11. Short text is used for alfa numeric , for exmaple (name, address)
  12. Number : The Number data type can be used to store numeric data that will be used for mathematical calculation processes (for example reducing, adding, multiplying and dividing a number)
  13. Data type Data / time used for data that is of type date, time or a combination of date and time
  14. After we fill the field name and data type
  15. Click view and click datasheet view
  16. Click yes
  17. In the table student in field name,number,adress and date we fill in the data you want to enter

 

  1. Open ms access
  2. there are many template choices for databases
  3. Click an icon, such as Blank Database, or any database template. When you click a template, a window appears; you see a preview of your template.
  4. Click in the File Name text box and type a descriptive name for your database. If you click the folder icon that appears to the right of the File Name text box, you can open a dialog box that will let you define a specific drive and folder in which to store your database file.
  5. Click the Create button to create your database file.Access displays a blank database.
  6. Click view, and click view design
  7. Type a name for your field (such as Name , address, and number).
  8. The field name we fill with first name
  9. And than klik the data type
  10. In data type have many type of data
  11. in the data type, which is often used is short text, longtext,number,date/time.
  12. Short text is used for alfa numeric , for exmaple (name, address)
  13. Number : The Number data type can be used to store numeric data that will be used for mathematical calculation processes (for example reducing, adding, multiplying and dividing a number)
  14. Data type Data / time used for data that is of type date, time or a combination of date and time
  15. After we fill the field name and data type
  16. Click view and click datasheet view
  17. Click yes
  18. In the table student in field name,number,adress and date we fill in the data you want to enter
  19. Thankyou wassalamualaikum