Worksheets1-50 ИКТ (540-сұрақ) сессия
Total questions: 39
Worksheet time: 20mins
Operation with the data which is used to arrangement
sorting of data
transmission of data
organization of data
archiving 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
MS Access. Connected fields have
one file but different type of data
different names and different types of data
different names but the same type of data
the same name but different type of data
MS Access. «Create» tab allows
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
MS Access. A major database object used to display information in an attractive,
easy-to-read screen format
table
form
report
query
MS Access. For copying records it’s necessary to select records and perform
following command
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
sum of form numbers
sum of report numbers
number of form records in consecutive order
auto input of sequential numbers
There are in working area of MS Access:
database window and its objects windows
working area, task pane
status bar, start button
menu bar, toolbar
Commands of "Database tools" tab
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
Lily, Rose, Carnation, Aster
$10, $25, $35, $50
Folder, Directory, Container
MS Access. Logical operator «not» is used to select
coincident first symbols
in coincident values
coincident queries
coincident values
MS Access. Logical operator «not Т» is used for select
words which do not begin from letter «Т»
words which do not contain letter «Т»
words which begin from letter «Т»
words which end with letter «Т»
MS Access. Logical operator «С asterics» is used for select
words which end with letter «С»
words which begin from letter «С»
words which begin from letter «С»
words which do not contain letter «С»
MS Access. Logical operator «[B-C]» is used for select
words which begin from letter «В»
words which don’t contain letter «В»
words which begin from letters «В», «С», «D»
words which end with letters «В», «С», «D»
MS Access. Query is intended for
creating relationships
deleting the document
output data and rename the document
present data in printing view
MS Access. Form is intended for
input data and perform acts defined the entered data
output data and display on the screen
present data in printing view
extract data from tables
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
MS Access. Database field
set of values relating to records
set of values for one element of the object
concept describing one chosen property of an object
set of values which satisfy of a given criteria
MS Access. Tables of database are intended for
storing data
printing data
deleting of data
manipulation of data
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
MS Access. For searching data it’s necessary to perform command
home - data collection - insert
home - find - delete
home - find - find
create - find - find
MS Access. The command of sorting text fields in ascending order
datasheet view – fields and columns – sort on ascending
external data – sort and filter – ascending
datasheet view – font – sort on descending
home – sort and filter – ascending
MS Access. Query is intended for
output data and rename the document
rename the document and input data
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
MS Access. According to formation method queries are grouped
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
others – report design
others – query design
tables – query design
views – query design
MS Access. Logical operator
eqv
null
true
not
Creating of 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
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
forms
reports
records
queries
МS Access. Group "Fields&Columns" is located on ___ tab
*
create
external data
datasheet view
data tools
MS Аccess. Short keys of "Minimize and maximize the ribbon"
Alt^+ Tab
Ctrl^+ F1
Shift Tab
Shift F10
MS Аccess. Short keys of "Minimize and maximize the ribbon"
Alt^+ Tab
Ctrl^+ F1
Shift Tab
Shift F10
МS Аccess. "Open" command of "Оffice" button allows to
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
How to type criteria «<80 or >50» in a query
<80, >50
<80 or >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
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 the criteria
in design view change fields property
in datasheet view change fields property
in datasheet view change format of the field
