Soal MS Access

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 Roninglipar
R
Roninglipar
Community Contributor
Quizzes Created: 17 | Total Attempts: 162,134
Questions: 30 | Attempts: 2,338

Settings

Tuliskan nama lengkap anda pada kotak yang disediakan!Perhatikan! Anda hanya memiliki satu kali kesempatan menjawab dengan e-mail yang sudah Anda kirimkan!Waktu : 40 menit / 30 Soal (Pilihan Ganda)

• 1.

Penghitungan rumus pada Query dilakukan di bagian ....

• A.

Table

• B.

Field

• C.

Show

• D.

Criteria

• E.

Semua salah

B. Field
Explanation
The correct answer is "field". In query, the calculation of formulas is performed on the specific fields of the table. The field refers to a column or attribute in a database table that stores specific data. Therefore, the calculation of formulas in a query is done on the fields of the table.

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

• E.

A. Query
Explanation
The activities mentioned in the question, such as creating formulas, selecting specific data, and sorting data, are typically performed in a query. A query is a request for specific information from a database, where users can define criteria and conditions to extract relevant data. Therefore, the correct answer 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, Waktu Pendaftaran

• E.

L/P, Ya/Tidak

C. Total Harga, Biaya
Explanation
The correct answer is "Total Harga, Biaya". The reason for choosing the data type "Currency" for this field is because it represents a specific monetary value. In this case, "Total Harga" refers to the total price or cost of something, and "Biaya" refers to the expenses or fees associated with it. Using the "Currency" data type ensures that the values entered in these fields are in the correct format and can be easily manipulated for calculations or comparisons involving monetary values.

Rate this question:

• 4.

Perhatikan tabel di atas!Pernyataan yang benar untuk tabel di atas menurut Microsoft Access adalah ....

• A.

Tabel terdiri dari 15 kolom

• B.

Tabel terdiri dari 7 field

• C.

Tabel terdiri dari 8 record

• D.

Tabel terdiri dari 7 record

• E.

Tabel terdiri dari 8 kolom

D. Tabel terdiri dari 7 record
Explanation
The correct answer is "tabel terdiri dari 7 record". This is because the table in the given question has 7 rows or records. The number of columns or fields in the table is not mentioned, so it cannot be determined from the given information. Therefore, the correct answer is based on the number of records in the table.

Rate this question:

• 5.

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

• A.

Master key

• B.

Submaster key

• C.

Ultimate key

• D.

Pass key

• E.

Primary key

E. Primary key
Explanation
A primary key is a unique field in a table that serves as a unique identifier for each record. It is used to establish relationships between tables by acting as a link or reference point. The primary key ensures that each record in a table is unique and can be used to retrieve or update specific records.

Rate this question:

• 6.

Dalam Microsoft Access, tabel terdiri dari ....

• A.

Kolom dan baris

• B.

Field dan record

• C.

Field dan rows

• D.

Column dan record

• E.

Field dan baris

B. Field dan record
Explanation
In Microsoft Access, a table consists of fields and records. Fields represent the columns of the table, containing specific data types such as text, numbers, or dates. Records, on the other hand, represent the rows of the table, containing a complete set of information related to a specific entity or item. Therefore, the correct answer is "field dan record".

Rate this question:

• 7.

Pengetikan rumus dalam Microsoft Access diawali dengan ....

• A.

:

• B.

/

• C.

=

• D.

,

• E.

+

A. :
Explanation
The correct answer is ":". In Microsoft Access, the typing of formulas or expressions is initiated by using a colon ":" symbol. This symbol is used to indicate that a formula or expression is being entered in a specific field or control.

Rate this question:

• 8.

Pada Query, bagian untuk mengetikkan syarat dalam memilih/menampilkan suatu data tertentu adalah ....

• A.

Field

• B.

Show

• C.

Criteria

• D.

Sort

• E.

Or

C. Criteria
Explanation
The correct answer is "criteria". In a query, the criteria section is where you can type the conditions or requirements to select or display specific data. It allows you to filter the data based on certain criteria, such as a specific value, range, or condition. By specifying the criteria, you can narrow down the results and retrieve only the desired data that meets the specified conditions.

Rate this question:

• 9.

Icon RUN berguna untuk ....

• A.

Membuat rumus

• B.

Memperbaiki query

• C.

Menghapus query

• D.

Menampilkan tabel query

• E.

D. Menampilkan tabel query
Explanation
The correct answer is "menampilkan tabel query". The icon RUN is useful for executing a query and displaying the results in a table format. It allows users to see the output of their query and analyze the data in a structured manner.

Rate this question:

• 10.

Bagian Sort dalam Query berguna untuk ....

• A.

Mengetik rumus

• B.

Mengetik persyaratan data yang akan ditampilkan

• C.

Menampilkan / menyembunyikan field

• D.

Membuat field baru

• E.

Mengurutkan data

E. Mengurutkan data
Explanation
The Sort section in a query is used to arrange or organize the data in a specific order. It allows the user to specify the criteria for sorting the data, such as sorting in ascending or descending order based on a particular field. This helps in presenting the data in a structured and meaningful way, making it easier to analyze and interpret the information.

Rate this question:

• 11.

Pada field TOTAL BIAYA akan diketikkan rumus JML_BULAN dikali BESAR_SPP.Penulisan yang tepat untuk kasus di atas pada Query adalah ....

• A.

TOTAL BIAYA:[JML_BULAN]*[BESAR_SPP]

• B.

TOTAL BIAYA:[JML_BULAN*BESAR_SPP]

• C.

TOTAL BIAYA=[JML_BULAN]*[BESAR_SPP]

• D.

TOTAL BIAYA:(JML_BULAN)*(BESAR_SPP)

• E.

TOTAL BIAYA=(JML_BULAN]*[BESAR_SPP]

A. TOTAL BIAYA:[JML_BULAN]*[BESAR_SPP]
Explanation
The correct answer is "TOTAL BIAYA:[JML_BULAN]*[BESAR_SPP]". This is the correct syntax for typing the formula "JML_BULAN multiplied by BESAR_SPP" in the TOTAL BIAYA field in a query. The formula should be enclosed in square brackets and the multiplication operator (*) should be used to multiply the two variables.

Rate this question:

• 12.

Tampilan ini dihasilkan oleh object ....

• A.

Table

• B.

Form

• C.

Report

• D.

Query

• E.

B. Form
Explanation
The correct answer is "form". A form is a graphical user interface that allows users to input data and interact with a system. It is used to collect and organize data in a structured manner. In this context, the given display is generated by an object that is a form.

Rate this question:

• 13.

Icon ini bernama ....

• A.

Datasheet View

• B.

Run

• C.

Design View

• D.

Form View

• E.

Sort View

C. Design View
Explanation
The correct answer is Design View because it is the mode in which you can create and modify the design of a form or report in a database. In Design View, you can add and arrange fields, set properties, and customize the layout and appearance of the form or report. It allows you to have more control and flexibility in designing the visual elements of your database objects.

Rate this question:

• 14.

Pilihan bentuk form yang berupa pertanyaan di sebelah kiri dan isian di sebelah kanan disebut....

• A.

Justified

• B.

Tabular

• C.

Datasheet

• D.

Columnar

• E.

Pivot table

D. Columnar
Explanation
The correct answer is "columnar". Columnar form refers to a format where the questions or prompts are listed on the left side and the corresponding answers or inputs are provided on the right side in separate columns. This format is commonly used in surveys, questionnaires, and forms to organize and present information in a structured manner.

Rate this question:

• 15.

Pada form, kita bisa membuat tombol-tombol perintah menggunakan icon ....

• A.

Label

• B.

Text box

• C.

Option button

• D.

Combo box

• E.

Command button

E. Command button
Explanation
In a form, we can create command buttons using icons. Command buttons are typically used to perform specific actions when clicked, such as submitting a form or executing a command. They are commonly represented by icons to make them visually recognizable and user-friendly.

Rate this question:

• 16.

Contoh record yang bertipe text adalah ....

• A.

N3001,N3002,N3003

• B.

25001,25002,25003

• C.

01/30/89,01/31/89,02/01/89

• D.

1,2,3,4

• E.

12:03,12:44,12:50

A. N3001,N3002,N3003
Explanation
The given record consists of multiple columns separated by commas. Each column contains a text value. The answer lists the column names of the text records, which are N3001, N3002, and N3003.

Rate this question:

• 17.

Microsoft Acces berguna untuk ....

• A.

Mengolah presentasi

• B.

Mengolah database

• C.

Mengolah kata

• D.

Mengolah data

• E.

Mengolah gambar

B. Mengolah database
Explanation
Microsoft Access is a database management system that is used to store, organize, and manipulate data. It allows users to create and manage databases, create tables to store data, define relationships between tables, and perform queries to retrieve and analyze data. Therefore, the correct answer is "mengolah database".

Rate this question:

• 18.

Membuat tulisan (judul, alamat, dll.) pada Form menggunakan icon ....

• A.

Command button

• B.

Combo box

• C.

Label

• D.

Select

• E.

Option button

C. Label
Explanation
The correct answer is label. A label is used to display text or information on a form, such as a title, address, or any other type of textual content. It is commonly used to provide descriptions or instructions to the user. Labels are typically static and cannot be interacted with by the user.

Rate this question:

• 19.

Command yang tepat untuk tombol di atas adalah ....

• A.

Quit application

• B.

Go to next record

• C.

Go to previous record

• D.

• E.

Print a record

Explanation
The correct command for the given button would be "add new record." This command would allow the user to create and add a new record to the existing data.

Rate this question:

• 20.

1. Membuat Form2. Membuat Tabel3. Mengetik Judul4. Keluar5. Membuat QueryUrutan pembuatan database yang baik adalah ....

• A.

1-2-3-4-5

• B.

5-4-3-2-1

• C.

3-1-4-2-5

• D.

2-3-1-5-4

• E.

3-2-5-1-4

E. 3-2-5-1-4
Explanation
The correct order for creating a database is to first type the title (3), then create a table (2), make a query (5), create a form (1), and finally exit (4). This order ensures that all necessary components are created and organized properly in the database.

Rate this question:

• 21.

Microsoft Power Point berguna untuk ....

• A.

Mengolah presentasi

• B.

Mengolah database

• C.

Mengolah kata

• D.

Mengolah angka

• E.

Mengolah gambar

A. Mengolah presentasi
Explanation
Microsoft Power Point berguna untuk mengolah presentasi. Power Point adalah aplikasi yang digunakan untuk membuat slide presentasi yang dapat berisi teks, gambar, grafik, dan elemen multimedia lainnya. Dengan Power Point, pengguna dapat mengatur tata letak slide, menambahkan efek transisi, dan memberikan animasi pada elemen-elemen presentasi. Selain itu, Power Point juga memungkinkan pengguna untuk menyajikan presentasi dengan menggunakan fitur presenter view, yang memungkinkan pengguna untuk melihat slide berikutnya, catatan presenter, dan tampilan waktu.

Rate this question:

• 22.

Lembar kerja power point disebut ....

• A.

Animasi

• B.

Slide

• C.

Efek

• D.

Layout

• E.

Design

B. Slide
Explanation
The correct answer is "slide". In PowerPoint, a slide refers to a single page or screen that contains content such as text, images, and multimedia. Slides are used to organize and present information in a visually appealing and structured manner during a presentation.

Rate this question:

• 23.

Slide Design adalah perintah yang berguna untuk ....

• A.

Mengubah layout

• B.

Membuat animasi

• C.

Mengatur background

• D.

Menambah slide baru

• E.

Menampilkan slide

C. Mengatur background
Explanation
The correct answer is "mengatur background". This is because the command "Slide Design" is used to adjust the background of a slide, such as changing the color, adding a picture, or applying a theme. It does not refer to changing the layout, creating animations, adding new slides, or displaying slides.

Rate this question:

• 24.

Tombol F5 sama fungsinya dengan ....

• A.

Slide Show ==> Custom Animation

• B.

Insert ==> New Slide

• C.

Format ==> Slide Design

• D.

Slidewshow ==> View Show

• E.

Format ==> Slide Layout

D. Slidewshow ==> View Show
Explanation
The correct answer is "Slidewshow ==> View Show" because pressing the F5 key on the keyboard is used to start a slideshow in Microsoft PowerPoint, and selecting "View Show" from the Slideshow menu accomplishes the same action.

Rate this question:

• 25.

Insert ==> New SlideIni adalah cara untuk ....

• A.

Menghapus slide

• B.

Mewarnai slide

• C.

Menyimpan slide

• D.

Memformat slide

• E.

Menambah slide

E. Menambah slide
Explanation
The correct answer is "menambah slide". This is because the phrase "Insert ==>" suggests that the action being described is related to adding or inserting something. In this case, it is referring to adding a new slide to a presentation. The other options, such as "menghapus slide" (deleting a slide), "mewarnai slide" (coloring a slide), "menyimpan slide" (saving a slide), and "memformat slide" (formatting a slide), do not match the context of the phrase "Insert ==>".

Rate this question:

• 26.

Pengaturan efek animasi ketika teks / gambar akan memasuki slide diatur di bagian ....

• A.

Entrance

• B.

Emphasis

• C.

Motion paths

• D.

Exit

• E.

Inside

A. Entrance
Explanation
The correct answer is "entrance." This is because the question is asking about the settings for animation effects when text or images enter a slide. The "entrance" option refers to the specific settings for these types of animations.

Rate this question:

• 27.

Perintah untuk memberikan efek animasi adalah ....

• A.

Slide show ==> view show

• B.

Slide show ==> custom animation

• C.

Slide show ==> slide transition

• D.

Slide show ==> set up show

• E.

Slide show ==> animation schemes

B. Slide show ==> custom animation
Explanation
The correct answer is "slide show ==> custom animation". This is because custom animation allows users to add various effects and movements to individual objects or text within a slide show. It gives users the ability to control the timing, order, and type of animation for each element, making the presentation more engaging and visually appealing.

Rate this question:

• 28.

Slide pertama biasanya berupa ....

• A.

Gambar

• B.

Isi

• C.

Judul

• D.

Grafik

• E.

Tabel

C. Judul
Explanation
The first slide usually consists of a title.

Rate this question:

• 29.

Untuk mengatur cara tulisan memasuki slide per huruf atau per kata atau per bagian sekaligus, pilihan pada dropdown list nama efek animasinya adalah ....

• A.

Start on click

• B.

• C.

Start after previous

• D.

Effect options

• E.

Timing

D. Effect options
Explanation
The correct answer is "effect options". The question asks about the dropdown list that allows users to control how the text enters the slide, whether it is per letter, per word, or all at once. The "effect options" in the dropdown list provide additional settings and customization for the animation effects applied to the text.

Rate this question:

• 30.

• A.

File

• B.

Edit

• C.

Slide show

• D.

Insert

• E.

Format

E. Format
Explanation
The correct answer is "format" because the question asks where the "Slide Design" command can be found in the menu. The "Slide Design" command is typically used to change the design or layout of a slide, such as applying a theme or template. In most presentation software, the "Format" menu is where you can find options related to changing the design or formatting of elements within a slide, making it the most logical place to find the "Slide Design" command.

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 21, 2023
Quiz Edited by
ProProfs Editorial Team
• May 08, 2012
Quiz Created by
Roninglipar