Microsoft Access Database Concepts

Microsoft Access Database Concepts

Assessment

Interactive Video

Computers

9th - 10th Grade

Practice Problem

Easy

Created by

NORHAZLINA Moe

Used 1+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does DBMS stand for?

Database Management System

Data Backup Management System

Digital Business Management Software

Dynamic Base Management System

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Table

Query

Report

Spreadsheet

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Text/Short Text

Memo/Long Text

AutoNumber

Number

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?