wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Икт сессия 💯 100

Total questions: 100

Worksheet time: 50mins

Name
Class
Date
1.

Operation with the data which is used to arrangement

a)

sorting of data

b)

organization of data

c)

Archiving of data

d)

Transmissin of data

2.

MS Access. Functions of commands in “Datasheet” tab

a)

Home" commands of МS Аccess

b)

are intended for organization exchange with external data

c)

provide supporting of created databases

d)

provide creating basic components of database

e)

are intended for working with tables

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)

different names but the same type of data

e)

the same name but different 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 new table, template, resume, query, slide and new database

e)

create the page, form, template, report, query, slide and 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)

macro, show/hide, analyze, move data

c)

Import, export, collect data, analyze

d)

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

e)

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

11.

MS Access. Records are sorted in increasing order

a)

12, 144, 245, 53, 94

b)

10, $25, $35, $50

c)

Folder, Directory, Container

d)

Lily, Rose, Carnation, Aster

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.

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 end with letters «В», «С», «D»

d)

words which don’t contain letter «В»

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)

datasheet view – fields and columns – sort on ascending

e)

external data – sort and filter – ascending

19.

MS Access. Database field

a)

some area of database

b)

set of values relating to records

c)

set of values which satisfy of a given criteria

d)

set of values for one element of the object

e)

concept describing one chosen property of an object

20.

Tables of database are intended for

a)

storing data

b)

deleting of data

c)

printing 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 - records - delete

22.

MS Access. For searching data it’s necessary to perform command

a)

create - find - find

b)

home - find - find

c)

home - find - delete

d)

home - data collection - insert

e)

external data - records - find

23.

MS Access. 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.

MS Access. 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)

delete unnecessary data and display other data on the screen

e)

filter data, perform calculations and summarize the data

25.

MS Access. Group "Forms" is located on tab

a)

home

b)

create

c)

external data

d)

datasheet mode

e)

work with database

26.

MS Access. 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)

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

e)

on a sample, with a parameter, crosstab, simple

27.

MS Access. 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.

MS Access. Logical operator

a)

dor

b)

Eqv

c)

Null

d)

Not

29.

Creating of database

a)

toolbar – create the database

b)

edit – create – open the database

c)

file – 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.

MS Access. To extract necessary data from one or several tables is used

a)

fields

b)

forms

c)

reports

d)

records

e)

queries

32.

МS Access. Group "Fields&Columns" is located on ___ tab

a)

home

b)

create

c)

external data

d)

datasheet view

e)

data tools

33.

MS Аccess. Short keys of "Minimize and maximize the ribbon

a)

Shift F6

b)

Alt Tab

c)

Ctrl F1

d)

Shift Tab

e)

Shift F10

34.

MS Access. 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.

МS Аccess. "Open" command of "Оffice" button allows to

a)

save data in a table

b)

open the created table

c)

look at data in a 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.

МS Аccess 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)

columns, records

d)

fields, records

e)

columns, fields

43.

MS Аccess. 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 Аccess. «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)

design View

d)

datasheet View

e)

reports

47.

MS Аccess. The maximum number of text field signs

a)

225

b)

155

c)

355

d)

455

e)

255

48.

MS Аccess. Command «Rename the table»

a)

F1

b)

F5

c)

F6

d)

F2

49.

*!MS Access. Name of the field with space

a)

6 signs

b)

10 signs

c)

54 signs

d)

64 signs

50.

*!MS Аccess. Data type

a)

reporting

b)

number

c)

symbol

d)

graphic

51.

MS Аccess. Maximum numbers of symbols in «Memo» field

a)

65500

b)

65000

c)

65536

d)

650563

52.

Relational database is the database which

a)

has file structure

b)

describes spreadsheets

c)

has Boolean algebra as a base of it

d)

consists of two dimensional table connected with themselves logically

53.

The following operation is performed with records

a)

sort

b)

projecting

c)

forecasting

d)

searching on key

54.

MS Access program is constructed on the base

a)

relational model of database management

b)

MS Excel spreadsheets

c)

HTML

d)

C++

55.

The main object of database is

a)

form

b)

table

c)

macro

d)

template

56.

Creating of database includes

a)

stage of copying slides

b)

stage of database project and input data

c)

stage of output and project data

d)

stage of transmission and deleting of document

57.

The main types of MS Access models

a)

basic

b)

cyclic

c)

standard

d)

relational

58.

MS Аccess. Objects of database

a)

sort, filter

b)

records, fields

c)

book, sheets

d)

queries, tables

59.

MS Аccess. Types of data

a)

text

b)

financial

c)

graphical

d)

fractional

60.

MS Access. Type of query

a)

logic

b)

classic

c)

empty

d)

parameter

61.

MS Access. Methods of creating tables

a)

table wizard

b)

simple table

c)

project table

d)

table design

62.

MS Access. Types of reports

a)

number

b)

project

c)

report design

d)

simple report

63.

MS Access. Possible size of number field

a)

serial

b)

number

c)

integer

d)

financial

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

65.

MS Access. The following operation is performed with queries

a)

filtration

b)

projecting

c)

forecasting

d)

searching on key

66.

!MS Access. Methods of creating forms

a)

form wizard

b)

simple form

c)

project form

d)

classic form

67.

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

68.

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)

Management as a Service

69.

!To create profiles in the cloud use Google Docs

a)

documents

b)

tables

c)

presentations

d)

forms

70.

!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)

open shared access

71.

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)

know the programming language

72.

The place where various information on the user is stored

a)

cloud

b)

browser

c)

account

d)

questionnaire

73.

Defect of a cloud computing is

a)

flexibility

b)

renting

c)

not controllability of data

d)

availability and mobility

74.

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)

cloud technologies

75.

Information and communication technologies are

a)

social science

b)

applied science

c)

medical science

d)

medical science

76.

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

a)

micronuclear architecture of a hypervisor

b)

mobile push-notification messages

c)

online conference 

d)

virtualization 

77.

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

a)

play

b)

disc

c)

email

d)

google

78.

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

a)

email

b)

search

c)

disk

d)

my account

79.

To create questionnaires are used Google documents

a)

tables

b)

forms

c)

documents

d)

presentations

80.

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

a)

lift a limit

b)

open an online chat

c)

open shared access

d)

create "circles friends

81.

Mobile application is:

a)

service

b)

*data storage

c)

software

d)

developing environment

82.

Portable multi-function device of mobile communication

a)

netbook

b)

tablet (pad)

c)

smartphone

d)

monoblock

83.

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

a)

ITU

b)

APPLE

c)

GPS

d)

IES

84.

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

a)

Kcell

b)

Apple

c)

Gmail

d)

Amazon

85.

How many levels of cloud technologies are exist:

a)

2

b)

4

c)

5

d)

3

86.

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

a)

auxiliary level

b)

infrastructure level

c)

intermediate level of a platform

d)

the lowest level of a platform

87.

Global system of coordinates determination

a)

GPS

b)

GSM

c)

Gmail

d)

FTP

88.

The system which allows to make calls and send messages

a)

GPS

b)

Symbian

c)

Tizen

d)

GSM

89.

Google services

a)

ICQ, Internet

b)

Mailing, E-services

c)

Google, My account

d)

Documents

90.

In GOOGLE.com it is possible to create

a)

report, schemes

b)

programs, documents

c)

documents, presentations

d)

catalogs, books

91.

Cybersecurity. Information security from illegal access

a)

installation of the anti-virus program

b)

assignment of responsible persons for information output

c)

each user shall have the computer for operation with system

d)

each user of system shall have the personal password

92.

Cybersecurity. The main types of computer viruses

a)

hardware, file

b)

non-resident, not dangerous

c)

program, load, macro viruses

d)

*file - load, not dangerous, resident

93.

Cybersecurity. Antivirus programs

a)

AidsTest, Kaspersky Kav

b)

MS DOS, DoctorWeb, RAR

c)

Eset, MS Access

d)

MS Word, MS Excel

94.

Cybersecurity. Formats of executed files

a)

doc, .bat

b)

jpg, .txt, .doc

c)

xls, zip, .doc, .bat

d)

exe, .com, .bat

95.

Cybersecurity. Depending on the habitat computer viruses are divided as

a)

resident, non-resident

b)

harmless, dangerous, very dangerous

c)

parasitic, replicators, invisible beings, mutants, trojan

d)

network, file, loading, file and loading

96.

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

a)

harmless, dangerous, very dangerous

b)

detectors, doctors, auditors, filters, vaccines

c)

parasitic, replicators, invisible beings, mutants, trojan

d)

network, file, loading, file and loading

97.

Cybersecurity. MS Windows. File characteristics

a)

changing, moving and deleting the file

b)

date of moving of the file, creation date and time

c)

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

d)

copying, moving, deleting file and attributes

98.

Cybersecurity. Stealth viruses

a)

infect drivers

b)

destroy all information

c)

hide their presence

d)

display the graphic drawing

99.

*!Cybersecurity. The way of virus detection includes

a)

scanning

b)

checking of executing files

c)

record of all files volume

d)

copying files

100.

MS Access. Methods of creating query

a)

classic

b)

simple

c)

query wizard

d)

Share Point lists

Similar Resources on Wayground

javascript

100 questions

javascript

quiz

Worksheet

•

KG - University

QUIZZ AIJ XII - Latihan PTS Semester Ganjil 2020

100 questions

QUIZZ AIJ XII - Latihan PTS Semester Ganjil 2020

quiz

Worksheet

•

KG - Professional Dev...

1er Parcial Comunicación entre computadoras

100 questions

1er Parcial Comunicación entre computadoras

quiz

Worksheet

•

University

computer basics 3

100 questions

computer basics 3

quiz

Worksheet

•

University - Professi...

BTEC IT U2: Exam Prep

99 questions

BTEC IT U2: Exam Prep

quiz

Worksheet

•

11th Grade - University

security system quiz

99 questions

security system quiz

quiz

Worksheet

•

University

QUIZ SEMESTER 1

100 questions

QUIZ SEMESTER 1

quiz

Worksheet

•

University

Statistics and R Basics Questions 1-17

99 questions

Statistics and R Basics Questions 1-17

quiz

Worksheet

•

University