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