Latihan 1 Kkpi - Smk Pgri 35 (MS Access 2003)

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Anshori
A
Anshori
Community Contributor
Quizzes Created: 5 | Total Attempts: 7,429
| Attempts: 764
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/15 Pertanyaan

    Tipe memo digunakan untuk membuat data yang berupa ....

    • Keterangan yang panjang
    • Angka
    • Mata uang
    • Tanggal
    • Penomoran otomatis
Please wait...
Latihan 1 Kkpi - Smk Pgri 35 (MS Access 2003) - Quiz

Quiz Preview

  • 2. 

    Dalam sebuah database, data yang bisa dilakukan penghitungan matematika adalah data yang bertipe

    • Text

    • Memo

    • Numeric

    • Date /time

    • Yes / No

    Correct Answer
    A. Numeric
    Explanation
    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. 

    Program Microsoft Access berguna untuk ....

    • Pengolah kata

    • Pengolah data

    • Pengolah angka

    • Pengolah database

    • Pengolah gambar

    Correct Answer
    A. Pengolah database
    Explanation
    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:

  • 4. 

    Berikut yang tidak termasuk tipe-tipe data adalah ....

    • Text

    • Memo

    • Number

    • Autonumber

    • Form

    Correct Answer
    A. Form
    Explanation
    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:

  • 5. 

    Bagian judul tabel pada Ms Access disebut....

    • Field

    • Kolom

    • Baris

    • Record

    • Data

    Correct Answer
    A. Field
    Explanation
    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:

  • 6. 
    Perhatikan gambar!Gambar tersebut terdiri dari .... - ProProfs

    Perhatikan gambar!Gambar tersebut terdiri dari ....

    • 8 Field

    • 8 record

    • 8 kolom

    • 8 baris

    • 8 sel

    Correct Answer
    A. 8 Field
    Explanation
    The given answer is "8 Field" because the image consists of 8 different fields.

    Rate this question:

  • 7. 

    Dalam pembuatan QUERY, Icon RUN berguna untuk ....

    • Mengedit query

    • Mengetik rumus

    • Memperbaiki query

    • Menampilkan hasil query

    • Menghapus query

    Correct Answer
    A. Menampilkan hasil query
    Explanation
    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:

  • 8. 

    Tipe data Text memiliki batasan lebar, yaitu sebanyak .... character.

    • 62256

    • 255

    • 15

    • 10

    • 8

    Correct Answer
    A. 255
    Explanation
    The correct answer is 255. The text data type has a maximum width limit of 255 characters.

    Rate this question:

  • 9. 

    Dalam Ms Access, tabel terdiri dari ....

    • Kolom dan baris

    • Kolom dan angka

    • Field dan baris

    • Kolom dan record

    • Field dan record

    Correct Answer
    A. Field dan record
    Explanation
    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:

  • 10. 

    Pembuatan tabel dengan option Create Table in Design View mengarahkan kita untuk menentukan struktur tabel yang terdiri dari ....

    • Field, column, type

    • Column, type, description

    • Record, column, type

    • Field, type, description

    • Record, type, description

    Correct Answer
    A. Field, type, description
    Explanation
    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. 

    Hubungan antar tabel yang memiliki field yang sama dibuat dengan menggunakan fasilitas ....

    • Query

    • Wizard

    • Design

    • Relationship

    • Form

    Correct Answer
    A. Relationship
    Explanation
    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:

  • 12. 

    Untuk membuat QUERY dengan option CREATE QUERY BY USING WIZARD, kita harus mengikuti .... langkah (wizard) yang disediakan ACCESS.

    • 2

    • 3

    • 4

    • 5

    • 6

    Correct Answer
    A. 3
    Explanation
    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:

  • 13. 

    Langkah pertama dalam pembuatan database adalah ....

    • Membuat tabel

    • Menentukan field dan type data

    • Mengetikkan nama database

    • Memasukkan / menginput data

    • Menutup database

    Correct Answer
    A. Mengetikkan nama database
    Explanation
    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:

  • 14. 

    Penghitungan rumus pada Query dilakukan di bagian ....

    • Table

    • Field

    • Show

    • Sort

    • Criteria

    Correct Answer
    A. Criteria
    Explanation
    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:

  • 15. 

    Satuan data dalam tabel Ms Access disebut....

    • Kolom

    • Field

    • Record

    • Baris

    • Database

    Correct Answer
    A. Record
    Explanation
    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:

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Aug 22, 2010
    Quiz Created by
    Anshori
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.