Computer & IT

note!Answer: B) Database Administrator
DBA stands for Database Administrator, the person who manages a database system.

note!Answer: D) Universal Naming Convention
UNC stands for Universal Naming Convention, a format for specifying network file paths.

note!Answer: D) Input Method Editor
IME stands for Input Method Editor, used to type non-Latin scripts on a computer.

note!Answer: A) Dynamic Data Exchange
DDE stands for Dynamic Data Exchange, a Windows mechanism for sharing data between applications.

note!Answer: C) Remote Job Entry
RJE stands for Remote Job Entry, submitting batch jobs to a computer from a remote terminal.

note!Answer: D) Object Relational Database Management System
ORDBMS stands for Object Relational Database Management System.

note!Answer: B) Validation data
Validation checks that input data meets defined rules before it is processed.

note!Answer: A) Unbound
A control that is not linked to a table field is called unbound.

note!Answer: B) Open Database Connectivity
ODBC (Open Database Connectivity) is a standard API for accessing data across database programs.

note!Answer: A) Data dictionary
A data dictionary is a collection of data elements and their types and definitions.

note!Answer: B) Referential integrity
Referential integrity keeps relationships between tables valid when records are added or deleted.

note!Answer: A) Database
A database is an organised collection of related information about a particular subject.

note!Answer: A) 64 character including space
In MS Access, a field name can be up to 64 characters long, including spaces.

note!Answer: B) 64 character
MS Access allows field names up to 64 characters.

note!Answer: D) All of the above
Access tables can be created in Design view, with the Table Wizard, or by entering data directly in Datasheet view.

note!Answer: D) Space bar
Pressing the Space bar toggles a focused check box on or off.

note!Answer: A) Field
A field holds a single data item, while a record is a complete set of fields.

note!Answer: C) Both of the above
VBA has standard modules and class modules, so both types apply.

note!Answer: B) Module
A module is a named unit that groups declarations, statements and procedures together.

note!Answer: A) Relation
In relational database theory, a table is called a relation.