問題一覧
1
Which field type will you select if you need to enter long text in that field
memo
2
Which button helps to search quickly for every occurrence of a specific word or phrase
find
3
In MS access,query design view window has two parts . The upper part shows
tables with fields and relationship between tables
4
Look up wizard in MS access is used to
select value from another table
5
Primary key in any table has the properties
both
6
In one to many relationship the table in one side is called_______and on many side is called________
parent, child
7
What is a form that we can create in MS access
is an input screen for viewing and entering data
8
In ms access what is the shortcut key combination to open the lookup wizard for a selected field in design view
ctrl+l
9
Which data types is used to store logical values in MS access
yes/no
10
What cascade delete option is used for
to ensure that all the related record will be deleted automatically when the record from parent table is deleted
11
In MS access,form dialog may be created using ________menu
create> more forms>form wizard
12
Form dialogue box can be created from
create blank form
13
Which field type will you select if you need to enter long text in that field
memo
14
In access ,what does the term 'normalisation' refer to
organise data into tables to reduce redudancy and dependancy
15
Which of the following tabs is not included in the Ribbon of Access 2007?
view
16
Maximum length of a text field can be
255
17
Use of referential integrity in ms access
it does not allow to enter in the foreign key field of a child table if that value exist in a primary key of parent table
18
Which of the following data type in access can store images,videos or other binary digit
OLE object
19
Which is an area reserved for a specific piece of data
field
20
The size of yes/ no filled is always
1 bit
21
What enables the user to automatically insert numbers in a sequential or random number
auto number
22
Which is used to move the active cell towards left in an access table
shift+tab
23
Key stroke is used to move to the active cell to the right, in an access table
tab
24
Expression builder is an access tool that controls an expression ____for entering an expression
box
25
Which program do you use to edit code for data access page
Microsoft script editor
26
The upper part of the query design window in MS access has two parts shows
fields name with relationship
27
Checking operation performed on input data is called the
validation of data
28
To quit ms access
Alt + f4
29
How many types of queries are available in the Query Menu?
5
30
When a New database is created in MS access, what will be the default name of the table
table 1
31
In access to move down one line
down arrow
32
In access, what does the" parameterized query "feature enable you to do
prompt the user to enter criteria when running the query
33
Used in ms access to close the active window
ctrl+w
34
Microsoft access is a
RDBMS
35
_______key to open the help window in MS access 2010 database
f1
36
Shortcut key to switch between the field name and property panel in table design view
f6 key
37
Which is the database management system from Microsoft which is part of the Microsoft office suite
MS access
38
Which combination of key zooms the content of active cell in access table
shift + F2
39
Which view allows to modify table structure in access
design view
40
By which command we can link a table with Excel worksheet?
external data
41
To move down one page
page down
42
The size of yes/no field is always
1 bit
43
In MS access a form with data records one half and entry format at the other half maybe created using which menu
create split form
44
Expression builder is an access tool that controls an expression_________for entering an expression
box
45
Not a valid data type in MS access
picture
46
What enables to view data from a table based on specific citerion
query
47
In how many views, you can create a table in Access?
2
48
What is the default file extension of MS access
.accdb
49
F12 opens a
saveas dialogue box
50
Print the current or selected object
ctrl+p
51
What is the shortcut key combination to delete the current record in data sheet view in MS access
ctrl+del
52
Which field type will you select if you need to enter short text in that field
text
53
Appropriate data type to store time in ms access
date/time
54
To open a new database press
ctrl+N
55
In MS access ,OLE objects data type can Store
all
56
In MS access auto number data type
both
57
Which feature is used to duplicate controls formatting
painter
58
Which field type can store photos
OLE
59
Not a type of ms access data base object
worksheet
60
In a table to insert User’s Voice, data field should be
ole object
61
Which of the following is in the ascending order of data hierarchy
bit,byte, field, record,file, database
62
A _________ enables you to view data from a table based on a specific criterion
query
63
A complete information about an entity in a database is called
record
64
Which key is uniquely identifies each record?
primary key
65
In MS-Access, Hyperlink data type can store
all
66
How many types of relationships are there in MS- Access?
3
67
The context of Microsoft access, which of the following is true
queries can include calculated fields that do not exist in table
68
What does the show checkbox in query design window indicate
indicate whether the field is to be displayed in query result or not
69
A collection of related files is called
database
70
Default data type for a field is
text
71
A subset of characters within a data field is called
data string
72
The Date/Time data type takes ……… bytes to store the date/time values.
8
73
In acess table , coloumn is also known as
field
74
RDBMS Stands for
relational database management system
75
Which tool do you use to create a query object
simple query wizard
76
In access contl + O used to
open an existing database
77
In acess table, row is also known as
record
78
Database access level are specified so ask to define who can access what in a database, it is identified through
user ID
79
To toggle the navigation pane,press
f11