Database System

note!Answer: A) Ctrl + +
In database software such as MS Access, Ctrl++ moves to a new blank record.

note!Answer: B) Click the insert Database button on the database toolbar
In older versions of MS Word, you can insert data from an Access database into a Word report by using the Insert Database button on the Database toolbar.

note!Answer: D) Both a and b
Queries let you view, change and analyze data, and they also act as a record source for forms and reports.

note!Answer: D) All of above
Access supports creating queries by drag and drop in the query design grid, by typing SQL in SQL view, and by using the Query Wizard or Design View.

note!Answer: B) Tables with fields and relationships between tables
The upper pane of the query design window shows the field lists of the tables used, along with their relationships. The lower pane (the design grid) holds fields, criteria and sort options.

note!Answer: B) It indicates whether the field is to be displayed in query result or not
The Show check box controls whether a field appears in the query result. It does not decide whether the field is used in the query.

note!Answer: B) It is an input screen designed to make the viewing and entering data easier
A form in MS Access is an on-screen input interface that makes viewing and entering data easier. It is not a printed page.

note!Answer: C) Queries can include calculated fields that do not exist in table
Queries can create calculated fields that are not stored in the table. Reports are for formatted printing, while queries retrieve and calculate data.

note!Answer: A) A relationship is created
Dropping a primary key onto a foreign key field in another table creates the relationship.

note!Answer: B) Parent, Child
The 'one' side table is the parent table and the 'many' side table is the child table.

note!Answer: A) Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
Referential integrity ensures every foreign key value in the child table matches an existing primary key value in the parent table.

note!Answer: C) is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted
Cascade Delete Related Records automatically deletes related child records when a parent record is deleted.

note!Answer: A) Adds records from a file
The APPEND FROM command adds records from another file into the current table.

note!Answer: C) Both of above
Both right-clicking the line to choose Edit Relationship and double-clicking the line open the edit dialog.

note!Answer: A) OR conditions
In a query design grid, criteria written in different rows (vertically) are combined with OR.

note!Answer: B) write criteria values horizontally
Criteria placed horizontally on the same row are combined with AND.

note!Answer: C) AND
The AND operator places both conditions on the same row of the design grid.

note!Answer: D) And
The AND operator returns a record only when all specified conditions are true.

note!Answer: A) Once in the bugging of the report
The report header prints only once, at the beginning of the report, so an image placed there appears one time.

note!Answer: C) Painter
The Format Painter copies formatting from one control and applies it to another.