CA ITT MS Access Online Test – CA ITT MS Office Free Online Test

ODBC stands for ________________________.

IDEA stands for _________________________.

Full form of PBX is _______________________.

__________ is an organized, logical group of related files.

Full form of COBOL is _______________.

DB2 has been developed by ___________.

DBMS stands for ____________________.

A DBMS that supports a database located at a single site is called a ______________
database.

___________ schema describes the structure and constraints for the whole database.

______ in ER diagram describes a data object in the system.

In an ER diagram, the cardinality of a relationship indicates ____.

Normalization of a data model produces ________________.

In a relational database model, the relation schema describes the
____________________________.

E.F. Codd proposed _____ rules for a relational DBMS.

SQL stands for ______________________.

_____ helps in managing data stored in a computer database.

In MS-Access, __________ are sometimes referred to as “Data Entry Screens”.

In MS-Access, _____ are used to summarize and present data in the tables.

A _____ is a ready-to-use database containing all the tables, queries, forms, and reports
needed to perform a specific task.

One should always start designing a database by first creating its ___________.

In MS-Access, the maximum size of a field of data type Text is _______ characters.

In MS-Access, the size of a field of data type AutoNumber is _______ bytes, if the
FieldSize property is set to Replication ID.

In MS-Access, fields that are part of a table relationship are called __________.

A good database design is one that ________________.

Which of the following is not a table template available in MS-Access?

If MS-Access does not have enough information from what we enter to guess the data
type, the data type is set to ___________.

Maximum size of a field name is _____ characters in MS-Access, including spaces.

When we create a new table, Access automatically creates a primary key for us and
assigns it a field name of ______.

In MS-Access, use ____________ field property to customize the way the field appears
when displayed or printed.

In MS-Access, use ____________ table property to define a criteria to display only
matching rows in Datasheet view.

In MS-Access, a ______ limits a view of data to specific records without altering the
design of the underlying query, form or report.

In MS-Access, filters are not available in which of the following views?

Type-specific filters are not available for____ field in MS-Access.

In MS-Access, the filters based on selection are not available for _____________ field.

In MS-Access, ___ represents a string of characters when specified in a filter text box.

In MS-Access, set ____________ property to “Yes” to enable the last-applied sort order to
be applied automatically the next time when we open the object.

In MS-Access, a memo field is sorted as _____ in ascending order.

In MS-Access, a foreign key without a primary key reference is called a/an
_____________.

A query consists of search criteria expressed in a database language is called ________.

___________ queries are very popular in data management because they allow for many
records to be changed at one time.

In ____________ form in MS-Access, the user can see the data in a row and column
format.

In MS-Access, the form layout is __________ by default.

In MS-Access, _______ displays multiple pages in a file folder type interface.

Unbound controls in MS-Access, are those controls which ____.

In MS-Access, ___________ properties affect how a value is displayed and the data
source it is bound to.

Which of the following is not a type of report in MS-Access?

In which order the following steps are performed in the process of creating a report in MSAccess:
1.Assembling the data
2.Creaing the report design
3.Defining the report layout
4.Prining or viewing the report

Which of the following is not a third-generation language?

If a single-user database runs on a personal computer, it is also called a
___________________.

In an ER diagram, a relationship is represented by a ___________.

If a relational database table is in 3NF and it contains only one candidate key, it is in
__________.

In MS-Access, ____________ often serve as the record source for forms and reports.

When we create a new blank database, Access opens an empty table named Table1 in
____________ view.

In MS-Access, ______________ data type creates a field that allows the user to choose a
value from another table or from a list of values by using a list box or combo box.

Which of these should be the first step in designing a database?

In Access, the ______________ of a table is unique for each record.

In MS-Access, use ____________ table property to supply an expression that must be
true whenever we add or change a record.

In Access, when we apply a filter to a column that is already filtered,
_______________________________.

In MS-Access, a view cannot be sorted on ______________ fields.

___________ queries are useful for summarizing information, calculating statistics,
spotting bad data and looking for trends in a database.