wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Database Concepts and MS Access Operations

Total questions: 72

Worksheet time: 36mins

Name
Class
Date
1.

Through which command can the default size of the text field be set to 200200 ?

a)

Account

b)

Options

2.

The Delivery table must be in what type of relationship?

a)

One-to-one

b)

One-to-many

c)

Many-to-many

d)

No relationship

3.

What must be true of the common field between two linked tables?

a)

It must be of the same data type in both tables.

b)

It must have different data types in each table.

c)

It must be AutoNumber in both tables.

d)

It must be numeric in one table and text in the other.

4.

Exported data in text format can be opened in which application?

a)

Word

b)

Excel

c)

PowerPoint

d)

Access

5.

Which tab allows you to create a new table?

a)

Create

b)

Home

c)

External Data

d)

Database Tools

6.

Through which command can you get information about the database?

a)

Account

b)

Options

c)

Information

d)

Database Tools

7.

Which query type is used to retrieve data directly as it is?

a)

Selection query

b)

Update query

c)

Append query

d)

Delete query

8.

Which query type is used to retrieve data directly as it is?

a)

Selection query

b)

Crosstab query

c)

Make-table query

d)

Parameter query

9.

Who is responsible for controlling all the permissions and uses of the database?

a)

Database administrator

b)

Application programmer

c)

End user

d)

Report designer

10.

Whose responsibility is it to analyze the requirements of the entity that will use the system and then determine all the data?

a)

Application programmer

b)

Database administrator

c)

End user

d)

System operator

11.

Who identifies user requirements and develops specifications to determine what is required from the databases?

a)

System analyst

b)

Database administrator

c)

Network engineer

d)

Report designer

12.

From which place can the database be compressed and repaired?

a)

File menu

b)

Database Tools tab

c)

External Data tab

d)

Home tab

13.

To compact and repair the database, which command is used?

a)

Compact and Repair Database

b)

Backup Database

c)

Convert Database

d)

Split Database

14.

From which tab can the database be compressed and repaired?

a)

DATABASE TOOLS

b)

HOME

c)

CREATE

d)

EXTERNAL DATA

15.

From which tab can the database be compressed and repaired according to the statement?

a)

External Data

b)

Home

c)

Create

d)

Database Tools

16.

You can create a relationship between two tables from which area?

a)

Database Tools tab (Relationships)

b)

Home tab

c)

Create tab (Forms)

d)

External Data tab

17.

Data processing produces other data by merging more than one field together into a new table. What does this describe?

a)

Creating a new table by merging fields

b)

Deleting records

c)

Formatting reports

d)

Changing data types

18.

Database data can be exported to a text file from which tab?

a)

External Data

b)

Create

c)

Home

d)

Database Tools

19.

Which view displays actual data?

a)

Form View

b)

Design View

c)

Layout View

d)

Report View

20.

Which command is used to show information about the database such as the number of tables, queries, and forms it contains?

a)

Information

b)

Account

c)

Options

d)

Relationships

21.

Through which command can we get information about the database from the number of tables, queries, and the cells it contains?

a)

Information

b)

Account

c)

External Data

d)

Create

22.

Through which command can we get information about the database?

a)

Information

b)

Relationships

c)

Options

d)

Navigation Pane

23.

How are tables linked to each other in a database according to the description?

a)

Using a foreign field in one table and a corresponding field in another table that share the same value

b)

Using identical table names

c)

Using report templates

d)

Using the navigation pane

24.

To retrieve data as it is, which query type is used?

a)

Selection query

b)

Append query

c)

Update query

d)

Delete query

25.

Which query is used to retrieve data from one or more tables?

a)

Selection query

b)

Make-table query

c)

Append query

d)

Delete query

26.

Data can be added to be saved in the table through which query?

a)

Append query

b)

Update query

c)

Delete query

d)

Selection query

27.

Which query calculates the sum or average of the collected data?

a)

Totals query

b)

Delete query

c)

Append query

d)

Update query

28.

To delete one or more student records, which should be selected?

a)

Delete query

b)

Update query

c)

Append query

d)

Selection query

29.

To remove records for graduating students from the students table, which action should be used?

a)

Delete query

b)

Update query

c)

Append query

d)

Make-table query

30.

To calculate and reconstruct data for easier analysis, which query should be used?

a)

Crosstab query

b)

Append query

c)

Delete query

d)

Selection query

31.

The student's relationship with academic subjects is a relationship of what type?

a)

One-to-many

b)

One-to-one

c)

Many-to-many

d)

No defined relationship

32.

Can a form be created directly from a table without all of its fields appearing?

a)

Yes

b)

No

33.

What should you use to create relationships between tables?

a)

Relationships command

b)

Report Wizard

c)

Navigation Pane

d)

Table Design

34.

To create a ready-made database for a store, what should you choose?

a)

Sample templates

b)

Blank Database

c)

Import External Data

d)

Report Wizard

35.

What is the default database provided by Access called?

a)

Blank Database

b)

Sample Database

c)

Starter Database

d)

Template Database

36.

Can arithmetic or logical operations be performed on numerical values in data stored in databases?

a)

Yes

b)

No

37.

After exporting reports in TXT format, can they be modified using a word processor program?

a)

Yes

b)

No

38.

What is the requirement that data in the primary key field of the primary table must be present in the foreign key field of the secondary table called?

a)

Referential integrity

b)

Data redundancy

c)

Normalization

d)

Denormalization

39.

What is the stated importance of the navigation pane?

a)

Facilitating report printing and obtaining a copy of the database data

b)

Creating relationships between tables

c)

Designing queries

d)

Editing table fields

40.

When creating a relationship, what must match between the primary key field and the foreign field?

a)

Data type and size

b)

Field captions

c)

Index names

d)

Default values

41.

What is the maximum required length for a field name according to the statement?

a)

6464 characters

b)

6767 characters

c)

7272 characters

d)

255255 characters

42.

It is required that the length of the field name does not exceed …

a)

32 characters

b)

64 characters

c)

128 characters

d)

255 characters

43.

Tables can be created by importing a table from another program, such as a word processor.

a)

True

b)

False

44.

A command found in the File tab used to save the database with new name.

a)

Save

b)

Save As

c)

Export

d)

Compact & Repair

45.

The report can be viewed after naming it.

a)

True

b)

False

46.

The report can be viewed before naming it.

a)

True

b)

False

47.

When the required property is set to YES, a value must be entered.

a)

True

b)

False

48.

Normalization rules ensure the accuracy of repeated data.

a)

True

b)

False

49.

Reports are created through the Design menu and then Create Report.

a)

True

b)

False

50.

The layout of the report form can be specified detailed type.

a)

True

b)

False

51.

It is possible to specify the report formatting layout as a detailed type.

a)

True

b)

False

52.

Export steps cannot be saved.

a)

True

b)

False

53.

The relationship of a student to academic results is a one-to-many relationship.

a)

True

b)

False

54.

The main window of the database consists of … sections.

a)

two

b)

three

c)

four

d)

five

55.

Form is a question about the data stored in a table.

a)

True

b)

False

56.

The form is used to enter data and display all records at once.

a)

True

b)

False

57.

The … tab contains an Analysis group.

a)

Home

b)

Create

c)

Database Tools

d)

External Data

58.

Intermediate Table is used in … Relationship.

a)

one-to-one

b)

one-to-many

c)

many-to-many

d)

self-relationship

59.

The result obtained from processing data …

a)

data

b)

information

c)

field

d)

record

60.

A single table cannot exist without being connected to another table, otherwise we would not be able to describe this as a database.

a)

True

b)

False

61.

The split form is used to create a form that includes data from several fields from several tables linked together in the same database.

a)

True

b)

False

62.

The data in the table can be formatted using … tab

a)

Home

b)

Create

c)

External Data

d)

Database Tools

63.

Reports are objects for displaying and printing data.

a)

True

b)

False

64.

The data for the report is modified before it is printed if new data is added.

a)

True

b)

False

65.

It is preferable that the key column fields be …

a)

long text fields

b)

AutoNumber

c)

frequently edited values

d)

duplicate-friendly values

66.

To change the dimensions of the background so that it is suitable for the existing space, Click on the … Sheet, then from the Details list, choose Form.

a)

Field List

b)

Property Sheet

c)

Navigation Pane

d)

Report View

67.

A primary key in a table (non-duplicate primary key) and it can be replaced with another alternative field.

a)

True

b)

False

68.

Query is a question about the data stored in your tables or a request to perform an action on the data.

a)

True

b)

False

69.

Use … as a databases program to store, update, and retrieve data.

a)

Microsoft Word

b)

Microsoft Access

c)

Microsoft PowerPoint

d)

Adobe Photoshop

70.

To import data from another file, use …… tab.

a)

Home

b)

Create

c)

External Data

d)

Database Tools

71.

TO add a background to the form, follow these Steps:

a)

Open the form in Design View, open Property Sheet, set the Picture property

b)

Install an add‑in from Office Store and apply a theme

c)

Run Report Wizard and select a background style

d)

Change the database theme only without editing the form

72.

The field that distinguishes records from other records and consists of only one field.

a)

Foreign key

b)

Primary key

c)

Composite key

d)

Candidate key