Click on the correct response for each question below.
|
1 | | The database wizard allows the user to:
|
| | A) | Create a database using a limited set of forms, fields, which is well suited for an address book or application of that sort.
|
| | B) | Create a database using a generic set of blank tables, forms and queries
|
| | C) | Create a database that is an exact replica of another database the user has already created.
|
| | D) | Create a database based on ones commonly used in business
|
|
|
2 | | When speaking of databases, a switchboard does what?
|
| | A) | It gives the database developer a user-friendly interface for switching between database components.
|
| | B) | It makes it easier for new users to access forms, reports, or queries.
|
| | C) | It provides an easy way to access the underlying tables in your database.
|
| | D) | None of the above.
|
|
|
3 | | The Table Wizard is a great way to create new tables in Access. Which statement best describes the function of the Table Wizard?
|
| | A) | It generates a generic table, then allows you to modify it to fit your needs.
|
| | B) | It asks questions while allowing you to select preset fields from sample table.
|
| | C) | When creation is finished, you have the ability to Modify the design; Enter data into the tables; or Enter data into the tables using the auto generated form.
|
| | D) | Both B and C.
|
|
|
4 | | An Input Mask Wizard is a great way of manipulating the way data is displayed in a field. Which type of fields does the Input Masks Wizard support?
|
| | A) | Text
|
| | B) | Date/Time
|
| | C) | All of the above.
|
| | D) | None of the above.
|
|
|
5 | | When using an input mask, what would be the proper format for a phone number in the following format: (800) 555-1212?
|
| | A) | \(999") "999\-9999
|
| | B) | (999) 999-9999
|
| | C) | \(000") "000\-0000
|
| | D) | (000) 000-0000
|
|
|
6 | | What property for a field should you set it you want to restrict what the user is allowed to enter data into that field.
|
| | A) | Validation Rule
|
| | B) | Input Mask
|
| | C) | Format Rule
|
| | D) | Format Identifier
|
|
|
7 | | When creating a new table, you are presented with 3 choices to assist in the creation of this table. The choices are: (choose all that apply)
|
| | A) | Create table in Design view
|
| | B) | Create table by using wizard
|
| | C) | Create table by enter data
|
| | D) | All the above
|
|
|
8 | | In a ___________ relationship each record in one table is matched to many records in a second table and vice versa.
|
| | A) | A. One-to-Many
|
| | B) | B. Many-to-Many
|
| | C) | C. One-to-One
|
| | D) | D. Many-to-One
|
|
|
9 | | When using the find and replace dialog box which additional options are available?
|
| | A) | A. Match case
|
| | B) | B. Search fields as formatted
|
| | C) | C. Ignore blank fields
|
| | D) | D. Both A and B
|
|
|
10 | | The simple query wizard creates a ___________ query
|
| | A) | A. Simple
|
| | B) | B. Cross-tab
|
| | C) | C. Calculated
|
| | D) | D. Update
|
|