Practice MS Access
[DBMS]
255 Questions Collections
1. 40 Theory
Questions.
2. 75 Multiple Choice Questions
4. 80 True and False
5. 40 Fill in the Blanks
6. 20 Match the following
40 Theory Questions
1.
What
is database? Give four examples of database.
2.
State
the advantages of managing database information in access.
3.
Differentiate
between database and database management system.
4.
Differentiate
between computerized and non-computerized database.
5.
What
is data? Write with examples.
6.
Differentiate
between data and information.
7.
What
is MS-Access?
8.
Define
DBMS with example.
9.
Define
RDBMS with example.
10.
List
any four features of DBMS.
11.
List any four features of MS-Access?
12.
What
are the different objects of MS-Access?
13.
What
is data type? Write any four data types of MS-Access.
14.
List
any four types of field properties used by MS-Access.
15.
What
is validation rule? Define validation text.
16.
Differentiate
between text and memo.
17.
What
is referential integrity?
18.
Define
field.
19.
Differentiate
between field and record.
20.
While
designing table structure which data types are suitable to store information
about teacher’s name, address, salary and date of birth.
21.
What
happens when we enter text in a numeric field?
22.
What
is Primary key? Why is it needed?
23.
Write
any two uses of Primary key?
24.
Define
sorting and filtering in MS-Access.
25.
How
is sorting different from filtering?
26.
How
can data redundancy be controlled in MS-Access?
27.
Define
table. Write different ways to create a table.
28.
What
is form? Mention the methods to create a form.
29.
Define
query. Mention different types of query.
30.
What
are the advantages of query?
31.
What
are the purposes of query in MS-Access?
32.
What is select query? For what it can be used?
33.
What
is update query?
34.
Write
the append query?
35.
Differentiate
between select query and action query.
36.
What
is report? List any two methods to create report.
37.
What
is the importance of report?
38.
Differentiate
between form and report.
39.
Differentiate
between Form and Query.
40.
Who
is DBA? Write his/her responsibilities.
1)
What
is database? Give two examples.
Ans:
Database is a collection of related and organized information that can be used for
different purpose.
Two examples of database are:
i) Dictionary
ii) Telephone Directory
2)
Differentiate
between data and table.
Ans:
|
Data
|
Table
|
|
i) Data can
be numbers, letters or symbols representing facts and figures which may or
may not give any sense.
|
i) Table is
an object of database that stores large volume of data in the form of rows
and columns.
|
3)
State
the advantages of managing database information in access.
Ans:The advantages of managing database information in access are:
i) It controls data redundancy which means duplication of data.
ii) It allows sharing the existing data by different programs.
iii) Large volume of data can be stored and updated easily.
iv) It provides high security of data as well as maintains accurate database.
4)
Differentiate
between database and database management system
Ans:
|
Database
|
Database
Management System
|
|
i) Database
is a collection of related and organized information that can be used for
different purposes
|
i) DBMS is software which is used to manage
data in an organized way.
|
|
ii) E.g.:
Telephone directory, Dictionary, etc.
|
iii) E.g.:
MS-Access, Oracle
|
5)
Differentiate
between computerized and non-computerized database.
Ans:
|
Computerized
|
Non-Computerized
|
|
i) It can
store large volume of data.
|
i) It is limited by physical storage available.
|
|
ii) It is
very fast to find a specific record.
|
ii) It can take a while to manually
search through all of the records.
|
|
iii) Data can be sorted into ascending
or descending order on multiple criteria.
|
iii) Difficult to sort data on more than
one criteria
|
|
iv) The database can be kept secure by
use of passwords.
|
iv) The only security would be locking
up the records.
|
6)
What
is data? Write with examples.
Ans:Data can be numbers, letters or symbols representing facts and figures
which may or may not give any sense.
E.g.: Ram, student, 20, etc.
7)
What
is information?
Ans: Information is
an organized collection of related data, which gives a complete sense. For
example: “He is a boy.” , etc.
8)
Differentiate
between data and information.
Ans:
|
Data
|
Information
|
|
i) Data can be numbers, letters or
symbols representing facts and figures which may or may not give any sense.
|
i) Information is an organized
collection of related data which gives a complete sense.
|
|
ii) E.g.: Ram, student, 20, etc.
|
ii) E.g.: Ram is a student. He is 20
years old., etc.
|
9)
Differentiate
between record and table.
Ans:
|
Record
|
Table
|
|
i) Record is a collection of multiple
related fields in a row which gives complete information about a person or
thing.
|
i) Table is an object of database that
stores large volume of data in the form of rows and columns.
|
10) What is MS-Access?
Ans:MS-Access is a relational database management system developed by Microsoft
Corporation which is used to store and manipulates large volume of data in the
form of table.
11) Define DBMS with example.
Ans:DBMS is a software which is used to manage data in an organized way.
E.g.: MS-Access, Oracle, etc.
12) 11. Define RDBMS with example.
Ans: It is a database management system that is based on the relation model in
which data is stored in the form of tables and the relationship among the data
is also stored in the form of tables.
E.g.: SQL, MS-Access, Oracle, etc.
13) List any four featured of DBMS.
Ans: The four features of DBMS are:
i) It controls data redundancy which means duplication of data.
ii) It allows sharing the existing database by different programs.
iii) Large volume of data can be stored and updated easily.
iv) It provides high security of data as well as maintains accurate database.
14) List any four features of MS-Access?
Ans: The four features of MS-Access are:
i) It provides the flexible ways to add, edit, delete and display the related
data.
ii) Queries help to view, change and analyse the data indifferent ways.
iii) Forms are used for viewing and editing the information.
iv) Reports are used for summarizing and printing the data.
15) Define the term of input mask and
relationship.
Ans:
Input mask: It is a field property that controls the value of a record and sets
in a specific format.
Relationship: It is an association among several entities (table).
16) What is caption?
Ans: Caption is a field property which displays an alternate name for the field
to make the field name more explanatory. It can contain up to 2048 characters.
17) What are the different objects of
MS-Access?
Ans: The different objects of MS-Access are:
i)Table
ii)Form
iii)Query
iv)Report
18) What is data type?
Ans: It is an attribute for a field that determines what type of data it can
contain.
19) Write any four data types of
MS-Access.
Ans: Any four data types of MS-Access are:
i)Text
ii)Number
iii)Memo
iv)Currency
20) List any four types of field
properties used by MS-Access.
Ans: The four types of field properties of MS-Access are:
i)Caption
ii)Format
iii)Validation rule
iv)Input mask
21) What is validation rule? Define
validation text.
Ans:
Validation rule: A field property which enables to limit values that can be
accepted into a field is known as validation rule.
Validation text: A field property which allows type text to be displayed if the
user input value is prohibited by the validation rule is known as validation
text.
22) Differentiate between text and
memo.
Ans:
|
Text
|
Memo
|
|
i) It is used for storing text or combination
of text and numbers.
|
i) It is used for storing lengthy text
and numbers.
|
|
ii) It can store up to 2055 characters.
|
ii) It can store up to 65,535
characters.
|
23) What is field size? What is the
use of ‘Format’ field property?
Ans: Field size is a field property that specifies the maximum number of
characters allowed in the field.
The use of ‘Format’ field property is to display data in a different format.
24) Write down the use of Lookup
Wizard and Hyperlink data types.
Ans: The use of Lookup Wizard is that it creates a field that allows choosing a
value from another table or from a list of values by using a list box or combo
box.
The use of Hyperlink is that it stores hyper like addresses like email
addresses, websites, database objects or other field.
25) Define indexing. Mention its
types.
Ans: Indexing is one of the important properties of database that speed up
searching and storing of records using on the field.
Its types are:
·
Primary
indexing
·
Secondary
indexing
·
Clustering
indexing
26) What is referential integrity?
Ans: Referential integrity is a set of rules used by RDBMS to make sure that
the relationships between tables are valid and that the related data is not
accidentally changed or deleted.
27) Define field.
Ans: A column in a table is called field, and it contains a specific piece of
information within a record.
28) Differentiate between field and
record.
Ans:
|
Field
|
Record
|
|
i) A column in a table is called field,
and it contains a specific piece of information within a record.
|
i) Record is a collection of multiple
related fields in a row which gives complete information about a person or
thing.
|
|
ii) E.g.: Name, Address, Telephone
|
ii)E.g.: Ram Chabahil 4468790
|
29) While designing table structure
which data types are suitable to store information about teacher’s name,
address, salary and date of birth.
Ans:
Teacher’s name - Text
Address – Text
Salary – Currency
Date of birth – Date/Time
30) What happens when we enter text
in a numeric field?
Ans: If we enter text in a numeric field then it displays the errors.
31) What is Primary key? Why is it
needed?
Ans: Primary key is a field that uniquely identifies the record. It is needed
because it neither accepts duplicate values now null values.
32) Write any two uses of Primary
key?
Ans: The uses of Primary key are:
i) To reduce and control duplication of record in a table.
ii) To set the relationship between tables.
33) What is composite and foreign
key?
Ans: The group of primary key that consists of two or more attributes is called
composite key.
Foreign key is a unique field or combination of fields in linked table whose
value matches with a primary key in another table.
34) Define sorting and filtering in
MS-Access
Ans: Sorting means grouping all the records in a table either in ascending or
descending order based on a key field of the record
Filtering is an option that selects the required records and displays the
result.
35) How is sorting different from
filtering?
Ans: Sorting arranges the record either in ascending or descending order
whereas filtering selects the required records and displays the result.
36) What are the advantages of
sorting?
Ans: The advantages of sorting are:
i) It helps to find specific information quickly.
ii) It helps to arrange data in alphabetical order.
37) What are the advantages of form
over table?
Ans: The advantages of form over a table are:
i) It allows to design the layout of field on screen in any arrangement.
ii) It shows only the information we want to see.
iii) It can display one complete record at a time.
38) How can data redundancy be
controlled in MS-Access?
Ans: Data redundancy can be controlled in MS-Access by the use of “Primary
Key”.
39) Define table. Write different
ways to create a table.
Ans: Table is an object of database that stores large volume of data in the
form of rows and columns.
The different ways to create table are:
i) Using design view
ii) Using wizard
40) Write down the importance of
table.
Ans: The importance
of table are:
·
Different
properties of a field can be set in a table.
·
It
provides options for primary key which helps to make data consistent.
41) What is form? Mention the methods
to create a form
Ans: Form is an object of database which provides graphical interface to enter
data into the tables or multiple linked tables.
Methods to create a form are:
i) By using auto forms features.
ii) By using the form wizard features.
iii) By using your own in design view.
42) Write down the importance of
form.
Ans: The importances
of form are:
·
It
provides an interactive platform for input of data into the database.
·
It
helps to display data in more presentable form than a datasheet.
43) Define query. Mention different
types of query.
Ans: Query is an object of a database which extracts and arranges information
from a table.
The different types of query are:
i) Select query
ii) Action query
In action query, we have update query, append query, delete query and
make-table query.
44) What are the advantages of query?
Ans: The advantages of query are:
i) We can filer, perform calculations and summarize data.
ii) Large volume of records can be updated or deleted at a same time.
iii) It retrieves and display records including some fields or all the fields
of a table or multiple linked tables.
45) What are the purposes of query in
MS-Access?
Ans: The purpose of query in MS-Access are:
i) To view records including some fields or all the fields of a table or
multiple linked tables.
ii) To perform mathematical calculation of a data.
iii) To sort the records on the basis of one or more key fields.
iv) To perform mass update, delete or append new records to a table.
46) What is select query? For what it can be used?
Ans: A select query is the most common categories and is used for extracting
specific information from one or more tables in a database.
We use select query to group records and calculate sums, counts and average,
minimum and maximum.
47) What is update query?
Ans: Update query is a type of action query which make global changes in data
of a table or more linked tables.
48) Write the append query?
Ans: The use of append query is to add a group of records from one or more
tables to the end of one or more tables.
49) Write down the importance of
query?
Ans: The importances
of query are:
·
It
allows user to make calculations and change data in automated fashion.
·
It
provides option to delete all the unwanted data matching certain criteria.
50) Differentiate between select
query and action query.
Ans:
|
Select
query
|
Action
query
|
|
i) It is a query which extracts specific
information from one or more tables.
|
i) It is a query which makes changes to
many records in just one operation.
|
|
ii) It cannot make changes in tales.
|
ii) It can do changes in tables by
update, append.
|
51) What is report? List any two
methods to create report.
Ans: Report is an object of database which displays the output in an effective
way to present the data in a printed format.
The methods are:
i) Using design view
ii) Using report wizard
52) What is the importance of report?
Ans: The importance of report are:
i) It displays the information the way we want to view it.
ii) It presents the information retrieved through queries or tables.
iii) It presents the information in designed layouts by adding necessary
titles, setting font colour or font size, etc.
53) Why is report created?
Ans: Report is created to print documents according to users specifications of
the summarized information through query or table.
54) What is the data source for
report?
Ans: The data sources for report are table and query.
55) Differentiate between form and
report.
Ans:
|
Forms
|
Report
|
|
i) Forms are used to enter, view, and
edit information.
|
i) Reports are used only to view
information.
|
|
ii) Forms are usually displayed on the
screen.
|
ii) Reports can be previewed on the
screen, but they are usually printed.
|
|
iii) Forms generally provide a detailed
took at records and usually for the people who actually work with the
database.
|
iii) Reports are often used to group and
summarize data, and are often for the people who don’t work with the database
but who use its information for other business task.
|
1.
What is extension of access
database? (MS-Access 2003 version)
DBF MDB MBD DBM
2.
_____ is the table design creating
option to create custom table design.
Datasheet Design view Wizard Link Table
3.
A field name can be up to _____
characters long.
40 46 64 2048
4.
_____ is a data type used for
lengthy text and numbers
Text Long Text OLE Object Memo
5.
Data type that requires 8 bytes of
storage.
Yes/No Currency Long Integer All of them
6.
The name of caption can be declared
up to _____ characters.
1024 2024 2048 2005
7.
Memory space used by a auto number
data type is _____
1
Byte 2 Bytes 4 Bytes 8 Bytes
8.
The primary key contains _____
value.
Null No Null Number Auto
number
9.
Which specifies the expression that
checks the invalid data.
Validation
Rule Validation Text Input Mask Required
10.
_____ is not a field property of
MS-Access.
Caption Index Color Format
11.
Format symbol that converts all
characters to uppercase.
@ & < >
12. What kind of data is kept in memo
field?
(i) Hyperlink (ii) Software (iii) Data (iv)
Pictures
13. What is the default size of
Access?
(i) 10 (ii) 20 (iii) 30 (iv) 50
14.
Which
is not the database?
i.
Phone diary ii. Mark
ledger iii. Attendance Register iv. Report Card
15.
MS-Access
is a software.
i.
Utility ii. Application iii. System iv. None of the above.
16.
Which
is DBMS?
i.
Database ii. Metabase iii. dBase iv. MS-Excel.
17.
The
object of MS-Access that stores data is known as________
i.
Query ii. Table iii. Form iv. Report
18.
Which
of the following is not the data type used in MS-Access?
i.
Date/Time ii.
Counter iii. Hyperlink iv. Caption
19.
The
object of MS-Access that is used to prepare read-to-print document is_________
i.
Query ii. Table iii. Form iv. Report
20.
A
field property that limits the data to be entered in a field is___________
i.
Validation Rule ii. Format iii. Input Mask iv. Indexed
21.
Which
is the subtype of number data type?
i.
Integer ii. Byte iii. Single iv. All of the above.
22.
__________allows
MS-Access to query and sort record faster.
i.
Sorting ii. Editing iii. Filtering iv.
Indexing
23.
The
maximum number of characters that can be stored in a field is determined by_
i.
Field Type ii. Field
Size iii. Field Length iv. Field width
24.
The
logical field data type of MS-Access is______________
i.
Yes/No ii. True/False iii. On/Off iv. All of the above.
25.
The
field size of logical field data type is __________ in MS-Access.
i. 1 bit ii. 1 byte iii. 2 bytes iv.
2 bits
26. A (n) ____________________ is an organized collection of the
related information.
Object database Property document
27. Field size, format, input mask, caption and default values are:
Key elements field
properties Navigating modes data types
28. The _________________ key uniquely identifies each record
Primary database Object premier
29. ___________________ is a set of rules used by Access to ensure
that the relationships between tables are valid and that the related data is
not accidentally changed or deleted.
Relationship Referential
integrity Query Forms
30.
A
Database Management System can be used to .
i. retrieve information ii. search information iii. sort information iv. all of the above
31.
The
storage size of date and time is .
i.4 bytes ii.6 bytes iii.8 bytes iv.12 bytes
32.
The
data type appropriate to store address is .
i. Memo ii. Currency iii. Text iv.
Auto number
33.
A
collection of records for a single subject, such as all of the customer
records.
i. Field ii. Record iii.
Table iv. Data
34.
Which
of the following is not a data type in Microsoft Access?
i. Text ii. Currency iii.
Hypertext iv. Date/Time
35.
The
default field size of “AutoNumber” data type is .
i. Byte ii. Integer iii. Long Integer iv.
Long Integer
36.
Which
of the following is not MS-Access database object?
i.
Table ii. Form iii. Query iv. Print
37.
Which
of the following data type is appropriate to store gender of person in terms M
or F?
i.
Memo ii. Currency iii. Yes no iv. Auto number
38.
Form
is designed for
i.
filters data ii. Sort
data iii. Sort data iv. Modify data
39.
Query
is used to
i.
retrieves data from database ii.
Create table in database iii. Print
database iv. All
40.
Report
is used for
i.
Printing database ii.
Process database iii. Filter
database iv. None
41.
Which
of the following is not a data type?
i.
Picture ii.date/time iii.text iv.number
42.
What
field type is used to store picture in a table?
i.memo ii.OLE iii.hyperlink iv.None
43.
Which
is the example of Relational Database Management System?
i.Oracle ii.FoxBASE iii.Sybase iv.FoxPro
44.
The
datatype which is used for only integer value.
i.text ii.currency iii.number iv.OLE
45.
What
kind of data are kept in memo field?
i.Name
of Student ii.Students phone number iii.Students Bio data iv.Students picture
46.
Which
of the following is the datatype of MS-Access?
i.yes/no ii.true/false iii.on/off iv.All
47.
A
field is also known as
i.records ii.column iii.Database iv.entity
48.
Which
component of MS-Access is used to enter data?
Query Forms Report Both (i) and (ii)
49.
__________
is a Database Management System.
DBase MSAV EXCEL All of above
50.
A
column in MS-Access Table is __________
Field Query Database Record
51.
MS-Access
is a
DBMS RDBMS Database Metabase
52.
A
row in a table is known as _____________.
Field Content Record Text table
53.
Which
is the database?
Data of SLC Exam Oracle MS-Access Excel
54.
MS-Access
is used to create _____________.
Database DBMS Record Table
55.
Number
field is used for storing only _______________.
Number Text and Number Number
and Time Number and Year
56.
___________
is not DBMS.
Oracle dBase FoxPro Paint
57.
Which
is an example of database?
DBase MS-Access Telephone
Directory All
58.
Report
is the printed output we generate from _______________.
Table Query Forms Both (i) and (ii)
59.
Which
of them is not a data type?
Memo Yes/No Time/Date Caption
60.
Which
is the subtypes for the number data type?
Hyperlink Bit Index Integer
61.
database
is a
i.tool
of editing documents ii. way
to automate common tasks
ii.
collection of related information
62.
a
collection of records for a single subject,such as all of the customer record
is called
i.Field
ii.Record iii.Table
63.
……………
defines a standard pattern for the appearance of all data entered in the field
i.format ii.input mask iii.default value
64.
Which
component of MS-ACCESS does not allow entering data?
i. Table ii. Query iii.
Form iv. None of them
65.
……………
is not the data type of MS-Access.
i) Number ii) Text iii) Memo iv) Form
66.
……………
is the DBMS.
i) Fox-Pro ii) MS-Excel iii) Lotus-123 iv) All of the above
67.
Primary
key does not accept ……………
i) Text ii) Number iii) Null value iv) None of the above
68.
Which
is not a type of query?
i) Search ii) Select iii) Update iv)All of the above
69.
Collecting multiple related files is called:
i)Records ii)Table iii) Forms iv)Query
70.
The
data type appropriate to store salary is:
i)Memo ii)Currency iii)Text iv)
Auto number
71.
Which
of the following is not a database application?
i) Oracle ii) Foxpro iii) MS-Access iv) MS-Excel
72.
Memory
space consumed by a currency data type maximally is …………
i) 2 bytes ii) 4 bytes iii) 8 bytes iv) 1 GB
73.
c) The default data type of MS-Access is:
i) Number ii)Text iii)
Memo iv) Auto number
74.
Which
is suitable data type to store video?
i) Text ii) Number iii) Hyperlink iv)
OLE object
75.
……………..
query changes value in main table.
i) Select ii) Update iii) Both (i) &(ii) iv) None of the above
Answers:
|
1.MDB
|
2.Design View
|
3.64
|
4.Memo
|
5.Currency
|
|
6. 2048
|
7. 4 Bytes
|
8.No null
|
9.Validation Rule
|
10.Color
|
|
11.>
|
12.Data
|
13.50
|
14. Report Card
|
15.Application
|
|
16.dBASE
|
17.Table
|
18.Counter
|
19.Report
|
20.Validation Rule
|
|
21.All of above
|
22.Indexing
|
23.Field Size
|
24.Yes/No
|
25.! Bit
|
|
26.database
|
27.field properties
|
28.primary
|
29.Referential integrity
|
30.all of the above
|
|
31.8 bytes
|
32.text
|
33.table
|
34.hypertext
|
35.Byte
|
|
36.Print
|
37.yes/no
|
38. modify data
|
39.retrive data form database
|
40.Printing Database
|
|
41.Picture
|
42.OLE
|
43.Oracle
|
44.Number
|
45.Students Picture
|
|
46.Yes/no
|
47.Column
|
48.Forms
|
49.DBASE
|
50.Field
|
|
51.RDBMS
|
52.Record
|
53.data of SLC exam
|
54.Database
|
55.Number
|
|
56.Paint
|
57.Telephone Directory
|
58.Both (i) and (ii)
|
59.Caption
|
60.integer
|
|
61.collection of related information
|
62.Table
|
63.input mask
|
64.Query
|
65.Form
|
|
66.Fox-Pro
|
67.Null value
|
68.Search
|
69.Table
|
70.Currency
|
|
71.MS_EXcel
|
72.8 bytes
|
73.Text
|
74.OLE Object
|
75.Update
|
80 True and False
Questions
1.
A
field name refers to the category of information about a subject.
2.
You
cannot delete a field in a database once they have been defined.
3.
The
primary key is an optional field in MS-Access table.
4.
The
primary key in a table is a field that contains information unique to the
records.
5.
Many
related fields makeup a record and many records makeup table.
6.
A
query is used to select fields and records from one or more tables.
7.
A
select query retrieve data from one or more tables using criteria you specify.
8.
Form
is a graphical interface through which data can be printed or displayed is
specified format.
9.
Database
has been being used knowingly or unknowingly in our daily life.
10.
The
maximum field size of text field is 255 characters.
11.
Pictures
and graphics cannot be stored in the table in MS Access 2007.
12.
Form
is the source of table.
13.
The
primary key field of a table allows the duplication of data.
14.
Report
is used to enter the data into the table in MS-Access 2007.
- Field
names are used to define properties for a database.
- Lookup
Wizard is a tool that automates many database tasks.
- Default
field size of text type of data is 65535 characters.
- Date/Time
type of data requires 8 bytes of memory.
- Removing
a primary key does not delete a field.
- FORMAT
property allows us to delete data from database.
- Subtype
of number data type is integer.
- Deleting
a field does not delete data in the field.
- Validation
rule is used to specify whether a value is required in a field.
24.
Indexed field property speeds up
searching and sorting of records based on a field.
25.
You
cannot insert any field after entering data in the table.
26.
Query
allows viewing the desired records only.
27.
Logical
field has the size 2.
28.
The
information can be used as data for the further processing.
29.
A
database can be managed manually.
30.
DBMS
is application software.
31.
The
Auto Number data type generates random number automatically whenever a new
record is added to a table.
32.
A
query can be created without tables.
33.
A
report can be used to modify data of a table.
34.
Form allows you to
select specific data from one or more tables.
35.
The default field size
for a field with a data type of Text is 50 characters.
36. Microsoft Access is a Relational
Database Management System.
37. A query is a collection of
related data stored in an organized manner.
38. A form is a user-friendly way of
entering, displaying an editing data stored in a table.
39.
Queries
are used to display records onscreen to make them easier to enter new records
and to make change in an existing records.
40.
Primary
key field cannot be left blank.
41.
We
cannot change data type of a field.
42.
Memo
field is used to store long information beyond of the text.
43.
Yes/No
Logical field stores one bit of data.
44.
Query
can be used to apply mathematical calculations in the table.
45.
We
can make the form as the source of table.
46.
A
form allows displaying one complete information at once.
47.
A
query is used to select records from many tables.
48.
Index
decreases the speed of the query and sort operations.
49.
Report
is used to prepare database for final printing.
50.
A
database file of MS-Access can have only one table.
51.
The
extension of MS-Access database file is MDB.
52.
A
field can’t be declared with data type.
53.
Logical
value can also be stored in database.
54.
Hyperlink
field type in used to store photographs.
55.
A
query cannot be the source for a form.
56.
Primary
key field may contain the same value in two records.
57.
A
report can be used to delete record from a table.
58.
Index
accelerates the query and sort operation.
59.
DBMS
is word processing software.
60.
A row in a table is called field and it contains a specific
piece of informarion within a record.
61.
Data validation enables you to limit the values that can be
accepted into a field.
62.
A default value is one that is not displayed automatically
for the field into a field.
63.
The data filter selects the required records and displays the
result.
64.
Default data type of MS-Access is a number.
65.
Action query makes changes in a table.
- A
query is database object that creates a datasheet of selected fields and
records from one or more tables.
67.
Graphics can also be
stored in MS-Access database.
68.
Maximum field size of
memo field is 256 characters.
69.
A
query is used to select fields and records from many tables.
70.
MS-ACCESS
is a spread-sheet software.
71.
The
data in primary key field need to be unique and not null.
72.
Primary key does not accept null value.
73.
Memo datatype cannot be indexed.
74.
A
query is used to select fields and records from many tables.
75.
MS-Access
is not a spreadsheet software.
76.
Default
text field size is of 255 characters.
77.
A
database can contain multiple tables.
78.
A
row in a table is known as record.
79.
Data
like sound and pictures are held by memo data type.
80.
Update Query does not change the data of table.
Answers:
|
1.True
|
2.Fasle
|
3.True
|
4.True
|
5.True
|
|
6. True
|
7. True
|
8.False
|
9.True
|
10.True
|
|
11.False
|
12.Flase
|
13.Flase
|
14.False
|
15.False
|
|
16.True
|
17.False
|
18.True
|
19.True
|
20.False
|
|
21.True
|
22.False
|
23.False
|
24.True
|
25.False
|
|
26.False
|
27.False
|
28.True
|
29.True
|
30.Ture
|
|
31.False
|
32.False
|
33.False
|
34.False
|
35.True
|
|
36.True
|
37.False
|
38.True
|
39.False
|
40.True
|
|
41.False
|
42.True
|
43.True
|
44.True
|
45.False
|
|
46.True
|
47.True
|
48.False
|
49.True
|
50.False
|
|
51.True
|
52.True
|
53.True
|
54.False
|
55.False
|
|
56.False
|
57.False
|
58.True
|
59.Flase
|
60.False
|
|
61.True
|
62.Flase
|
63.True
|
64.False
|
65.True
|
|
66.True
|
67.True
|
68.False
|
69.True
|
70.False
|
|
71.True
|
72.True
|
73.True
|
74.True
|
75.True
|
|
76.False
|
77.True
|
78.True
|
79.False
|
80.False
|
40
Fill in the Blanks
1.
___________________
is an organized collection of related data in tabular form.
2.
DBMS
is a general program deigned to manage a ___________________
3.
___________________
is the raw facts to generate information.
4.
_________________________
is the processed value which we get after we get after processing by the
computer.
5.
SQL
stands for _________________________
6.
A
primary key cannot contain the___________________ values.
7.
___________________is
the linking field between two values.
8.
A
text data type allows the field to contain up to ___________________
characters.
9.
A
_____________ is a collection of related data.
10.
A
______________ contains records and field.
11.
A
______________ is a fixed field which uniquely identifies every record in a
table.
12.
You
cannot enter duplicate values in a _______________ field.
13.
A
combination of two or more keys which can be used as a primary key is called a
_________________ key.
14.
Maximum
width of field is _________.
15.
Memo
field can hold ___________ characters.
16.
Access
is a__________________ database management system software.
17. The default field size for text
type is _______________ characters.
18. An _______________ is the format we will assign for the
introduction of values into a field.
19. The _______________ property is used to define a
default value that is automatically entered in field when you add a new record,
at o time of data entry.
20. _______________ allows you to retrieve
specific information from a table in Microsoft Access 2003.
21. _______________ help us to retrieve and view only those
records from the database tables that meet a specific condition or criteria set
by us.
22. _______________ enable you to format your
data in an attracting and informative layout for printing.
23.
A
collection of related data of a person or anything is known as _______________.
24.
A
column in a table is called _____________ and row in a table is
called____________.
25.
Primary
key value must not be_______________.
26.
______________
is the field types used to store text that is more than 255 character.
27.
______________
field type automatically enters number in a field which increase by one for
every new record.
28.
We
can change data type of field in _______________ view.
29.
___________________
is used to make sure that the data entered in a field is within the criteria
set by the user.
30.
________________
query is used to change record in a table at a single operation.
31.
_______________
query is used to delete records from the table.
32.
A _____________extracts and arranges information
from a table in a manner that you specify.
33.
Delete
query is an example of __________________
34.
Query
that makes changes in table is called__________________
- _______________is
a complex set of software program that controls the organization, storage,
management, retrieval of data in database.
- The
smallest unit of data organization is called a _______________
- _______________is
a relational database management system where data is arranged in the form
of tables .
- A
_______________is a database object that creates a datasheet of selected
fields and records from one or more tables.
- A
_______________Is a database object used primarily to display records on
screen, to make it easier to enter new records and to make changes to the
existing records.
- The
_______________View window is the place where you design reports from a
scratch or add your own touches to reports you create with the report
wizard.
Answers:
|
1.database
|
2.database
|
3.Data
|
4.Information
|
5.Structured Query Language
|
|
6. duplicate or null
|
7. Foreign Key
|
8.255
|
9.database
|
10.table
|
|
11.primary key
|
12.primary
|
13.composite
|
14.64 characters
|
15.65,535
|
|
16.Rational
|
17.50
|
18.input mask
|
19.default value
|
20.Filtering
|
|
21.Query
|
22.Report
|
23.database
|
24.field and record
|
25.null
|
|
26.Memo
|
27.Auto Number
|
28.table design
|
29.Validation Rule
|
30.Action Query
|
|
31.Delet
|
32.query
|
33.action query
|
34.update query
|
35.DBMS
|
|
36.field
|
37.MS_Access
|
38.query
|
39.form
|
|
20
Match the Following
1.
Data
-presentation of result
Record -organized
collection of data information
Field -graphical
interface for data entry
Report -column on
datasheet
Query -value
Table -software
Primary key -row on a
datasheet
DBMS -retrieving
editing information conditionally
Form -sorting data
in rows and columns
Database -a field with
unique field content
2.
Number 50
Yes/No 8 bytes
Currency Long integer
Text 1
bit
short
integer
3.
Data redundancy Error message
Validation Text Pattern of data in a field
Input Mask Lookup wizard
Validation Rule Data duplication
Limits the value
4.
Indexing data Retrieves data
Long text Caption
FoxPro Memo field
Label for a field DBMS
Searching
fast
5.
Text 2048
characters
Currency up to 255 Characters
Memo 8
Bytes
Hyperlink 0-65535 Characters
4
Bytes
6.
Data Integrity No.
of character can be entered
Automatic Contains distinct value
Field size Validation Rule
Primary key Indexed
Default
value
7.
Query A
collection of programs that enables you to store, modify, and extracts
information from a database
DBMS A
field which uniquely identifies every record in a table.
Table A
set of information stored about a particular entry.
Record An
arrangement of data in row and column format.
Primary Key A
database object that creates a datasheet of selected fields and records from
one or more tables.
8.
OLE Formatted printout
Form Picture
Indexing Data Entry
Report Fast Searching
Text
9.
Query Printed format
Form Stores data
Table Allows view, edit,
input data
Report Extracts selected
record
DBMS
10.
Data type Field property
Format Relationship
Form Referential
Integrity
One-to-one Database
Object
Memo
11.
Index database
Data
redundancy software
Record easy to search
DBMS repetition of
data
Tuple
12.
Form database
Primary key data type
Advance Filter text control
Hyperlink unique
identification of record
Query
13.
Sort mass
change
Single precision DBMS
FoxPro memo field
Update query sub type of number
Arranging
data
14.
Mark ledger Predefined formats
Wild cards database
Wizard primary key
Relationship * and?
Report
15.
Query Printed format
Form Stored data
Table Allows view, edit,
input data
Report Extracts the selected
record for view
DBMS
16.
Default value 255 Characters
Fox Pro Column Name
ext DBMS
Field Field Properties
Search fast
17.
OLE Report
Data entry Picture
Indexing Table
Formatted printout Fast searching
Form
18.
Indexing Limits the
value
Report Data type
Validation Rule Error messages
Hyper link Final output
Search
fast
19.
OLE Data Entry
Hyperlink Formatted Hardcopy
Report 1 GB
Form Up to 255 characters
Up
to 2048 characters
20.
Indexing Data Size upto 1 GB
Form Column of datasheet
Field Row on a datasheet
OLE object Searching Fast
Graphical
interface for data entry
Answers:
|
1.d,j,I,c,a,h,b,e,f,g
|
2.d,c,a,b,-
|
3.b,c,-,a,d
|
4.-,d,b,c,a
|
5.d,a,b,c,-
|
|
6. c,d,a,-,b
|
7. b,e,d,c,a
|
8.d,a,b,c,-
|
9.d,c,b,a,-
|
10.b,d,-,c,a
|
|
11.-,d,a,b,c
|
12.-,d,a,b,c
|
13.d,c,-,b,a
|
14.c,a,d,b,-
|
15.Repeated with Q. Number 9
|
|
16.c,d,b,a,-
|
17.d,a,-,c,b
|
18.c,d,-,b,a
|
19.d,c,a,-,b
|
20.d,c,-,a,b
|
***
