1.
Perhitungan rumus pada Query di Access dilakukan dibagian ….
Correct Answer
B. Field
Explanation
The calculation of the formula in a query in Access is performed in the "Field" section.
2.
Membuat rumus, memilih data tertentu, dan mengurutkan data adalah beberapa kegiatan yang dilakukan di object
Correct Answer
A. Query
Explanation
The given statement mentions activities such as creating formulas, selecting specific data, and sorting data, which are commonly performed in a query. A query is a request for information from a database, where users can define specific criteria and conditions to retrieve and manipulate data. Therefore, the correct answer for this question is "Query."
3.
Data yang bertipe Currency dipilih untuk membuat field-field…
Correct Answer
C. Total Harga, Biaya
Explanation
The correct answer is "Total Harga, Biaya". The reason for choosing the data type "Currency" for these fields is that they represent monetary values. The "Total Harga" and "Biaya" fields are likely to store the total cost or price of something, and using the "Currency" data type ensures that these values are formatted correctly and can be easily manipulated in calculations involving money.
4.
Perhatikan gambar dibawah ini !!!!
Perhatikan tabel diatas ini, pernyataan yang benar untuk tabel diatas adalah…
Correct Answer
D. Tabel terdiri dari 8 kolom
Explanation
The correct answer is "Tabel terdiri dari 8 kolom". This is because the table in the image has 8 columns, as indicated by the number of vertical divisions or headers in the table. The other options are incorrect as they either state a different number of columns or provide unrelated information.
5.
Field unik yang menjadi penghubung antar tabel ditandai sebagai….
Correct Answer
D. Primary Key
Explanation
The correct answer is "Primary Key". A primary key is a unique field in a table that is used to identify each record uniquely. It is a crucial component in database design as it ensures data integrity and allows for efficient data retrieval and manipulation. By marking a field as a primary key, it becomes the main identifier for the records in the table and serves as a link or reference between different tables in a database.
6.
Dalam Microsoft Access Tabel terdiri dari….
Correct Answer
C. Field dan Record
Explanation
The correct answer is "Field dan Record". In Microsoft Access, a table consists of fields and records. Fields represent the columns in a table and contain specific data types, such as text, numbers, or dates. Records, on the other hand, represent the rows in a table and contain a set of related data values. Therefore, the combination of fields and records forms the structure and content of a table in Microsoft Access.
7.
Pengetikan Rumus dalam Microsoft Access diawali dengan..
Correct Answer
A. :
Explanation
The correct answer is ":". In Microsoft Access, the typing of formulas or expressions is typically started with a colon (":") symbol. This symbol is used to indicate that the following text is a formula or expression that needs to be evaluated.
8.
Pada Query bagian untuk mengetikan syarat dalam memilih/menampilkan suatu data tertentu adalah....
Correct Answer
C. Criteria
Explanation
The correct answer is "Criteria". In a query, the criteria are used to specify the conditions that the data must meet in order to be selected or displayed. The criteria help to filter and narrow down the data based on specific requirements or rules. By setting criteria, you can retrieve only the data that meets the specified conditions, making the query more focused and relevant to your needs.
9.
Icon RUN berguna untuk....
Correct Answer
D. Menampilkan Tabel Query
Explanation
Icon RUN berguna untuk menampilkan tabel query. Ketika kita telah membuat sebuah query atau perintah dalam sistem basis data, kita dapat menggunakan icon RUN untuk menjalankan query tersebut. Setelah dijalankan, hasil query akan ditampilkan dalam bentuk tabel yang memuat data yang diinginkan sesuai dengan perintah yang telah kita buat. Dengan menggunakan icon RUN, kita dapat melihat hasil dari query kita dan memastikan bahwa query tersebut berfungsi dengan benar.
10.
Bagian Sort dalam Query berguna untuk...
Correct Answer
D. Mengurutkan data
Explanation
The Sort section in a query is used to arrange or organize data in a specific order. It allows the user to specify the criteria for sorting the data, such as ascending or descending order, based on one or multiple fields. This helps in presenting the data in a more structured and meaningful way, making it easier to analyze and understand.