wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS Access Quiz

Total questions: 101

Worksheet time: 51mins

Name
Class
Date
1.

Operation with the data which is used to arrangement

a)

sorting of data

b)

archiving of data

c)

organization of data

d)

transmission of data

e)

formalization of data

2.

MS Access. Functions of commands in 'Datasheet' tab

a)

are intended for working with tables

b)

provide supporting of created databases

c)

provide creating basic components of database

d)

are intended for organization exchange with external data

3.

MS Access. Connected fields have

a)

two files but different types of data

b)

one file but different type of data

c)

different names and different types of data

d)

the same name but different type of data

e)

different names but the same type of data

4.

MS Access. 'Create' tab allows

a)

split the table, query and report

b)

perform auto format of the table

c)

create new table, form, report, query, macro and module

d)

create the page, form, template, report, query, slide and database

e)

create new table, template, resume, query, slide and new database

5.

MS Access. Change the table structure

a)

table wizard

b)

design view

c)

datasheet view

d)

create new table

e)

open the table and rename fields

6.

MS Access. A major database object used to display information in an attractive, easy-to-read screen format

a)

table

b)

form

c)

report

d)

query

e)

macros

7.

MS Access. For copying records it's necessary to select records and perform following command

a)

home - font - copy

b)

create - reports - copy

c)

home - data collection - insert

d)

home - clipboard - copy

e)

external data - clipboard - cut

8.

MS Access. The function of 'AutoNumber' in 'ID' field of database

a)

number the table

b)

sum of form numbers

c)

sum of report numbers

d)

auto input of sequential numbers

e)

number of form records in consecutive order

9.

There are in working area of MS Access:

a)

desktop, task area

b)

working area, task pane

c)

status bar, start button

d)

menu bar, toolbar

e)

database window and its objects windows

10.

Commands of 'Database tools' tab

a)

forms, reports, analyze and others

b)

Import, export, collect data, analyze

c)

macro, show/hide, analyze, move data

d)

rich text, clipboard, records, sort and filter, find

e)

tables, clipboard, font, show and hide, find, representation

11.

MS Access. Records are sorted in increasing order

a)

12, 144, 245, 53, 94

b)

$10, $25, $35, $50

c)

Lily, Rose, Carnation, Aster

d)

Folder, Directory, Container

e)

10/12/96, 02/12/98, 02/11/97, 14/10/99

12.

MS Access. Logical operator 'not' is used to select

a)

coincident files

b)

coincident values

c)

coincident queries

d)

in coincident values

e)

coincident first symbols

13.

MS Access. Logical operator 'not Т' is used for select

a)

words which contain letter 'Т'

b)

words which end with letter 'Т'

c)

words which begin from letter 'Т'

d)

words which do not contain letter 'Т'

e)

words which do not begin from letter 'Т'

14.

MS Access. Logical operator 'С asterics' is used for select

a)

words which contain letter 'С'

b)

words which end with letter 'С'

c)

words which begin from letter 'С'

d)

words which do not contain letter 'С'

e)

words which do not begin from letter 'С'

15.

MS Access. Logical operator '[B-C]' is used for select

a)

words which contain letter 'D'

b)

words which begin from letter 'В'

c)

words which don't contain letter 'В'

d)

words which end with letters 'В', 'С', 'D'

e)

words which begin from letters 'В', 'С', 'D'

16.

MS Access. Query is intended for

a)

storing the database

b)

creating relationships

c)

deleting the document

d)

present data in printing view

e)

output data and rename the document

17.

MS Access. Form is intended for

a)

printing the document

b)

extract data from tables

c)

present data in printing view

d)

output data and display on the screen

e)

input data and perform acts defined the entered data

18.

MS Access. The command of sorting text fields in descending order

a)

home - sort and filter - descending

b)

home - sort and filter - ascending

c)

datasheet view - font - sort on descending

d)

external data - sort and filter - ascending

e)

datasheet view - fields and columns - sort on ascending

19.

MS Access. Database field

a)

some area of database

b)

set of values relating to records

c)

set of values for one element of the object

d)

set of values which satisfy of a given criteria

e)

concept describing one chosen property of an object

20.

MS Access. Tables of database are intended for

a)

storing data

b)

printing data

c)

deleting of data

d)

manipulation of data

e)

output data on the screen

21.

MS Access. For deleting records it's necessary to select records and perform

a)

create - font - delete

b)

home - records - delete

c)

home - collect data - insert

d)

home - clipboard - delete

e)

external data - record

22.

For searching data it's necessary to perform command

a)

home - find - find

b)

create - find - find

c)

home - find - delete

d)

home - data collection - insert

e)

external data - records - find

23.

The command of sorting text fields in ascending order

a)

home - sort and filter - descending

b)

home - sort and filter - ascending

c)

datasheet view - font - sort on descending

d)

external data - sort and filter - ascending

e)

datasheet view - fields and columns - sort on ascending

24.

Query is intended for

a)

input data and delete the document

b)

rename the document and input data

c)

output data and rename the document

d)

filter data, perform calculations and summarize the data

e)

delete unnecessary data and display other data on the screen

25.

Group 'Forms' is located on tab

a)

home

b)

create

c)

external data

d)

datasheet mode

e)

work with database

26.

According to formation method queries are grouped

a)

currency, simple, linear

b)

text, with a parameter, an auto query, numeric

c)

linear, auto reports, auto forms, simple, dependent

d)

on a sample, with a parameter, crosstab, simple

e)

circle, the linear, numeric, an auto request, monetary, the report

27.

The sequence of commands for formation of queries of the Create tab

a)

list - datasheet

b)

others - report design

c)

others - query design

d)

tables - query design

e)

views - query design

28.

Logical operator

a)

dor

b)

eqv

c)

null

d)

true

e)

not

29.

Creating of database

a)

toolbar - create the database

b)

file - create - open the database

c)

edit - create - open the database

d)

"Office" button- create - new database

e)

create - "Office" button - create the database

30.

Database management systems

a)

Ms Excel, Supercalc, Turbopascal, Ms Access

b)

Clipper, Paradox, Foxpro, Foxbase, Ms Access

c)

Inereader, Prompt98, Qtrans, Foxbase, Excel, Paradox

d)

Ms Word, Wordperfect, Total Commander, Ms Access

e)

Ms Powerpoint, Ms Access, Outlook Express, Total Commander

31.

To extract necessary data from one or several tables is used

a)

fields

b)

forms

c)

reports

d)

records

e)

queries

32.

Group 'Fields&Columns' is located on ___ tab

a)

home

b)

create

c)

external data

d)

datasheet view

e)

data tools

33.

Short keys of 'Minimize and maximize the ribbon'

a)

Shift F6

b)

Alt Tab

c)

Ctrl F1

d)

Shift Tab

e)

Shift F10

34.

Set of tools which is displayed when choosing 'Home' tab

a)

clipboard, paragraph, text, views, font

b)

create, records, sort and filter, alignment, find, styles

c)

clipboard, tables, views, text, find, pages, editing

d)

views, clipboard, font, text, records, sort and filter, find

e)

font, pages, views, clipboard, styles, alignment, find, text

35.

'Open' command of 'Office' button allows to

a)

save data in a table

b)

look at data in a table

c)

open the created table

d)

open the «editing» window

e)

open the created database

36.

Database which can be used in several spheres of human activity

a)

universal

b)

specialized

c)

public

d)

single purpose

e)

multipurpose

37.

How to type criteria '<80 or >50' in a query?

a)

<80, >50

b)

<80 or >50

c)

<80=>50

d)

less than 80 and greater than 50

e)

less than 80 or greater than 50

38.

Query design window has two parts. The upper part shows

a)

criteria

b)

sorting check boxes

c)

name of fields, field type and size

d)

properties and format of the field

e)

tables with fields and relationships between tables

39.

To change the size of text field from 255 to 50 symbols in MS Access table it's necessary:

a)

in design view change fields type

b)

in design view change the criteria

c)

in design view change fields property

d)

in datasheet view change fields property

e)

in datasheet view change format of the field

40.

To create parameter query which displays name of the doctor, it's necessary to write:

a)

[Enter doctor's name]

b)

(Enter doctor's name)

c)

{Enter doctor's name}

d)

/Enter doctor's name/

e)

<Enter doctor’s name>

41.

MS Access is

a)

a shell

b)

system

c)

teaching tool

d)

accessory program

e)

application software

42.

Columns and rows in MS Access are called

a)

forms, fields

b)

cells, records

c)

fields, records

d)

columns, records

e)

columns, fields

43.

The extension of database

a)

.txt, .doc

b)

.exe, .mdb

c)

.bat, .accdb

d)

.bmp, .accdb

e)

.mdb, .ассdb

44.

Database management system represents the program which is included into

a)

hardware

b)

operating system

c)

system of programming

d)

unique program software

e)

application program software

45.

MS Access. «Asterisk» symbol means

a)

new field

b)

new file

c)

new number

d)

new record

e)

new column

46.

MS Access. The type of a field is set in

a)

pages

b)

tables

c)

reports

d)

design View

e)

datasheet View

47.

MS Access. The maximum number of text field signs

a)

225

b)

155

c)

355

d)

455

e)

255

48.

MS Access. Command «Rename the table»

a)

F6

b)

F1

c)

F4

d)

F5

e)

F2

49.

MS Access. Name of the field with space

a)

6 signs

b)

4 signs

c)

50 signs

d)

10 signs

e)

64 signs

50.

MS Access. Data type

a)

reporting

b)

number

c)

symbol

d)

cycle

e)

graphic

51.

MS Access. Maximum numbers of symbols in «Memo» field

a)

65 500

b)

65 000

c)

65 536

d)

650 563

e)

65 0000

52.

Relational database is the database which

a)

has file structure

b)

describes spreadsheets

c)

has Boolean algebra as a base of it

d)

connects data by means of physical indicators

e)

consists of two dimensional table connected with themselves logically

53.

The following operation is performed with records

a)

sort

b)

projecting

c)

forecasting

d)

exploitation

e)

searching on key

54.

MS Access program is constructed on the base

a)

C

b)

Lisp

c)

Html

d)

MS Excel spreadsheets

e)

relational model of database management

55.

The main object of database is

a)

form

b)

table

c)

macro

d)

module

e)

template

56.

Creating of database includes

a)

stage of copying slides

b)

stage of output and project data

c)

stage of database project and input data

d)

stage of defining and deleting information

e)

stage of transmission and deleting of document

57.

The main types of MS Access models

a)

basic

b)

cyclic

c)

standard

d)

application

e)

relational

58.

MS Access. Objects of database

a)

sort, filter

b)

book, sheets

c)

records, fields

d)

queries, tables

e)

investment, model

59.

MS Access. Types of data

a)

text

b)

financial

c)

graphical

d)

fractional

e)

percentage

60.

MS Access. Type of query

a)

logic

b)

classic

c)

empty

d)

separate

e)

parameter

61.

MS Access. Methods of creating tables

a)

table wizard

b)

simple table

c)

project table

d)

classic table

e)

table design

62.

MS Access. Types of reports

a)

number

b)

project

c)

simple report

d)

classic

e)

report design

63.

MS Access. Possible size of number field

a)

serial

b)

number

c)

integer

d)

financial

e)

percentage

64.

MS Access. To start program it's necessary

a)

Start - Accessories - MS Office - MS Office Access

b)

Start - All programs - MS Office - MS Office Access

c)

Start - All programs - Accessories - MS Office Access

d)

Context menu - Create - MS Office Access 2007 Database

e)

Start - Accessories - Application programs - MS Office Access

65.

MS Access. The following operation is performed with queries

a)

filtration

b)

projecting

c)

forecasting

d)

exploitation

e)

searching on key

66.

MS Access. Methods of creating query

a)

classic

b)

simple

c)

project

d)

query wizard

e)

Share Point lists

67.

MS Access. Methods of creating forms

a)

form wizard

b)

simple form

c)

project form

d)

logic form

e)

classic form

68.

Technology which distributes information from the server to the client, used on mobile devices

a)

virtualization

b)

online conference

c)

computing clouds

d)

mobile push-notification messages

e)

micronuclear architecture of a hypervisor

69.

A model of providing cloud computing for access to use of operating systems and database management system

a)

Software as a Service

b)

Infrastructure as a Service

c)

Platform as a Service

d)

Storage as a Service

e)

Management as a Service

70.

To create profiles in the cloud use Google Docs

a)

documents

b)

tables

c)

presentations

d)

forms

e)

my cards

71.

To work with one Google Document in online mode it is necessary for group of users

a)

remove the restriction

b)

create a conference

c)

open online chat

d)

create 'circles friends'

e)

open shared access

72.

To create Google Presentation in the cloud it is necessary

a)

create mail.ru

b)

have a Google account

c)

be a Google Hangout User

d)

have access to social networks

e)

know the programming language

73.

The place where various information on the user is stored

a)

cloud

b)

browser

c)

account

d)

mailservice

e)

questionnaire

74.

Defect of a cloud computing is

a)

flexibility

b)

renting

c)

economyy

d)

availability and mobility

e)

not controllability of data

75.

The convenient environment for processing and storage of various formats information with user support of the Internet

a)

social networks

b)

development environment

c)

mobile services

d)

operating system

e)

cloud technologies

76.

Information and communication technologies are

a)

social science

b)

applied science

c)

medical science

d)

humanity

e)

fundamental

77.

Technology which distributes information from the server to the client, used on mobile devices

a)

virtualization

b)

online conference

c)

computing clouds

d)

mobile push-notification messages

e)

micronuclear architecture of a hypervisor

78.

It is possible to change a profile photo, entering in service

a)

play

b)

disc

c)

email

d)

google

e)

translator

79.

To work with the documents of GOOGLE you need to enter in service

a)

email

b)

search

c)

disk

d)

calendar

e)

my account

80.

To create questionnaires are used Google documents

a)

forms

b)

tables

c)

my cards

d)

documents

e)

presentations

81.

To work with one Google document in online mode group of users has to:

a)

lift a limit

b)

open an online chat

c)

create a conference

d)

open shared access

e)

create 'circles friends'

82.

Mobile application is:

a)

service

b)

software

c)

data storage

d)

cloud calculation

e)

developing environment

83.

Portable multi-function device of mobile communication

a)

netbook

b)

tablet (pad)

c)

bluetooth

d)

monoblock

e)

smartphone

84.

The international organization defining recommendations in the field of telecommunications and radio

a)

ITU

b)

LTE

c)

APPLE

d)

GPS

e)

IES

85.

The largest software developer, the creator a web - service Elastic Computer Cloud (EC2):

a)

Kcell

b)

Apple

c)

Gmail

d)

Amazon

e)

EPAM Systems

86.

How many levels of cloud technologies are exist:

a)

2

b)

4

c)

5

d)

3

e)

6

87.

Level of cloud technologies. Platform as a Service - PaaS)

a)

auxiliary level

b)

infrastructure level

c)

top level of appendices

d)

the lowest level of a platform

e)

intermediate level of a platform

88.

Global system of coordinates determination

a)

GPS

b)

GSM

c)

LTE

d)

Gmail

e)

FTP

89.

The system which allows to make calls and send messages

a)

GPS

b)

GSM

c)

Symbian

d)

Tizen

e)

iOS

90.

Google services

a)

ICQ, Internet

b)

Cloud

c)

Mailing, E-services

d)

Google+, My account

e)

Documents

91.

In GOOGLE.com it is possible to create

a)

report, schemes

b)

queries, reports

c)

catalogs, books

d)

programs, documents

e)

documents, presentations

92.

Cybersecurity. Information security from illegal access

a)

installation of the anti-virus program

b)

each user of system shall have the personal password

c)

assignment of responsible persons for information output

d)

to define an information access only for a manual of MPI

e)

each user shall have the computer for operation with system

93.

Cybersecurity. The main types of computer viruses

a)

hardware, file

b)

load, resident

c)

non-resident, not dangerous

d)

program, load, macro viruses

e)

file - load, not dangerous, resident

94.

Cybersecurity. Antivirus programs

a)

Eset, MS Access

b)

MS Word, MS Excel

c)

ZIP, MS Power Point

d)

AidsTest, Kaspersky Kav

e)

MS DOS, DoctorWeb, RAR

95.

Cybersecurity. Formats of executed files

a)

.doc, .bat

b)

.jpg, .txt, .doc

c)

.bmp, rar, html

d)

.exe, .com, .bat

e)

xls, zip, .doc, .bat

96.

Cybersecurity. Depending on the habitat computer viruses are divided as

a)

resident, non-resident

b)

harmless, dangerous, very dangerous

c)

network, file, loading, file and loading

d)

detectors, doctors, auditors, filters, vaccines

e)

parasitic, replicators, invisible beings, mutants, trojan

97.

Cybersecurity. On a way of infection computer viruses are divided as

a)

resident, non-resident

b)

harmless, dangerous, very dangerous

c)

network, file, loading, file and loading

d)

detectors, doctors, auditors, filters, vaccines

e)

parasitic, replicators, invisible beings, mutants, trojan

98.

Cybersecurity. MS Windows. File characteristics

a)

changing, moving and deleting the file

b)

copying, moving, deleting file and attributes

c)

date of moving of the file, creation date and time

d)

renaming, moving, deleting file and time of creation

e)

file name, creation date and time, file size and attributes

99.

Cybersecurity. Stealth viruses

a)

infect drivers

b)

infect boot sectors

c)

hide their presence

d)

destroy all information

e)

display the graphic drawing

100.

Cybersecurity. The way of virus detection includes

a)

scanning

b)

copying files

c)

heuristic analysis

d)

record of all files volume

e)

checking of executing files

101.

Cybersecurity. Computer can be infected with the virus

a)

on incorrect loading

b)

when loading drivers

c)

when text program is working

d)

when executing the infected program

e)

when inserting a floopy disk into the disk drive

Similar Resources on Wayground

Final Exam Review 2025

105 questions

Final Exam Review 2025

quiz

Worksheet

•

7th Grade - University

APES AP Environmental 6 Energy

99 questions

APES AP Environmental 6 Energy

quiz

Worksheet

•

12th Grade

POA 17.1 Forestry Production TEST

105 questions

POA 17.1 Forestry Production TEST

quiz

Worksheet

•

KG - 12th Grade

E.M. spectrum and light waves

100 questions

E.M. spectrum and light waves

quiz

Worksheet

•

8th Grade - University

TEMA 9 ANGKASA

100 questions

TEMA 9 ANGKASA

quiz

Worksheet

•

10th - 12th Grade

Biology SOL Review

100 questions

Biology SOL Review

quiz

Worksheet

•

9th - 12th Grade

Midterm Review

100 questions

Midterm Review

quiz

Worksheet

•

9th - 12th Grade

Medical Terminology Fall Final Exam

100 questions

Medical Terminology Fall Final Exam

quiz

Worksheet

•

9th - 12th Grade