wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ИКТ (1-66 MS.ACCESS)

Total questions: 67

Worksheet time: 34mins

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)

Home" commands of МS Аccess

b)

are intended for working with tables

c)

provide supporting of created databases

d)

provide creating basic components of database

e)

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)

able

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 numbe

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)

mport, 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, Ast

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)

coincident first symbols

e)

in coincident values

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

22.

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

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

filter data, perform calculations and summarize the data

e)

delete unnecessary data and display other data on the screen

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)

on a sample, with a parameter, crosstab, simple

e)

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

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)

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.

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

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.

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

fields, records

d)

columns, 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)

reports

d)

design View

e)

datasheet View

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)

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 Аccess. Data type

a)

reporting

b)

number

c)

symbol

d)

cycle

e)

graphic

51.

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

С++

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 Аccess. Objects of database

a)

sort, filter

b)

book, sheets

c)

records, fields

d)

queries, tables

e)

investment, model

59.

*!MS Аccess. 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

Similar Resources on Wayground

APCSP Exam Review

63 questions

APCSP Exam Review

quiz

Worksheet

•

9th Grade - University

H446 Section 1: Components of a computer

71 questions

H446 Section 1: Components of a computer

quiz

Worksheet

•

11th Grade - University

Java

65 questions

Java

quiz

Worksheet

•

University

Network Media

62 questions

Network Media

quiz

Worksheet

•

University

Distributed Review

63 questions

Distributed Review

quiz

Worksheet

•

University

QUIZ FINALS 101TEN

70 questions

QUIZ FINALS 101TEN

quiz

Worksheet

•

University

Cambridge - IGCSE - Computer Science - Input Devices

66 questions

Cambridge - IGCSE - Computer Science - Input Devices

quiz

Worksheet

•

11th Grade - Professi...

GUESS THE EMOJI

64 questions

GUESS THE EMOJI

quiz

Worksheet

•

12th Grade - University