Database System

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.

note!Answer: B) Table
Tables are the objects in Access that actually store data.

note!Answer: C) Primary key
A primary key uniquely identifies each record in a table.

note!Answer: B) .MDB
Access database files traditionally use the .mdb extension (newer versions use .accdb).

note!Answer: D) 255
The maximum field size for a Text field in MS Access is 255 characters.

note!Answer: B) MS ACCESS
MS Access is a database management system; the others are an operating system, word processor and spreadsheet.

note!Answer: A) 8 byte
In MS Access, the Date/Time data type uses 8 bytes of storage.

note!Answer: A) Field
A column in a table is called a field, while a row is a record.