Latihan 1 Kkpi - Smk Pgri 35 (MS Access 2003)
- 1.
Program Microsoft Access berguna untuk ....
- A.
Pengolah kata
- B.
Pengolah data
- C.
Pengolah angka
- D.
Pengolah database
- E.
Pengolah gambar
Correct Answer
D. Pengolah databaseExplanation
Microsoft Access is a program that is specifically designed for managing and manipulating databases. It allows users to create and maintain databases, as well as perform various tasks such as entering, storing, and retrieving data. Therefore, it is correct to say that Microsoft Access is a useful tool for pengolah database (database management).Rate this question:
-
- 2.
Dalam sebuah database, data yang bisa dilakukan penghitungan matematika adalah data yang bertipe
- A.
Text
- B.
Memo
- C.
Numeric
- D.
Date /time
- E.
Yes / No
Correct Answer
C. NumericExplanation
Numeric data refers to data that can be used for mathematical calculations. This type of data consists of numbers and can be manipulated using mathematical operations such as addition, subtraction, multiplication, and division. In a database, numeric data is typically used for storing quantitative information such as quantities, measurements, or monetary values. This allows for performing calculations and generating meaningful insights from the data.Rate this question:
-
- 3.
Dalam Ms Access, tabel terdiri dari ....
- A.
Kolom dan baris
- B.
Kolom dan angka
- C.
Field dan baris
- D.
Kolom dan record
- E.
Field dan record
Correct Answer
E. Field dan recordExplanation
Dalam Ms Access, tabel terdiri dari kolom dan record. Kolom merujuk pada bagian vertikal dalam tabel yang berisi jenis data atau atribut yang berbeda, sedangkan record merujuk pada bagian horizontal dalam tabel yang berisi kumpulan nilai atau data yang lengkap untuk setiap atribut.Rate this question:
-
- 4.
Bagian judul tabel pada Ms Access disebut....
- A.
Field
- B.
Kolom
- C.
Baris
- D.
Record
- E.
Data
Correct Answer
A. FieldExplanation
The correct answer is "field". In Microsoft Access, the title of a table is referred to as a field. A field represents a specific piece of data within a table and is used to categorize and organize the information. Each field has a unique name and data type, allowing users to easily identify and manipulate the data in the table.Rate this question:
-
- 5.
Tipe data Text memiliki batasan lebar, yaitu sebanyak .... character.
- A.
62256
- B.
255
- C.
15
- D.
10
- E.
8
Correct Answer
B. 255Explanation
The correct answer is 255. The text data type has a maximum width limit of 255 characters.Rate this question:
-
- 6.
Langkah pertama dalam pembuatan database adalah ....
- A.
Membuat tabel
- B.
Menentukan field dan type data
- C.
Mengetikkan nama database
- D.
Memasukkan / menginput data
- E.
Menutup database
Correct Answer
C. Mengetikkan nama databaseExplanation
The first step in creating a database is typing the name of the database. This is because before any tables or fields can be created, the database itself needs to be named. The name of the database is important as it serves as an identifier for the data that will be stored within it. Once the name is typed, further steps such as creating tables, determining fields and data types, inputting data, and closing the database can be carried out.Rate this question:
-
- 7.
Berikut yang tidak termasuk tipe-tipe data adalah ....
- A.
Text
- B.
Memo
- C.
Number
- D.
Autonumber
- E.
Form
Correct Answer
E. FormExplanation
The question is asking for the type of data that does not belong in the given list. The options "text," "memo," "number," and "autonumber" all refer to different types of data that can be stored or inputted. However, "form" does not refer to a type of data, but rather a structure or layout used to collect or display data. Therefore, "form" is the correct answer as it does not belong to the list of data types provided.Rate this question:
-
- 8.
Tipe memo digunakan untuk membuat data yang berupa ....
- A.
Keterangan yang panjang
- B.
Angka
- C.
Mata uang
- D.
Tanggal
- E.
Penomoran otomatis
Correct Answer
A. Keterangan yang panjangExplanation
Tipe memo digunakan untuk membuat data yang berupa keterangan yang panjang. Memo digunakan untuk menyimpan teks yang lebih panjang daripada tipe data lainnya.Rate this question:
-
- 9.
Satuan data dalam tabel Ms Access disebut....
- A.
Kolom
- B.
Field
- C.
Record
- D.
Baris
- E.
Database
Correct Answer
C. RecordExplanation
In Microsoft Access, a record refers to a complete set of related data that is stored in a table. It represents a single row in the table and contains information about a specific entity or object. Each record consists of multiple fields or columns, which store individual pieces of data. Therefore, the correct answer is "record".Rate this question:
-
- 10.
Pembuatan tabel dengan option Create Table in Design View mengarahkan kita untuk menentukan struktur tabel yang terdiri dari ....
- A.
Field, column, type
- B.
Column, type, description
- C.
Record, column, type
- D.
Field, type, description
- E.
Record, type, description
Correct Answer
D. Field, type, descriptionExplanation
When creating a table using the "Create Table in Design View" option, we are prompted to determine the structure of the table. This structure includes the fields, which represent the columns of the table, the type of data that each field will hold, and a description for each field. Therefore, the correct answer is "field, type, description".Rate this question:
-
- 11.
Perhatikan gambar!Gambar tersebut terdiri dari ....
- A.
8 Field
- B.
8 record
- C.
8 kolom
- D.
8 baris
- E.
8 sel
Correct Answer
A. 8 FieldExplanation
The given answer is "8 Field" because the image consists of 8 different fields.Rate this question:
-
- 12.
Dalam pembuatan QUERY, Icon RUN berguna untuk ....
- A.
Mengedit query
- B.
Mengetik rumus
- C.
Memperbaiki query
- D.
Menampilkan hasil query
- E.
Menghapus query
Correct Answer
D. Menampilkan hasil queryExplanation
The correct answer is "menampilkan hasil query". The icon "RUN" in QUERY is used to execute or run the query, which means it will display the results of the query. This allows the user to see the output or outcome of the query they have created.Rate this question:
-
- 13.
Untuk membuat QUERY dengan option CREATE QUERY BY USING WIZARD, kita harus mengikuti .... langkah (wizard) yang disediakan ACCESS.
- A.
2
- B.
3
- C.
4
- D.
5
- E.
6
Correct Answer
B. 3Explanation
To create a query using the "Create Query by Using Wizard" option in ACCESS, we need to follow 3 steps provided by the wizard.Rate this question:
-
- 14.
Hubungan antar tabel yang memiliki field yang sama dibuat dengan menggunakan fasilitas ....
- A.
Query
- B.
Wizard
- C.
Design
- D.
Relationship
- E.
Form
Correct Answer
D. RelationshipExplanation
The correct answer is "relationship". When creating a relationship between tables, it is necessary to have a field that is common between them. This allows for the tables to be connected and related to each other, enabling the retrieval of data from multiple tables through queries and other operations. The relationship feature in a database management system facilitates the establishment of this connection between tables based on the shared field.Rate this question:
-
- 15.
Penghitungan rumus pada Query dilakukan di bagian ....
- A.
Table
- B.
Field
- C.
Show
- D.
Sort
- E.
Criteria
Correct Answer
E. CriteriaExplanation
The correct answer is "Criteria". In a query, the calculation of formulas is performed in the criteria section. This is where you specify the conditions or criteria that the data must meet in order to be included in the query results. The criteria section allows you to filter and manipulate the data based on specific requirements, such as values, ranges, or patterns. By setting criteria, you can control the results of the query and retrieve only the data that meets the specified conditions.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Aug 22, 2010Quiz Created by
Anshori
Back to top