.png)
1. Which data type is suitable to store photographs of students in MS-Access? OLE Object
2. Which data type is used to store date
of birth of an employee in MS-Access? Date/Time
3. Which data type is suitable to store
salary of an employee in MS-Access? Currency
4. Which data type is used to store your
school fee in MS-Access? Currency
5. Which
data type is used to store lengthy text and numbers? Memo (Long Text)
6.
What is the storage size of memo and text data type in MS- Access? Memo – 65535 / 64000 Characters / Text –
255 Characters
7. What is the storage size of Auto
number and currency data type? Auto
number – 4 Bytes / Currency 8 Bytes
8. What is the storage size of Date/Time
and OLE object data type? Date/Time –
8 bytes / OLE Object 1 GB
9. What is the storage size of integer
and long integer number data type? Integer
– 2 Bytes / Long integer –4 Bytes
10. What is the storage size of single and
double number data type? Single – 4 Bytes
/ Double – 8 Bytes
11. What is the storage size of yes/no
field and hyperlink data type? Yes/no
– 1 bit / Hyperlink – 2048 Characters
12. What is the storage size of
attachments data type. 2GB
13. Which data type is the default type in
MS Access? - Text
14. What is the maximum length of field
name in MS-Access? 64 Characters
15. What is the maximum size of caption
field properties in MS-Access? – 2048
Characters
16. What
is the default size of number field in MS-Access? – Long Integer
17. Which
field property gives alternative name for any field? Caption
18. Is
table a database? No, A table is an object inside a database
19. Write any three components of
database? Table, record and field
20. What is a record source for a report in MS Access? Table and Query
21.
How many ways to sort data in MS-Access? Ascending or Descending order according to text or numbers
22. Which
object is used to store the data in database? Table
23. What is the extension of MS-Access
2007? 2003 version - .mdb , 2007
version - .accdb
24.
What
is the primary building block of a database? Table
25.
What
terms are used to refer to a row and a column in a table? Row – Tuple/Record, Column – Attribute/Field
26. Which object of DBMS is used to print
information? Report
27.
Which
object of MS Access is used to provide graphical interface to enter data into a
table? Form
28. Which
data type of MS Access is used for data that can store only one of two possible
values? Yes/No
29. Which
data type displays data from another table? Lookup Wizard
30. Which
data type provides a link “address” to a document? Hyperlink
31. Which object of MS-Access is used to
retrieve data from the table? Query
32.
Which
key sets relationship between tables? Primary
key
33. Which
query is used to view the data stored in database? Select query
34. Which
view is used to modify a table structure in MS-Access? Design view
35. Which
query is used to make changes in data stored in database? Action query
36. Which view is used to modify a record
in MS-Access? Datasheet view
37. Which
data type is also known as logical data type in MS-Access? Yes/No
38.
What
is the purpose of a query in a database? To
ask question to the database.
39. Which data type is used to store alpha
numeric characters or special symbols in MS-Access? Text
40.
Which
field property speeds up searching and sorting of records based on a field? Indexed Field Property
41. Write two examples of primary key
fields. SEE Registration Number,
National Identity Number
42.
What happens while we enter text in number data type? It display error message.
43.
What is relationship? An association
or connection between two tables based on a common field or fields.
44.
Which
field property controls the value of a record and sets in a specific format? Input Mask
45.
Which
field property is used to specify whether a value is required in a field or
not? Required
46. Which field property displays value
automatically for a field when new record is added to a table? Default Value
47.
In
how many ways we can
create a table in Ms Access?
48.
In
how many ways we can
create a form in Ms Access?
49.
In
how many ways we can
create a report in Ms Access?
50.
In
how many ways we can
create a query in Ms Access?
51.
List the types of query.
52.
List the types of action query.
53.
Write any four objects of MS-Access.
54.
Write any four data types used in
MS-Access.
55.
Write any four field properties used in MS-Access.
56.
Write any four examples of database.
57.
Write any four examples of DBMS
58.
Write any four examples of RDBMS.
59.
Define database.
60.
Define DBMS.
