Membuat Database Penjualan Beserta Relasi Antar Tabel Dengan Ms Access || Tugas Sistem Basis Data

Summary

In this instructional video, a team presents a step-by-step guide to creating a sales database using Microsoft Access 2019. The process includes setting up a new database, designing tables for product details and transactions, establishing relationships between tables, and generating queries and forms for data entry. The presenters demonstrate how to input data, calculate totals automatically, and manage transaction records effectively. The tutorial aims to simplify database creation for beginners, showcasing essential features of Access while encouraging users to practice and refine their skills.

Takeaways

• 😀 Introduced the purpose of creating a sales database using Microsoft Access.
• 😀 Demonstrated how to open Microsoft Access and create a new database.
• 😀 Explained the process of creating the first table ('Tabel Barang') with specific fields.
• 😀 Highlighted the importance of defining data types for each field in the table.
• 😀 Showed how to calculate the total amount (Jumlah) as a derived field in the table.
• 😀 Walked through the creation of a second table ('Tabel Transaksi') for transaction records.
• 😀 Discussed the setup of relationships between tables to ensure data integrity.
• 😀 Described the steps for creating queries to extract and analyze data from the database.
• 😀 Illustrated the design and functionality of forms for data entry.
• 😀 Concluded with testing the database functionalities and emphasizing its usability.

Q & A

What is the primary purpose of the video?

The primary purpose of the video is to explain how to create a sales database using Microsoft Access.

Who are the presenters in the video?

The presenters are Novita, Trephine Anggraini, Dina Rahmadani, and Krisnanda.

What is the first step in creating a database in Microsoft Access?

The first step is to open Microsoft Access and select 'Blank Database' to create a new database.

How do you save a new database in Microsoft Access?

You save a new database by selecting a location, naming the database, and clicking 'Create'.

What fields are included in the 'Tabel Barang' table?

The 'Tabel Barang' table includes fields for Kode Barang, Nama Barang, Harga, Kuantitas, and Jumlah.

What is the purpose of the 'Jumlah' field in the 'Tabel Barang'?

The 'Jumlah' field is a calculated field that represents the total amount by multiplying the price by the quantity.

How are the two tables linked in the database?

The two tables are linked through the 'Kode Barang' field, creating a relationship between 'Tabel Barang' and 'Tabel Transaksi'.

What type of queries are created in the database?

Queries are created to display data from both tables, showing details such as item code, item name, price, quantity, and total amount.

What functionalities are included in the forms created in the database?

The forms include functionalities for saving, canceling, and adding new records for transactions.

What do the presenters acknowledge about their presentation at the end of the video?

The presenters acknowledge that they are still learning and thank the viewers for their understanding.