Microsoft Access Database Concepts

What does DBMS stand for?

• Database Management System

• Data Backup Management System

• Digital Business Management Software

• Dynamic Base Management System

Why is Microsoft Access used for database management?

• It is a free and open-source software

• It is equipped with tools for development, management, and maintenance of relational databases

• It is primarily used for creating presentations

• It is a simple text editor

Which of the following is NOT a common object in a database?

• Table

• Query

• Report

• Spreadsheet

What is the primary function of a Form (Borang) in a database?

• To store data in rows

• To request specific data from tables

• To provide reports based on data

• To facilitate data entry and display data from queries

Which data type is suitable for automatically generating incrementing numbers, often used for primary keys?

• Text/Short Text

• Memo/Long Text

• AutoNumber

• Number

What is the first step to add attributes (fields) to a table in Microsoft Access?

• Click "Create" then "Table Design".

• Click "View" then "Design View".

• Click "Home" then "New Table".

• Click "External Data" then "Import".

When creating field names in Microsoft Access, what is the recommended practice if a field name consists of two words, like "Nama Kelas"?

• Use a space between the words.

• Use an underscore (_) to connect the words.

• Use a hyphen (-) to connect the words.

• Capitalize the first letter of each word without any separator.

What data type was primarily used for all the fields (attributes) created in both the "MURID" and "MARKAH" tables, except for the default "AutoNumber" for ID fields?

• Number

• Long Text

• Short Text

• Date/Time

Which menu and option should be selected to create relationships between tables in Microsoft Access?

• Home -> Relationships

• Create -> Relationships

• Database Tools -> Relationships

• External Data -> Relationships

What type of relationship was established between the "MURID" and "MARKAH" tables using the "ID_Murid" field?

• One-To-One

• Many-To-Many

• One-To-Many

• Many-To-One