computer MCQs - 12th class Chapter 05 Mcqs

1

Microsoft Access is described as what type of system?

A

Relational Database Management System (RDBMS)

B

Flat-File Database System

C

Document Management System

D

Spreadsheet Program

2

What is the term for the duplication of data in multiple files, which MS-Access helps to reduce?

A

Redundancy

B

Repetition

C

Replication

D

Duplicity

3

Which feature in MS-Access guides you through the process of creating a database with templates?

A

Database Wizard

B

Form Helper

C

Table Creator

D

Report Generator

4

What language does Access use that makes its code adaptable to other applications?

A

SQL (Structure Query Language)

B

Python

C

Java

D

C++

5

What is the default file extension for a Microsoft Access database?

A

.accdb

B

.mdb

C

.dbf

D

.sql

6

To create a new, empty database from scratch, which option should you select?

A

Access database wizards, pages, and projects

B

Open an existing file

C

Blank Access database

D

Import from Excel

7

Which bar in the Access Application Window identifies the name of the database application you are running?

A

Status Bar

B

Menu Bar

C

Toolbar

D

Title Bar

8

Toolbars contain icon buttons that are shortcuts to what?

A

Database objects

B

Commands in the menu

C

External applications

D

Help files

9

Which component of the Database Window organizes all of the objects in the database?

A

The Objects Bar

B

The Groups Bar

C

The Favorites Bar

D

The Main Panel

10

What is the most fundamental object in an Access database, used for storing data?

A

Forms

B

Reports

C

Queries

D

Tables

11

In a table, what is a row that represents a complete set of information called?

A

Field

B

Column

C

Record

D

Datatype

12

In a table, what is a column that contains a specific piece of information within a record called?

A

Row

B

Field

C

Record

D

Cell

13

What database object is a statement that extracts specific information from the database?

A

Query

B

Form

C

Report

D

Macro

14

The output of a query is displayed in the form of a?

A

Form

B

Report

C

Table

D

Module

15

Which object is designed to make entering, updating, and deleting records in a table user-friendly?

A

Table

B

Report

C

Query

D

Form

16

Which object is used to retrieve and present data in a formatted, printable way?

A

Report

B

Form

C

Table

D

Page

17

What is a key difference between a Form and a Report?

A

Forms can edit data, while Reports are read-only

B

Reports can edit data, while Forms are read-only

C

Forms are for printing, Reports are for data entry

D

There is no difference

18

A macro in Access is used to automate what?

A

Database design

B

Repetitive tasks

C

Code compilation

D

Data analysis

19

A module contains an object that stores what kind of code?

A

SQL

B

HTML

C

VBA (Visual Basic for Applications)

D

Java

20

How can you exit the Access program properly?

A

Click on File, then Exit

B

Close the current table

C

Minimize the window

D

Disconnect from the internet

21

The graphical interface in the Relationship Window helps to visualize what?

A

Table data

B

Relationships between tables

C

Query results

D

Form layouts

22

What does MS-Access integrate with to create mail merges and charts?

A

Microsoft Office applications

B

Adobe Creative Suite

C

Web browsers

D

System utilities

23

What part of the Access window displays information like whether CAPS or NUM lock is on?

A

Title Bar

B

Menu Bar

C

Status Bar

D

Scroll Bar

24

To view the structure of a table, which view would you use?

A

Datasheet View

B

Layout View

C

Print Preview

D

Design View

25

To view the data within a table, which view would you use?

A

Design View

B

Relationship View

C

Datasheet View

D

SQL View

26

What kind of databases can you learn about from the sample databases included with Access?

A

Real-world tables, forms, queries, and reports

B

Theoretical database models

C

Empty database shells

D

Simple contact lists only

27

A query allows you to perform what on different fields?

A

Calculations

B

Formatting

C

Animations

D

File conversions

28

What does RDBMS stand for?

A

Relational Data-Based Management Software

B

Rapid Database Management System

C

Relational Database Management System

D

Robust Database Manipulation System

29

When you use a wizard to create a database, what can you do with the result?

A

Use it as is, without changes

B

Only view the data

C

Modify it to meet your own needs

D

Export it to Word only

30

The datasheet for a query is different from a table's datasheet because it can do what?

A

Only show one record at a time

B

Combine information from multiple tables

C

Never be sorted

D

Only show text data

31

What is the primary purpose of using a Form for data entry?

A

To make the user work directly with tables

B

To provide an easy method for entering and editing data

C

To automatically print every new record

D

To complicate the data entry process

32

Which of the following is NOT one of the seven main object types listed on the left side of the Database Window?

A

Tables

B

Queries

C

Forms

D

Charts

33

According to the text, a database is essentially an organized collection of what?

A

Pictures

B

Code

C

Data

D

Reports

34

When creating a new database file, what must you specify besides the name?

A

The number of tables

B

The primary key

C

A location or directory

D

The user password

35

What is the function of the scroll bars in the Access window?

A

To change font size

B

To move around the window if its contents do not fit

C

To adjust screen brightness

D

To run a query

36

The buttons on the toolbar can change depending on what?

A

The time of day

B

The user's permissions

C

The object selected

D

The version of Windows

37

When you open a table, which specific toolbar appears?

A

The Form Design toolbar

B

The Report Layout toolbar

C

The Table Datasheet toolbar

D

The Query Design toolbar

38

What is the term for a request to extract data from a database?

A

A report

B

A form

C

A query

D

A command

39

Who typically creates the user interface by designing Forms?

A

The end user

B

The database administrator

C

The application programmer

D

The system analyst

40

MS-Access is described as being more genuine a DBMS than programs like?

A

Microsoft Excel

B

Microsoft Works

C

SQL Server

D

Oracle

41

Data can be manipulated without data redundancy by defining what?

A

Relationships between sets of data

B

More fields in a single table

C

Complex data entry forms

D

Multiple copies of the database

42

Which button on the Title Bar would you use to close the MS-Access window in one step?

A

Minimize

B

Maximize

C

Restore

D

Close

43

Each word on the menu bar represents a different...?

A

Toolbar

B

Object

C

Menu

D

Property

44

What is the main function of the 'Open an existing file' option in the startup dialog box?

A

To create a new database

B

To access a database you have previously used

C

To run a wizard

D

To import data

45

If you re-create a database using the same name as an existing one, what will happen?

A

The two databases will merge

B

You will overwrite the work you have done

C

Access will prompt you to rename it

D

A backup will be created automatically

46

A field with which data type is automatically incremented by Access for each new record?

A

Number

B

Text

C

AutoNumber

D

Currency

47

In the sample student table, 'StudentID', 'FirstName', and 'City' are all examples of what?

A

Records

B

Tables

C

Databases

D

Fields

48

What does a query allow the user to do with records?

A

Select, filter, and sort them

B

Only delete them

C

Only add them

D

Archive them

49

Reports can be based on data from which sources?

A

Only tables

B

Only queries

C

Tables and queries

D

Only external files

50

The Database Window organizes all of the ______ in the database.

A

records

B

fields

C

objects

D

data types