Soal Modul 2 MS.Access

A primary key is a unique identifier for each record in a database table. It is used to differentiate one field from another and ensure that there is no duplicate data. By creating a primary key, it becomes impossible to have duplicate records in the table, which helps maintain data integrity and accuracy.

This is a multiple-choice question asking to identify the item that is not related to database objects and project data base files. The options provided are "Table," "Field," "Report," and "Quit." Among these options, "Quit" is the odd one out as it does not relate to any specific object or file in a database or project. Therefore, "Quit" is the correct answer.

The correct answer is "Currency". Currency data type is often used to store values related to currency, such as monetary amounts or exchange rates. It allows for accurate calculations and formatting of currency values.

The correct answer is "Create table and Desain view". This option refers to the facility of creating a table by defining the necessary fields according to one's needs. It also includes the ability to design the table by entering data. Additionally, it suggests the possibility of creating a table using a wizard. The option "New" is not relevant to the given question.

The correct answer is "Kumpulan dari field dan record". This answer suggests that a table is a collection of both fields and records. A field refers to a single piece of data, while a record is a collection of related fields. Therefore, a table can be understood as a collection of these fields and records, organizing and storing data in a structured manner.

The correct answer is "Aplikasi basis data". Microsoft Access is a program that is specifically designed for creating and managing databases. It allows users to store, organize, and manipulate large amounts of data efficiently. It provides features like creating tables, forms, queries, and reports, which are essential for managing and analyzing data in a database. Therefore, Microsoft Access is considered an application for working with databases rather than a word processor or an operating system.

Microsoft Access is a program application. It is a database management system that allows users to create and manage databases. It is not a program utility, operating system, or spreadsheet program.

The correct answer is "Quary". It is likely that the question is asking about the process of combining two tables into one using a "Quary" (should be spelled "Query") in a database. A query is a request for specific information from a database, and in this case, it is used to merge two tables together.

To group and display specific fields and records from a table, as well as determine their order, the use of a form is necessary. A form allows users to customize the layout and appearance of data, making it easier to view and interact with specific information. By designing a form, users can select which fields and records they want to include, arrange them in a desired order, and customize the form's layout to suit their needs.

The question asks for the term that describes the relationship between one table and another. The term "Queries" does not accurately describe this relationship, as queries are used to retrieve data from a single table or multiple tables. The correct term for this relationship is "Relationship," as it refers to the connections and associations between tables in a database.