# Latihan Soal Uts Kelas 8 - Soal1

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Alianto
A
Alianto
Community Contributor
Quizzes Created: 2 | Total Attempts: 1,123
Questions: 10 | Attempts: 298

Settings

Bahan Materi UTS SMT-2 Th. 2013-2014

• 1.

### Perhitungan rumus pada Query di Access dilakukan dibagian  ….

• A.

Table

• B.

Field

• C.

Show

• D.

Citeria

B. Field
Explanation
The calculation of the formula in a query in Access is performed in the "Field" section.

Rate this question:

• 2.

### Membuat rumus, memilih data tertentu, dan mengurutkan data adalah beberapa kegiatan yang dilakukan di object

• A.

Query

• B.

Form

• C.

Table

• D.

Report

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."

Rate this question:

• 3.

### Data yang bertipe Currency dipilih untuk membuat field-field…

• A.

Alamat, Nama

• B.

Kode, Jumlah Item

• C.

Total Harga, Biaya

• D.

Tanggal Lahir

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.

Rate this question:

• 4.

### Perhatikan gambar dibawah ini !!!! Perhatikan tabel diatas ini, pernyataan yang benar untuk tabel diatas adalah…

• A.

Tabel terdiri dari 15 kolom

• B.

Tabel terdiri dari 8 record

• C.

Tabel terdiri dari 7 field

• D.

Tabel terdiri dari 8 kolom

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.

Rate this question:

• 5.

### Field unik yang menjadi penghubung antar tabel ditandai sebagai….

• A.

Master Key

• B.

Ultimate Key

• C.

Submaster Key

• D.

Primary Key

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.

Rate this question:

• 6.

### Dalam Microsoft Access Tabel terdiri dari….

• A.

Kolom dan Baris

• B.

Field dan Row

• C.

Field dan Record

• D.

Column dan Record

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.

Rate this question:

• 7.

### Pengetikan Rumus dalam Microsoft Access diawali dengan..

• A.

:

• B.

/

• C.

=

• D.

,

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.

Rate this question:

• 8.

### Pada Query bagian untuk mengetikan syarat dalam memilih/menampilkan suatu data tertentu adalah....

• A.

Field

• B.

Show

• C.

Criteria

• D.

Sort

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.

Rate this question:

• 9.

### Icon RUN berguna untuk....

• A.

Membuat rumus

• B.

Memperbaiki Query

• C.

Menghapus Query

• D.

Menampilkan Tabel Query

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.

Rate this question:

• 10.

### Bagian Sort dalam Query berguna untuk...

• A.

Mengetik Rumus

• B.

Mengetik persyaratan data yang akan di show

• C.

Show/Hide Field

• D.

Mengurutkan data