Worksheetsинформатика
Total questions: 51
Worksheet time: 26mins
*!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
provide supporting of created databases
are intended for working with tables
provide creating basic components of database
are intended for organization exchange with external data
*!MS Access. Connected fields have
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
two files but different types 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. 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 «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 «not» is used to select
*coincident files
*coincident values
*coincident queries
*in coincident values
*coincident first symbols
*!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
*!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
*!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
*!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
*!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. A major database object used to display information in an attractive,
easy-to-read screen format
*table
*form
*report
*query
*macros
*!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
*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. 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. 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. Tables of database are intended for
*storing data
*printing data
*deleting of data
*manipulation of data
*output data on the screen
*!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. 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. Logical operator
*dor
*eqv
*null
*true
*not
*!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. 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. Group "Forms" is located on tab
*home
*create
*external data
*datasheet mode
*work with database
*!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. 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. 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. 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
*!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 Аccess. Short keys of "Minimize and maximize the ribbon"
*Shift F6
*Alt Tab
*Ctrl F1
*Shift Tab
*Shift F10
*!МS Access. Group "Fields&Columns" is located on ___ tab
*home
*create
*external data
*datasheet view
*data tools
*!MS Access. To extract necessary data from one or several tables is used
*fields
*forms
*reports
*records
*queries
*!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
*!MS Аccess. Maximum numbers of symbols in «Memo» field
*65 500
*65 000
*65 536
*650 563
*65 0000
*!MS Аccess. Data type
*reporting
*number
*symbol
*cycle
*graphic
*!MS Access. Name of the field with space
*6 signs
*4 signs
*50 signs
*10 signs
*64 signs
*!MS Аccess. Command «Rename the table»
*F6
*F1
*F4
*F5
*F2
*!MS Аccess. The maximum number of text field signs
*225
*155
*355
*455
*255
*!MS Access. The type of a field is set in
*pages
*tables
*reports
*design View
*datasheet View
*!MS Аccess. «Asterisk» symbol means
*new field
*new file
*new number
*new record
*new column
*!Database management system represents the program which is included into
*hardware
*operating system
*system of programming
*unique program software
*application program software
*!MS Аccess. The extension of database
*.txt, .doc
*.exe, .mdb
*.bat, .accdb
*.bmp, .accdb
*.mdb, .ассdb
*!Columns and rows in MS Access are called
*forms, fields
*cells, records
*fields, records
*columns, records
*columns, fields
*!МS Аccess is
*a shell
*system
*teaching tool
*accessory program
*application software
*!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>
*!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
*!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
*!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
*!Database which can be used in several spheres of human activity
*universal
*specialized
*public
*single purpose
*multipurpose
*!М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
