Computer & IT

note!Answer: B) Raw facts
Data are raw, unprocessed facts; information is data that has been processed into a useful form.

note!Answer: B) Report
Reports are the MS Access object designed for formatting and printing data.

note!Answer: A) Filter
The main objects of an MS Access database are tables, queries, forms, reports, macros, and modules; a filter is an operation, not an object.

note!Answer: A) Value cannot be entered into second table other than specified in the first table's field
Referential integrity ensures that a foreign key value in the related table must match an existing primary key value in the first table.

note!Answer: B) Report wizard
Report Wizard is one of the standard methods for creating a report in MS Access.

note!Answer: D) PL/1
Oracle, MySQL and Sybase are database management systems, while PL/1 is a programming language.

note!Answer: D) Design View
Design View is used to modify the structure and layout of a form.

note!Answer: C) Append query
An Append query adds new records to an existing table.

note!Answer: A) L
In an Access input mask, 'L' requires a letter entry (A–Z) to be entered.

note!Answer: D) All of the above
Tables in Access can be created using Datasheet View, by importing data, or by linking to external tables.

note!Answer: A) Memo
The Memo data type stores long text up to about 64,000 characters, unlike the Text type which has a much smaller limit.

note!Answer: C) 64
In MS Access, a field name can be up to 64 characters long.

note!Answer: A) Table
Tables store the data in an Access database, so they are the back-end object.

note!Answer: C) Relationship
An association between entities in a database is called a relationship.

note!Answer: C) Data control Language
DCL stands for Data Control Language, used to control access and permissions on data.

note!Answer: C) Freeze
Freeze Fields keeps selected columns visible on the left while you scroll horizontally.

note!Answer: B) Text
A Memo field stores long text and numbers.

note!Answer: B) Form
Forms are designed mainly for entering and editing data in Access.

note!Answer: B) Long integer
The default field size for a Number data type in MS Access is Long Integer.

note!Answer: B) Null value
A primary key must be unique and cannot contain null values.