Title: Course Final Exam
Course: ITSW 1007.90024 C1 Intro. to Database

Q: Microsoft Access follows which model for its design?
- Flat
- Hierarchical
- Relational
- Network
A: Relational

Q: Major objects in an Access database include the following:
- Fields, Records, and Tables
- Fields, Records, and Queries
- Forms, Queries, Reports, and Tables
- Fields, Queries, Reports, and Tables
A: Forms, Queries, Reports, and Tables

Q: Which database object can specify criteria or conditions to show records and fields from one or more tables?
- Form
- Query
- Report
- Table
A: Query

Q: The _______________ bar alerts you that the database may contain malicious code.
- Status
- Security System
- Message
- Program Code
A: Message

Q: Which of the following will NOT appear in a ScreenTip?
- Images
- Shortcut Keys
- Descriptions
- Examples
A: Examples

Q: Which of the following is NOT a method of switching between Datasheet and Design View?
- View button in the Views control group
- Navigation Pane
- View Shortcut button
- Right-click menu
A: Navigation Pane

Q: Although column widths can be set individually, _______________ cannot.
- row widths
- row heights
- column heights
- column sizes
A: row heights

Q: The _______________ command reclaims unused space and improves database efficiency.
- Squeeze Database
- Repair Database
- Save
- Compact and Repair Database
A: Compact and Repair Database

Q: A(n) _______________ icon appears while you are adding or editing text. This shape indicates the record changes have not been saved.
- Star
- Asterisk
- Pencil
- Question Mark
A: Pencil

Q: With the pencil icon in the Record Selector, which key can you press to undo the changes in a field?
- Delete
- Tab
- Backspace
- Escape
A: Escape

Q: In Datasheet View, new records are added to a table _______________.
- In alphabetical order
- At the end of the table
- At the beginning of the table
- In numerical order
A: At the end of the table

Q: Which of the following is the correct method to delete a record from a table?
- Click in the Record Selector and press [Delete].
- Click anywhere in the record and press [Delete].
- Click anywhere in the row and press [Esc].
- Click in the Record Selector and press [Backspace].
A: Click in the Record Selector and press [Delete].

Q: Which of the following Access objects can be linked to a form?
- Table
- Record
- Field
- Report
A: Table

Q: Which of the following statements is NOT applicable to forms?
- They can be used to enter, view, sort, edit, and print data.
- They are designed for screen work.
- They are easier to use than a table.
- They have the same layout as their underlying table.
A: They have the same layout as their underlying table.

Q: The Search tool CANNOT be used on:
- Tables
- Queries
- Forms
- Macros
A: Macros

Q: Which of the following options in the Find and Replace dialog box sets the search in the current field or the entire table?
- Look In
- Match: Whole Field
- Match: Start of Field
- Search All:
A: Look In

Q: The Search tool begins its search at the first field of the _______________ record.
- Current
- First
- Newest
- Default
A: First

Q: In a table, _______________(s) are displayed in the order in which they were entered. Often this order is not useful.
- Formula
- Format
- Layout
- Record
A: Record

Q: A table in Access can have _______________ active filter(s).
- One
- Two
- Four
- Eleven
A: One

Q: Which is not an option for Filter on a numeric field?
- Between
- Contains
- Equals
- Greater Than
A: Contains

Q: Which of the following data types automatically generates a consecutive number?
- Autonumber
- Memo
- Number
- Text
A: Autonumber

Q: In a table, which of the following can contain a narrative to help clarify to others the purpose of a field?
- Data Type
- Field Description
- Field Name
- Field Properties
A: Field Description

Q: Which of the following views displays the field name, description, and properties of a table?
- Datasheet View
- Design View
- Layout View
- Table View
A: Design View

Q: A(n) _______________ is a field or set of fields in a table that provides a unique identifier for every record.
- Foreign Key
- Primary Key
- Corner Key
- Unique Key
A: Primary Key

Q: A relationship is created between how many tables?
- One
- Two
- Three
- Any Number
A: Two

Q: Relationships change a flat database, containing isolated data, into a relational database, containing _______________ data.
- Disjoined
- Like
- Linked
- Foreign
A: Linked

Q: When referential integrity is enforced, an _____________ symbol displays on the "many" side.
- 1
- M
- Asterisk
- Infinity
A: Infinity

Q: Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
- Queries
- Fields
- Records
- Tables
A: Tables

Q: Which dialog box is accessed to enforce referential integrity in a One-To-Many relationship?
- Change Input Mask
- Edit Relationships
- Insert Subdatasheet
- Show Tables
A: Edit Relationships

Q: A(n) _______________ is a datasheet nested within another datasheet that contains data related or joined to the first datasheet.
- object dependency
- relationship
- report
- subdatasheet
A: subdatasheet

Q: Data stored as a(n) _______________ data type takes up less space than if stored as a text data type.
- number
- field
- calendar
- primary key
A: number

Q: In a query, the lower pane is also known as the _______________ grid
- QBE
- QDA
- QG
- QTE
A: QBE

Q: Which of the following dialog boxes opens while creating a select query in Design View?
- New Query
- Print Query Definition
- Query Properties
- Show Table
A: Show Table

Q: Which of the following search criteria is invalid?
- $45*
- *cal*
- D*m??
- AS150*
A: $45*

Q: Using the keyword _______________ will return records in which the field value equals a defined text.
- Between
- Is Null
- Like
- Not
A: Like

Q: Which of the following statements about criteria in a query is NOT true?
- Criteria can contain wildcard characters.
- Criteria in a query selects or excludes certain records.
- Criteria cannot be specified as an expression.
- Multiple criteria can be specified using AND, OR, and relational operators.
A: Criteria cannot be specified as an expression.

Q: Forms can be based on a _________ or query.
- Table
- Form
- Report
- Macro
A: Table

Q: Which Form tool creates a new form that shows both a form and datasheet views?
- Form
- Form Wizard
- Multiple Item Form
- Split Form
A: Split Form

Q: Which of the following views allows you to use layout selector to align controls?
- Datasheet
- Design
- Form
- Layout
A: Layout

Q: A ___________ is a set of unified design elements and color schemes for bullets, fonts, horizontal lines, background images, and other elements of a database object.
- Theme
- Layout
- Design
- Justification
A: Theme

Q: Which of the following form sections is often used to display title information or page numbers to be repeated on each page?
- Detail
- Form Footer
- Form Header
- Page Header
A: Page Header

Q: In a report you can display data in an attractive _______________ that may include variations in fonts, colors, shading, and borders.
- variant view
- field selection
- format
- format group
A: format

Q: The page count of a report can be determined by clicking the _______________ button.
- First Page
- Previous
- Next
- Last Page
A: Last Page

Q: Which of the following report sections prints at the bottom (last page) of the report?
- Group Footer
- Page Footer
- Report Footer
- Page Footer
A: Report Footer

Q: A _______________ often display summary data such as totals or counts.
- Group Header
- Group Footer
- Report Header
- Page Footer
A: Group Footer

Q: Grouping allows you to show detail and _________________ data.
- New
- Unique
- Summary
- Old
A: Summary

Q: A(n) _______________ helps accelerate the searching and sorting of data in a table
- Index
- Join
- Query
- Relationship
A: Index

Q: A(n) _______________ query locates data from one or more tables.
- Select
- Summary
- Parameter
- Action
A: Select

Q: Changes to parameters in a query are made through the Query ____________ dialog box.
- Group By
- Update to
- Criteria
- Parameters
A: Parameters

Q: Which of the following is the result of =MonthName([Date]), where [Date] = February 5, 2008?
- Feb
- February
- 2
- 02
A: February