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

Tipe memo digunakan untuk membuat data yang berupa keterangan yang panjang. Memo digunakan untuk menyimpan teks yang lebih panjang daripada tipe data lainnya.

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.

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

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.

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.

The given answer is "8 Field" because the image consists of 8 different fields.

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.

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

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.

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

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.

To create a query using the "Create Query by Using Wizard" option in ACCESS, we need to follow 3 steps provided by the wizard.

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.

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.

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