Font size
WorksheetsИКТ сессия 1-135
Total questions: 135
Worksheet time: 1hrs 8mins
Operation with the data which is used to arrangement
sorting of data
archiving of data
organization of data
transmission of data
formalization of data
MS Access. Functions of commands in “Datasheet” tab
"Home" commands of МS Аccess
are intended for working with tables
provide supporting of created databases
provide creating basic components of database
are intended for organization exchange with external data
MS Access. Connected fields have
two files but different types of data
one file but different type of data
different names and different types of data
the same name but different type of data
different names but the same type of data
MS Access. «Create» tab allows
split the table, query and report
perform auto format of the table
create new table, form, report, query, macro and module
create the page, form, template, report, query, slide and database
create new table, template, resume, query, slide and new database
MS Access. Change the table structure
table wizard
design view
datasheet view
create new table
open the table and rename fields
MS Access. A major database object used to display information in an attractive, easy-to-read screen format
table
form
report
query
macros
MS Access. For copying records it’s necessary to select records and perform following command
home - font - copy
create - reports - copy
home - data collection - insert
home - clipboard - copy
external data - clipboard - cut
MS Access. The function of «AutoNumber» in «ID» field of database
number the table
sum of form numbers
sum of report numbers
auto input of sequential numbers
number of form records in consecutive order
There are in working area of MS Access:
desktop, task area
working area, task pane
status bar, start button
menu bar, toolbar
database window and its objects windows
Commands of "Database tools" tab
forms, reports, analyze and others
Import, export, collect data, analyze
macro, show/hide, analyze, move data
rich text, clipboard, records, sort and filter, find
tables, clipboard, font, show and hide, find, representation
MS Access. Records are sorted in increasing order
12, 144, 245, 53, 94
$10, $25, $35, $50
Lily, Rose, Carnation, Aster
Folder, Directory, Container
10/12/96, 02/12/98, 02/11/97, 14/10/99
!MS Access. Logical operator «not» is used to select
coincident files
coincident values
coincident queries
in coincident values
coincident first symbols
MS Access. Logical operator «not Т» is used for select
words which contain letter «Т»
words which end with letter «Т»
words which begin from letter «Т»
words which do not contain letter «Т»
words which do not begin from letter «Т»
MS Access. Logical operator «С asterics» is used for select
words which contain letter «С»
words which end with letter «С»
words which begin from letter «С»
words which do not contain letter «С»
words which do not begin from letter «С»
MS Access. Logical operator «[B-C]» is used for select
words which contain letter «D»
words which begin from letter «В»
words which don’t contain letter «В»
words which end with letters «В», «С», «D»
words which begin from letters «В», «С», «D»
MS Access. Query is intended for
storing the database
creating relationships
deleting the document
present data in printing view
output data and rename the document
MS Access. Form is intended for
printing the document
extract data from tables
present data in printing view
output data and display on the screen
input data and perform acts defined the entered data
MS Access. The command of sorting text fields in descending order
home – sort and filter – descending
home – sort and filter – ascending
datasheet view – font – sort on descending
external data – sort and filter – ascending
datasheet view – fields and columns – sort on ascending
MS Access. Database field
some area of database
set of values relating to records
set of values for one element of the object
set of values which satisfy of a given criteria
concept describing one chosen property of an object
MS Access. Tables of database are intended for
storing data
printing data
deleting of data
manipulation of data
output data on the screen
MS Access. For deleting records it’s necessary to select records and perform
create - font - delete
home - records - delete
home - collect data - insert
home - clipboard - delete
external data - records - delete
MS Access. For searching data it’s necessary to perform command
home - find - find
create - find - find
home - find - delete
home - data collection - insert
external data - records - find
MS Access. The command of sorting text fields in ascending order
home – sort and filter – descending
home – sort and filter – ascending
datasheet view – font – sort on descending
external data – sort and filter – ascending
datasheet view – fields and columns – sort on ascending
MS Access. Query is intended for
input data and delete the document
rename the document and input data
output data and rename the document
filter data, perform calculations and summarize the data
delete unnecessary data and display other data on the screen
MS Access. Group "Forms" is located on tab
home
create
external data
datasheet mode
work with database
MS Access. According to formation method queries are grouped
currency, simple, linear
text, with a parameter, an auto query, numeric
linear, auto reports, auto forms, simple, dependent
on a sample, with a parameter, crosstab, simple
circle, the linear, numeric, an auto request, monetary, the report
MS Access. The sequence of commands for formation of queries of the Create tab
list – datasheet
others – report design
others – query design
tables – query design
views – query design
MS Access. Logical operator
dor
eqv
null
true
not
Creating of database
toolbar – create the database
file – create – open the database
edit – create – open the database
"Office" button- create – new database
create – "Office" button – create the database
Database management systems
Ms Excel, Supercalc, Turbopascal, Ms Access
Clipper, Paradox, Foxpro, Foxbase, Ms Access
Inereader, Prompt98, Qtrans, Foxbase, Excel, Paradox
Ms Word, Wordperfect, Total Commander, Ms Access
Ms Powerpoint, Ms Access, Outlook Express, Total Commander
MS Access. To extract necessary data from one or several tables is used
fields
forms
reports
records
queries
МS Access. Group "Fields&Columns" is located on ___ tab
home
create
external data
datasheet view
data tools
MS Аccess. Short keys of "Minimize and maximize the ribbon"
Shift + F6
Alt + Tab
Ctrl + F1
Shift + Tab
Shift + F10
MS Access. Set of tools which is displayed when choosing «Home» tab
clipboard, paragraph, text, views, font
create, records, sort and filter, alignment, find, styles
clipboard, tables, views, text, find, pages, editing
views, clipboard, font, text, records, sort and filter, find
font, pages, views, clipboard, styles, alignment, find, text
МS Аccess. "Open" command of "Оffice" button allows to
save data in a table
look at data in a table
open the created table
open the «editing» window
open the created database
Database which can be used in several spheres of human activity
universal
specialized
public
single purpose
multipurpose
How to type criteria «<80 or >50» in a query?
<80, >50
<80 or >50
<80=>50
less than 80 and greater than 50
less than 80 or greater than 50
Query design window has two parts. The upper part shows
criteria
sorting check boxes
name of fields, field type and size
properties and format of the field
tables with fields and relationships between tables
To change the size of text field from 255 to 50 symbols in MS Access table it’s necessary:
in design view change fields type
in design view change the criteria
in design view change fields property
in datasheet view change fields property
in datasheet view change format of the field
to create parameter query which displays name of the doctor, it’s necessary to write:
[Enter doctor’s name]
(Enter doctor’s name)
{Enter doctor’s name}
/Enter doctor’s name/
<Enter doctor's name>
МS Аccess is
a shell
system
teaching tool
accessory program
application software
Columns and rows in MS Access are called
forms, fields
cells, records
fields, records
columns, records
columns, fields
MS Аccess. The extension of database
.txt, .doc
.exe, .mdb
.bat, .accdb
.bmp, .accdb
.mdb, .ассdb
Database management system represents the program which is included into
hardware
operating system
system of programming
unique program software
application program software
MS Аccess. «Asterisk» symbol means
new field
new file
new number
new record
new column
MS Access. The type of a field is set in
pages
tables
reports
design View
datasheet View
MS Аccess. The maximum number of text field signs
225
155
355
455
255
MS Аccess. Command «Rename the table»
F6
F1
F4
F5
F2
MS Access. Name of the field with space
6 signs
4 signs
50 signs
10 signs
64 signs
MS Аccess. Data type
reporting
number
symbol
cycle
graphic
MS Аccess. Maximum numbers of symbols in «Memo» field
65 500
65 000
65 536
650 563
65 0000
Relational database is the database which
has file structure has file structure
describes spreadsheets
has Boolean algebra as a base of it
connects data by means of physical indicators
consists of two dimensional table connected with themselves logically
The following operation is performed with records
sort
projecting
forecasting
exploitation
searching on key
MS Access program is constructed on the base
С ++
Lisp
Html
MS Excel spreadsheets
relational model of database management
The main object of database is
form
table
macro
module
template
Creating of database includes
stage of copying slides
stage of output and project data
stage of database project and input data
stage of defining and deleting information
stage of transmission and deleting of document
!The main types of MS Access models
basic
cyclic
standard
application
relational
MS Аccess. Objects of database
sort, filter
book, sheets
records, fields
queries, tables
investment, model
MS Аccess. Types of data
text
financial
graphical
fractional
percentage
MS Access. Type of query
logic
classic
empty
separate
parameter
MS Access. Methods of creating tables
table wizard
simple table
project table
classic table
table design
MS Access. Types of reports
number
project
simple report
classic
report design
MS Access. Possible size of number field
serial
number
integer
financial
percentage
MS Access. To start program it’s necessary
Start – Accessories – MS Office – MS Office Access
Start – All programs – MS Office – MS Office Access
Start – All programs – Accessories – MS Office Access
Context menu – Create – MS Office Access 2007 Database
Start – Accessories – Application programs – MS Office Access
MS Access. The following operation is performed with queries
filtration
projecting
forecasting
exploitation
searching on key
MS Access. Methods of creating query
classic
simple
project
query wizard
Share Point lists
MS Access. Methods of creating forms
form wizard
simple form
project form
logic form
classic form
Technology which distributes information from the server to the client, used on mobile devices
virtualization
online conference
computing clouds
mobile push-notification messages
micronuclear architecture of a hypervisor
A model of providing cloud computing for access to use of operating systems and database management system
Software as a Service
Infrastructure as a Service
Platform as a Service
Storage as a Service
Management as a Service
To create profiles in the cloud use Google Docs
documents
tables
presentations
forms
my cards
To work with one Google Document in online mode it is necessary for group of users
remove the restriction
create a conference
open online chat
create "circles friends"
open shared access
To create Google Presentation in the cloud it is necessary
create mail.ru
have a Google account
be a Google Hangout User
have access to social networks
know the programming language
The place where various information on the user is stored
cloud
browser
account
mailservice
questionnair
Defect of a cloud computing is
flexibility
renting
economyy
availability and mobility
not controllability of data
The convenient environment for processing and storage of various formats information with user support of the Internet
social networks
development environment
mobile services
operating system
cloud technologies
Information and communication technologies are
social science
applied science
medical science
humanity
fundamental science
Technology which distributes information from the server to the client, used on mobile devices
virtualization
online conference
computing clouds
mobile push-notification messages
micronuclear architecture of a hypervisor
It is possible to change a profile photo, entering in service
play
disc
translator
!To work with the documents of GOOGLE you need to enter in service
search
disk
calendar
my account
To create questionnaires are used Google documents
forms
tables
my cards
documents
presentations
To work with one Google document in online mode group of users has to:
lift a limit
open an online chat
create a conference
open shared access
create "circles friends"
Mobile application is:
service
software
data storage
cloud calculation
developing environment
Portable multi-function device of mobile communication
netbook
tablet (pad)
bluetooth
monoblock
smartphone
The international organization defining recommendations in the field of telecommunications and radio
ITU
LTE
APPLE
GPS
IES
The largest software developer, the creator a web - service Elastic Computer Cloud (EC2):
Kcell
Apple
Gmail
Amazon
EPAM Systems
How many levels of cloud technologies are exist:
2
4
5
3
6
Level of cloud technologies. Platform as a Service - PaaS)
auxiliary level
infrastructure level
top level of appendices
the lowest level of a platform
intermediate level of a platform
Global system of coordinates determination
GPS
GSM
LTE
Gmail
FTP
The system which allows to make calls and send messages
GPS
GSM
Symbian
Tizen
iOS
Google services
ICQ, Internet
Cloud
Mailing, E-services
Google, My account
Documents
In GOOGLE.com it is possible to create
report, schemes
queries, reports
catalogs, books
programs, documents
documents, presentations
Cybersecurity. Information security from illegal access
installation of the anti-virus program
each user of system shall have the personal password
assignment of responsible persons for information output
to define an information access only for a manual of MPI
each user shall have the computer for operation with system
Cybersecurity. The main types of computer viruses
hardware, file
load, resident
non-resident, not dangerous
program, load, macro viruses
file - load, not dangerous, resident
Cybersecurity. Antivirus programs
Eset, MS Access
MS Word, MS Excel
ZIP, MS Power Point
AidsTest, Kaspersky Kav
MS DOS, DoctorWeb, RAR
Cybersecurity. Formats of executed files
.doc, .bat
.jpg, .txt, .doc
.bmp, rar, html
.exe, .com, .bat
xls, zip, .doc, .bat
!Cybersecurity. Depending on the habitat computer viruses are divided as
resident, non-resident
harmless, dangerous, very dangerous
network, file, loading, file and loading
detectors, doctors, auditors, filters, vaccines
parasitic, replicators, invisible beings, mutants, trojan
Cybersecurity. Stealth viruses
infect drivers
infect boot sectors
hide their presence
destroy all information
display the graphic drawing
Cybersecurity. MS Windows. File characteristics
changing, moving and deleting the file
copying, moving, deleting file and attributes
date of moving of the file, creation date and time
renaming, moving, deleting file and time of creation
file name, creation date and time, file size and attributes
Cybersecurity. On a way of infection computer viruses are divided as
resident, non-resident
harmless, dangerous, very dangerous
network, file, loading, file and loading
detectors, doctors, auditors, filters, vaccines
parasitic, replicators, invisible beings, mutants, trojan
Cybersecurity. The way of virus detection includes
scanning
copying files
heuristic analysis
record of all files volume
checking of executing files
Cybersecurity. Computer can be infected with the virus
on incorrect loading
when loading drivers
when text program is working
when executing the infected program
when inserting a floopy disk into the disk drive
Cybersecurity. Detector programs
modify programs
find the infected files
find changes and treat
treat the infected files
only find changes in files
Cybersecurity. Doctor programs
modify programs
find the infected files
find changes and treat
treat the infected files
only find changes in files
Cybersecurity. The computer virus is
the program providing compression of files
the program intended for creation of the presentation
the program used for increase in speed of operation of a disc
the program for coercion of the archived file to an initial look
specially written program of small volume which spoils them
Cybersecurity. The main two groups of viruses
network, file
macro, micro
loading, dangerous
resident, non-resident
dangerous, not dangerous
Cybersecurity. The viruses using errors and inaccuracies in a complex of software
worms
trojan horses
propagandists
logical bombs
viruses interceptors
Cybersecurity. Anti-virus programs
MS DOS, NC
ARJ, RAR, ZIP
AutoCAD, CorelDraw
MS Word, MS Excel, MS Access
AidsTest, Doctor Web, Kaspersky KAV
Cybersecurity. In what case the computer can be infected with virus
when formatting a disk
when testing the computer
when loading of the computer
at start of the DoctorWeb program
during the work with the infected program
Cybersecurity. Doctor Program
Finds suspicious actions
Prevents infection of files
Finds the infected files and treats them
Looks for viruses with the known signature
Compares an initial condition of the file to current
Cybersecurity. Infection with loading viruses occurs at
Closing of the file
Opening of the file
Data recording in the file
Reading of information from the file
Turning on the computer with busy floppy
Cybersecurity. Loading viruses can infect
еxe-files
OBJ-files
batch-files
COM-files
Boot-Strap program
Cybersecurity. Replicators
Find a virus
Delete a virus
Transfer a virus
Destroy a virus program
Warning infection with a virus
Cybersecurity. Auditor programs
Treat a disk
Use vaccines
Treat all computer
Delete only the infected files of Windows
Remember data on a condition of programs
Cybersecurity. Macro viruses are
Network files
Package files
Dialogue files
Loading files
Macros
Cybersecurity. AVP is
graphics editor
anti-virus program
the program spreading virus
program of defragmentation
the program, the pressing the file for saving of the place on a disk
Cybersecurity. The computer virus is
text editor
graphic editor
programming language
the program damaging computer programs and data
the program which is carrying out start of the computer
Cybersecurity. Distinctive features of a computer virus are
ease of recognition
considerable volume of a program code
need of start of the program from the user
ability to increase in a noise stability of an operating system
small volume ability to independent start and repeated copying of a code, to creation of noise to correct operation of the computer
How the computer can be infected a virus
when loading drivers
when opening the internet
in case of the wrong loading
in case of execution of the infected program
when inserting the disc with the infected program
The computer virus is
the hidden programs which erase, but they aren't removed
the program which protects the computer from harmful files
not readable data which are kept on rigid or on a floppy disk
programs which don't give the chance to open data with the password
the program which breeds itself and does harm to the computer of the user and other objects located in network
The text "SYRYECUMT SSTEI" deciphered by method of simple swap will look as follows
«SEQURITY RISK»
«STORAGE DEVICE»
«SECURITY SYSTEM»
«INFORMATION SYSTEM»
«SECONDARY STORAGE »
The text ciphered by method of simple swap "INTEGRITY INFORMATION SYSTEMS" will look as follows
"RIGENTY SSYETSMFORMIONN"
"IRIGENTY SSYETSO MFORMIONN"
"SYETSMS NUITANIONF IYRIGETNI"
"SMETSYS NOITAMRONF YTIRGETNI"
"YTIRGETNI NOITAMROFNI YTIRGETNI"
Main stages of e-government in the Republic of Kazakhstan
Information, interactive, transactional
Democratic society, the information society
Bridging Digital Divide, information society
E-government portal, a single transport medium
Payment gateway, a national identification system
Program of forming «E-government» in Republic of Kazakhstan on 2005-2007
25.10.2005, №991
13.10. 2006, №995
11.10. 2004, №1459
18.08. 2003, №1166
10.11.2004, №1471
The number of information services on web-portal of «E-government»
999
900
145
300
933
Citizens, government agencies, organizations and other economic entities utilizing the services of e-government
E- service
E-banking
E-government
E-service providers
Consumers of e-services
State bodies, organizations and other economic entities providing services ict tools
E-service
E-banking
E-government
E-service providers
Consumers e-services
The law "About the Electronic Document and the Digital Signature" was adopted
10th January 2005, № 37
1 st January 2007, № 370
7th January 2002, № 37-2
7th January 2000, № 70-2
7th January 2003, № 370-2
The abbreviation designating interaction of government with citizens
consumer-to-consumer
government -to-business
consumer-to- government
government-to-consumer
government-to- government
The abbreviation designating interaction of the state with government
business-to-consumer
consumer-to-consumer
government -to-business
consumer-to- government
government-to- government
The abbreviation designating interaction of the state with private sectors
consumer-to-consumer
business-to-government
government -to-business
consumer-to- government
government-to- government
The abbreviation designating interaction of business with the state
business-to- business
consumer-to-business
business-to-consumer
government -to-business
business-to-government
The abbreviation designating interaction of citizens with the state
consumer-to-business
business-to-consumer
consumer-to-consumer
consumer-to- government
government-to- government
Method how to obtain digital signature:
to register on Population service center website
to register on the website www.egov.kz
to enter a private office through e-mail
to set JavaScript and to get permission for registration
it is necessary to submit the application for obtaining the electronic digital signature (EDS) on www.egov.kz
For authorization on the Web portal of "Electronic government" the following data are necessary:
marriage certficate
e-mail address (e-mail)
number of the identity card
e-mail address (e-mail) and password of the user
personal identification number and password of the user
E-mail address of the electronic government web portal of Kazakhstan:
www.e.gov.kz
www.e.kz
www.aic.gov.kz
www.aic.kz
www.aik.gov.kz
