wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS ACCESS

Total questions: 107

Worksheet time: 52mins

Name
Class
Date
1.

Tick the Functions of a Database

a)

Updating

b)

Sorting

c)

Editing

d)

Playing

2.

A computerized record keeping system is called as

a)

Communication system

b)

Database management System(DBMS)

c)

Networking System

3.

Which of the following is the correct definition of a Record?

a)

It has only one type of information

b)

Collection of Files

c)

All information about a single entity.

4.

Fields in database are similar to _________ in tables.

a)

Rows

b)

Columns

c)

Cells

d)

Values

5.

Which view of table is used to insert a field name in table.

a)

Date sheet

b)

Design

c)

Database

d)

all of the above

6.

The default extension of Ms-Access file is __________

a)

.acccdb

b)

.accdb

c)

.abccd

d)

.acbdc

7.

Which datatype will be used to generate numbers automatically while inserting data?

a)

Number

b)

Auto number

c)

Automatic Number

d)

Integer

8.
Which Application program saves data automatically as it is entered?
a)
MS Word
b)
PowerPoint
c)
MS Access
d)
MS Excel
9.
What kind of data type do you use when entering a Client Number?
a)
Short Text
b)
Currency
c)
Number
d)
Autonumber
10.
Client Name is an example of a:
a)
Field Name
b)
Record
11.

Each item from this list is classified as...

Name

Birthdate

Social Security No.

Street

City

State

Zip

a)

table

b)

record

c)

field/Attribute Name

d)

Data Type

12.
Everything on one row is a record.
a)
True
b)
False
13.

Table Rows are called...

a)

fields

b)

records

c)

table

d)

entry

14.

Table Columns are called...

a)

rows

b)

fields

c)

table

d)

form

15.

Which data type would be most suitable for the 'DateofBirth' field?

a)

Currency

b)

Number

c)

Date/Time

d)

Yes/No

e)

Memo

16.
Microsoft's version of a Database Management System
a)
Excel
b)
Access
c)
Word
d)
PowerPoint
17.

Where do you configure the field properties of a Table?

a)

Design View

b)

Datasheet View

c)

Access View

18.
A  list of records is a ____________.
a)
Table
b)
Field
c)
Guide
19.
The ___________field is exactly like number fields, but formatted to display decimal places and a currency symbol.
a)
text
b)
currency
c)
name
20.

The best data type to choose for a postcode would be

a)

Number

b)

Text

c)

Date/Time

d)

Currency

21.
What prevents duplicated data or NULL data from being entered in the same field?
a)
Data Preventer
b)
Primary Key
c)
Primary Lock
d)
Field Lock
22.
Which Application program saves data automatically as it is entered?
a)
MS Word
b)
PowerPoint
c)
MS Access
d)
MS Excel
23.
What kind of data type do you use when entering a Client Number?
a)
Short Text
b)
Currency
c)
Number
d)
Autonumber
24.
Client Name is an example of a:
a)
Field Name
b)
Record
25.
What is a Relationship in an MS Access Database?
a)
It makes the data easier to enter
b)
It prevents data from being entered incorrectly
c)
It makes you feel closer to the computer and it's capabilities 
d)
It connects two tables so that they can be used as one table
26.
What TAB is used to Created a Report, a Query, a Form or another Table?
a)
Design
b)
Home
c)
Database Tools
d)
Create
27.
What button is used to create a new Report?
a)
Report Wizard
b)
Blank Report
c)
Report
d)
Report Design
28.
When creating a Form, which drop-down button is used to locate the split form?
a)
Split-Form Drop-down
b)
Form Wizard
c)
Form Design
d)
More Forms Drop-down 
29.
To Enter Data in a Database showing only ONE record at a time, what must you create a:
a)
A Record
b)
A Report
c)
A Form
d)
A Querry
30.
In Access, What's the best way to give the boss a report of all the clients in a Client Table?
a)
Create a Query
b)
Create a Report
c)
Create A Form
d)
Create a Table
31.

What is a Primary key?

a)

Foreign Key

b)

Unique Key

c)

Database key

d)

all of the above

32.

Which one of the following is used for relating a table to anoutside key in other table?

a)

Relationship

b)

Manipulate

c)

Primary key

d)

Table structure

33.

A computerized record keeping system is called as

a)

Communication system

b)

Database management System(DBMS)

c)

Networking System

34.

What are tables responsible for?

a)

Store printable characters

b)

Format Information

c)

Storing info within the Database

d)

Create a user interface

35.

What can queries do? ( Choose any 3 )

a)

Filter

b)

Calculate

c)

Create table

d)

Sort

36.

A Primary cannot have _ values.

(a)  

37.

What does Ms. Access allow us to create and edit tables in which two forms?

a)

Datasheet view

b)

Primary view

c)

Design view

d)

Secondary view

38.

Which is not an element of a table?

a)

Fields

b)

Records

c)

Data

d)

Primary key

e)

Tables

39.

Does access allow us to sort data?

a)

True

b)

False

40.

What is memo used for??

a)

Enter Numeric Data

b)

Used to create text fields

c)

Store date and time values

41.

What are reports used for?

(a)  

42.

What is used to create a user interface?

a)

Text

b)

Forms

c)

Tables

d)

Primary Key

43.

Method that helps you find information quickly and easily

(a)  

44.
This database object is a primary container used to hold data in MS Access
a)
Query
b)
Form
c)
Table
d)
Report
45.

The Primary Key is a unique value for that column and hence, it cannot be the same for two ________________.

a)

Fields

b)

records

c)

Data

d)

None of these

46.

Each table must have only one column set as __________

a)

Foregin Key

b)

Primary Key

c)

Design Key

47.

To create a table, click on Create and then

a)

Forms

b)

reports

c)

queries

d)

Table

48.

The Primary Key is a __________ identifier for a record

a)

Distinct

b)

unique

c)

None of these

49.

Which field has primary key in the given table

a)

Address 1

b)

CustomerName

c)

Customer ID

50.

_______ is used to store alphanumeric data

a)

Text

b)

Number

c)

Date time

d)

Curency

51.

_______ is used to store numeric data

a)

Text

b)

Number

c)

Date time

d)

Curency

52.

If you want to enter the birth date of the student which data type will you use?

a)

Text

b)

Number

c)

Date time

d)

Curency

53.

Mr. Faris wants to save the price of the product he selling in the market so he used number datatype. Is he correct? Why?

a)

Yes, correct price is a number,

b)

No, not correct because price is a currency

c)

None of these

54.

The field name should not be more than _____characters

a)

60

b)

64

c)

66

d)

68

55.

__________can attach files such as pictures, documents, spreadsheets or charts

a)

Date/ Time

b)

Attachment

c)

Short Text

d)

Number

56.

The primary key field can never be blank or cannot contain a null value

a)

True

b)

false

57.

The patient_id, doctor_id, student_id can be primary keys because in each table, these fields will have a unique number

a)

True

b)

False

58.

The Primary Key is a unique identifier for a record

a)

True

b)

false

59.

•Click the field that you want to make a Primary Key

•On ________ tab, in Tool

     group click Primary Key

a)

Home

b)

Insert

c)

Design

60.

Arrange the following steps in correct sequence to create the Primary Key

1. On Design tab, in Tool group click Primary Key

2. Save the Table

3. Click the field that you want to make a Primary Key

a)

1,2,3

b)

3,2,1

c)

3,1,2

61.

To add records to a table, open

    the tables in _____________ View

a)

Datasheet view

b)

Design View

62.

To design a table, open

    the tables in _____________ View

a)

Datasheet view

b)

Design View

63.

§To Save a Database,

•Click the File tab and select the

    Save Database As option,

    the Save As dialog box appears,

    then in the File Name text box

    type the name of the database

•Click save

•The file will be saved with

    the extension .accdb

a)

True

b)

false

64.

This field can never be blank or cannot contain a __________value.

a)

Null

b)

stack

c)

Array

65.

A database helps you to organise the collected data in a _____format in a systematic manner

a)

Tabular

b)

Linear

66.

What are the steps to create a blank database?

a)

Start  ---------->  Ms. Access 2010  --------->  Blank web database

b)

New  ---->   Blank database  ---->   Filename   ---->  Create

c)

Design tab---- blank---- start button

67.

What is application in Microsoft Office for making database?

a)

ms word

b)

ms access

c)

ms excel

d)

ms power point

68.

Question 1: Each column in the database table is a

a)

Form

b)

Query

c)

Record

d)

Field

69.

Question 1: Each column in the database table is a

a)

Form

b)

Query

c)

Record

d)

Field

70.

Question 2: Access is a _______program

a)

Spreadsheets

b)

Word Process

c)

Database Management

d)

Desktop Publishing

71.

Question 3: Each row in a database table is a

a)

Record

b)

Field

c)

Report

d)

Filter

72.

Question 4: This database object is arranged in rows and columns and looks similar to an Excel worksheet.

a)

Form

b)

Query

c)

Report

d)

Table

73.

Question 5: It is best to have a purpose statement before designing a database.

a)

True

b)

False

74.

Question 1: A query can include fields from more than one table

a)

True

b)

False

75.

Question 2: Columns are horizontal

a)

True

b)

False

76.

Question 3: DBMS is use to duplicate a data

a)

True

b)

False

77.

Question 4: If we are using Queries it always show all the tables.

a)

True

b)

False

78.

Question 5: What data type could you use for a field when user needs to input a price?

a)

Number

b)

Yes/No

c)

Currency

d)

Date/Time

79.

Recap #1: A good database design helps ensure that your data is what?

(Pick one answer.)

a)

Always backed up.

b)

Complete and accurate.

c)

Duplicated so it’s easier to find

80.

Recap #2: What is the function of a primary key? (Pick one answer.)

a)

To uniquely identify each record in a table.

b)

To encrypt and decrypt your database.

c)

To help ensure you enter data in the correct table.

81.

Recap #3: How many tables should a well-designed database contain? (Pick one answer.)

a)

As many as necessary to capture all your data without redundancy.

b)

One, with many fields.

c)

Two

d)

Three

82.

A Report is an effective way of presenting your data in an organized format

a)

True

b)

False

83.

Most widely used Database is:

a)

Network DBMS

b)

Relational DBMS

c)

Microsoft Access

84.

Which database consists of Fields, Records and Tables?

a)

Network DBMS

b)

Hierarchical DBMS

c)

Relational Database

85.

Extension of MS Access is

a)

.ACCESS

b)

.ACCDB

c)

.ASSDB

86.

Tick the Functions of a Database

a)

Updating

b)

Sorting

c)

Editing

d)

Playing

87.

A computerized record keeping system is called as

a)

Communication system

b)

Database management System(DBMS)

c)

Networking System

88.

Which of the following is the correct definition of a Record?

a)

It has only one type of information

b)

Collection of Files

c)

All information about a single entity.

89.

Full form of RDBMS is

a)

Relational Database Management System

b)

Rotational Database Maintenance System

c)

Record Management System

90.

Student's Roll no is an example of

a)

Primary Key

b)

Secondary Key

91.

When you close a new table, it asks you for what

a)

name of the file

b)

where to save it

c)

nothing

92.

A unique identifier used in creating a table that assures there will be no duplicate data.

a)

Primary Key

b)

Query

c)

Data Type

93.

Ms-Access is a ___________ database

a)

Flat File

b)

Relational

c)

Object Oriented

d)

Flat

94.

Fields in database are similar to _________ in tables.

a)

Rows

b)

Columns

c)

Cells

d)

Values

95.

What you understand by data redundancy?

a)

Assurance of the accuracy of data

b)

Duplicate values in database

c)

Security of Data

d)

None of these

96.

Which view of table is used to insert a field name in table.

a)

Date sheet

b)

Design

c)

Database

d)

all of the above

97.

Which option is used to display the data in printable format in MS-Access?

a)

Report

b)

Query

c)

Datesheet

d)

Relationship

98.

Which datatype will be used to generate numbers automatically while inserting data?

a)

Number

b)

Auto number

c)

Automatic Number

d)

Integer

99.
Which Application program saves data automatically as it is entered?
a)
MS Word
b)
PowerPoint
c)
MS Access
d)
MS Excel
100.

Table Columns are called...

a)

rows

b)

fields

c)

table

d)

form

101.

Table Rows are called...

a)

fields

b)

records

c)

table

d)

entry

102.

Which data type would be most suitable for the 'DateofBirth' field?

a)

Currency

b)

Number

c)

Date/Time

d)

Yes/No

e)

Memo

103.

Explain Data redundancy

a)

Correctness of data

b)

Unnecessary duplication of data

c)

Data which can be true/ false only

104.

A data type to store numeric data

a)

Number

b)

Text

c)

Memo

105.

__________are building blocks of a database.

a)

Reports

b)

Query

c)

Tables

106.

A data type to store short messages.

a)

Number

b)

Memo

c)

Yes/No

107.

Data integrity means

a)

Correctness of data

b)

Duplication of data

c)

Data Type

Similar Resources on Wayground

LATIHAN SOAL MS WORD

110 questions

LATIHAN SOAL MS WORD

quiz

Worksheet

•

1st - 5th Grade

Đấu trường lịch sử

108 questions

Đấu trường lịch sử

quiz

Worksheet

•

1st Grade

аяуы

103 questions

аяуы

quiz

Worksheet

•

1st - 5th Grade