Create DataBase using Microsoft Access

https://www.google.co.id/search?q=microsoft+access&rlz=1C1CHBF_enID777ID777&source=lnms&tbm=isch&sa=X&ved=0ahUKEwjArPOwhdjZAhXJpY8KHTzTDVkQ_AUICigB&biw=1366&bih=662#imgrc=8h47QXeafqXBYM:

1. Purpose

• Understanding the Introduction of Database
• Capable of Creating Tables (Ms. Access 2013)
• Able to Create a Primary Key
• Ability to Modify Tables
• Able to Make Relationship

2. Creating a Database

Ms. Access provides several approaches to creating a database, one of which is as follows:

1. Open Microsoft Access.
2. Click Blank DataBase on the New Blank DataBase Section.
3. In the File Name section, save the file with the desired name, such as Database1.accdb.
4. Select the storage directory you want by clicking on the folder icon located on the right of the File Name textbox.
5. Click Create.

3. Creating Tables

 To create a new table, follow the steps below

1. On the Create menu, select Table.
2. In writing Table1 right click on the mouse and select Design View.
3. In the Save As dialog box, fill in the name of the table to be created, eg clerk, then click OK.

4. Creating Relationships between Tables

1. Make it in the project table according to the above structure:
2. Select the DataBase Tools Relationships menu
3. In the Show Table dialog box, select the table name and Add to add the table to the relationships editor, then click close.
4. Drag (left-click and hold) the field (primary key) from one table then drop (place and drop) into another (Foreign Key) table field.
5. In the Edit Relationships dialog using Type One-To-Many, right-click Create.
6. In the relationships editor window will show the relation of the three tables.
7. Save relationships by right clicking on the relationships tab then select Save
8. If you want to edit the new relationship in right click on the line relationship > Edit

5. Analysis

The database above is the student administration database to take the course, general secra there are only 3 tables in the database, the first table is a table of student data containing the NIM, name, gender, and then the second table is the table of available courses that contain course code, credits and semesters then table retrieval of subjects where to put data in another table, to use the existing data on other tabe must create a relationship terleih first.

6. Conclusion

• The table is a collection of data arranged according to certain rules and related to a particular topic as a means of data storage.
• Fields are where the same set of data is entered. The field is a vertical column in the table.
• Records are a collection of interconnected data items.
• The primary key is the selected candidate key to identify the tuples (rows) uniquely in the relation.
• To link data together from a separate table when a query is being prepared.
• An Access feature connects two or more different tables so that they can be interrelated.