CSCI A114 / INFO I111
Takehome Quiz Three

First semester 2000-2001

Due date
September 26, at the end of the lecture.
Late policy
No late policy. Please turn this on time.
Work policy
Working in groups is accepted but you need to turn in your own version of the assignment.
Task
There are nine groups of questions in this quiz, three for each project we have completed thus far. Please print this page, write your answers to the questions on the page, as on an exam, then turn the page with your answers to Adrian.
Grading
Feedback will be provided within a week. Grades will be posted on-line.

Access 2000 Project 3 - Multiple Choice

Name _________________________ Date ___________

Instructions: Print the page. Circle the correct response.

  1. Indexes ____________.

    a. allow rapid retrieval of tables
    b. allow rapid retrieval of records
    c. provide an efficient alternative to sorting
    d. both b and c

  2. To create a multiple-field index, click the ____________ button on the toolbar in the Table Design window.

    a. Secondary Index
    b. Create Secondary Indexes
    c. Indexes
    d. Create Indexes

  3. Data entered by users must conform to ____________ rules.

    a. Data
    b. Validation
    c. Integrity
    d. Edit

  4. To search for a specific record in a table, select the field to search and then click the ____________ button on the toolbar.

    a. Search
    b. Locate
    c. Find
    d. Query

  5. To force all letters in a field to display as uppercase, use the ____________ symbol in the Format text box.

    a. ?
    b. >
    c. !
    d. &

  6. A(n) ____________ key is a field in one table whose values are required to match a primary key of another table.

    a. master
    b. auxiliary
    c. foreign
    d. matching

  7. The property that the value in a foreign key must match that of another table's primary key is called ____________ integrity.

    a. entity
    b. interrelation
    c. relationship
    d. referential

  8. To delete a record from a table, click the record selector for the record, and then press the ____________ key(s).

    a. CTRL+DELETE
    b. DELETE
    c. CTRL+D
    d. CTRL+U

  9. To specify referential integrity, click the ____________ button on the toolbar.

    a. Referential Integrity
    b. Relationships
    c. Integrity
    d. Primary Key

  10. To add a field to a table structure, select the field directly below the location for the new field, then press the ____________ key(s).

    a. CTRL+N
    b. CTRL+I
    c. ALT+INSERT
    d. INSERT
    Access 2000 Project 3 - True/False

    Instructions: Print the page. Circle T if the statement is true or F if the statement is false.

    T

    F

    		1. Indexing adds little efficiency to large tables containing over 20,000 records.

    T

    F

    		2. Access automatically creates an index for all foreign keys.

    T

    F

    		3. Validation rules can not indicate a required field.

    T

    F

    		4. You can add and change records using Datasheet view, but you can delete records only through Form view.

    T

    F

    		5. To change the order in which records appear in a table, click any record in the field you wish to order then click the Order Records Ascending or Order Records Descending button on the toolbar.

    T

    F

    		6. To update a group of records in one operation, use an Update query.

    T

    F

    		7. To delete a group of records that satisfy a criteria, use a Delete query.

    T

    F

    		8. It is not possible to resize a column in the datasheet.

    T

    F

    9. When you create a database, you define its structure.

    T

    F

    		10. In general, the type of relationship between two tables specified by the Relationships command is referred to as a many-to-many relationship.
    Access 2000 Project 3 - Short Answer

    Instructions: Fill in the best answer.

    1. In a database environment, _______________ means looking for records that satisfy some criteria.

    2. You can go directly to a record by giving the value in a field by using the _______________ on the Form View toolbar.

    3. The simplest type of filter is called _______________.

    4. Indicating the names, types, and sizes of all fields is known as defining the database's _______________.

    5. To resize a column, you can drag the column's _______________.

    6. To affect the way data is displayed in a field, you can use a(n) _______________.

    7. Clicking the plus symbol in a row of a table displays a(n) _______________.

    8. Click the _______________ at the top of a column to select an entire field in a datasheet.

    9. The field or fields on which an index is built is called the _______________.

    10. Indexes whose key is a combination of fields are called _______________.
    Access 2000 Project 2 - Multiple Choice

    Name _________________________ Date ___________

    Instructions: Print the page. Circle the correct response.

    1. To list only certain records in a table, use a(n) _____________.

      2. a. list
      b. answer
      c. question
      d. query

    2. To find all Marinas whose Warranty amount is $100 or more, type _____________ as the criteria for the Warranty field.

      3. a. >= $100.00
      b. >=100
      c. =>$100.00
      d. =>100

    3. To clear all the entries in a design grid, on the _____________ menu, click Clear Grid.

      4. a. Edit
      b. File
      c. Query
      d. View

    4. The wildcard symbols available for use in a query are the _____________ and the _____________.

      5. a. double period (..), asterisk (*)
      b.question mark (?), asterisk (*)
      c. double period (..), at symbol (@)
      d. question mark (?), ampersand (&)

    5. Equal to (=), less than (<), and greater than (>) are examples of _____________.

      6. a. criteria
      b. values
      c. comparison operators
      d. compound criteria

    6. When two or more criteria are connected with AND or OR, the result is called a _____________.

      7. a. simple criterion
      b. pattern criterion
      c. character criterion
      d. compound criterion

    7. To add an additional table to a query, click _____________ on the shortcut menu for the Select Query window.

      8. a. Join Table
      b. Show Table
      c. Add Table
      d. Include Table

    8. Use a query to _____________ tables; that is, find records in two tables that have identical values in matching fields.

      9. a. merge
      b. match
      c. combine
      d. join

    9. To remove a table from a query, right-click any field in the field list for the table and then click _____________ on the shortcut menu.

      10. a. Remove Table
      b. Delete Table
      c. Clear Table
      d. Erase Table

    10. To add a Total row to a design grid, click _____________ on the shortcut menu for the Select Query window.

      a. Aggregates
      b. Functions
      c. Statistics
      d. Totals
      Access 2000 Project 2 - True/False

      Instructions: Print the page. Circle T if the statement is true or F if the statement is false.

      T

      F

      		1. To include all the fields in a record in a query, click the word ALL that appears at the top of the field list.

      T

      F

      		2. To create a compound criterion using OR, enter each criterion on a separate line.

      T

      F

      		3. To create a compound criterion using AND, type the word, INTERSECT, before the second criterion.

      T

      F

      		4. To include calculated fields in queries, enter a name for the calculated field, a colon, and then the expression in one of the columns in the Field row.

      T

      F

      		5. When you enter a criterion for a particular field, that field must appear in the results of the query.

      T

      F

      		6. To find all Marinas whose Warranty amount is $50 or less, type <=50 as the criterion for the Warranty field.

      T

      F

      		7. To run a query click Run on the Edit menu.

      T

      F

      		8. When you sort a query on more than one key, the major sort key must appear to the right of the minor sort key.

      T

      F

      9. To omit duplicates from a query, use the Properties command and specify Unique Values Only.

      T

      F

      		10. The wildcard symbols available for use in a query are ! and &.
      Access 2000 Project 2 - Short Answer

      Instructions: Fill in the best answer.
      1. A(n) _______________ is a question represented in a way that Access can understand.

      2. To create a query, you make entries in a special window called a(n) _______________.

      3. The lower pane of the Select Query window contains the _______________, where you specify fields to be included, sort order, and criteria.

      4. _______________ are symbols that represent any character or combination of characters.

      5. When data must satisfy more than one criterion, use a(n) _______________.

      6. In a(n) _______________, each individual criterion must be true in order for the compound criterion to be true.

      7. A major key also is called a(n) _______________.

      8. To find records in two tables that have identical values in matching fields, you first must _______________ the tables.

      9. COUNT, SUM, AVG, MAX, and others are known as Access' built-in _______________.

      10. Creating groups of records that share some common characteristics is known as _______________.
      Access 2000 Project 1 - Multiple Choice

      Name _________________________ Date ___________

      Instructions: Print the page. Circle the correct response.

      1. In Access, a database is ____________.

        2. a. the same as a file
        b. a collection of tables
        c. a software product
        d. none of the above

      2. Which of the following is not a benefit of controlling redundancy?

        3. a. consistency is maintained
        b. disk space is saved
        c. updating is easier
        d. all of the above are benefits

      3. A field that uniquely identifies a particular record in a table is called a ___________.

        4. a. secondary key
        b. foreign key
        c. principal key
        d. primary key

      4. Access is a (n) ____________.

        5. a. application software package
        b. DBMS
        c. database
        d. both a and b

      5. To delete a record in a table, open the table, select the record, and use the ____________.

        6. a. Delete Record button
        b. DELETE key
        c. Cut Record button
        d. Erase Record

      6. A record in Access is composed of a series of ____________.

        7. a. databases
        b. files
        c. records
        d. fields

      7. To make a field the primary key for a table, select the field and then click the ____________ button on the toolbar.

        8. a. Unique Key
        b. Single Key
        c. First Key
        d. Primary Key

      8. To remove a field from a table structure, select the field and then press the ____________ key(s).

        9. a. delete
        b. ctrl+d
        c. ctrl+delete
        d. ctrl+y

      9. To switch from Form view to Datasheet view click the ___________ on the ___________ toolbar and then click Datasheet view in the list that displays.

        10. a. View button arrow, Formatting
        b. View button arrow, Database window
        c. New Object button, Database window
        d. Show Datasheet button, Normalization

      10. To generate a custom report containing some of the fields of a Table in a user-defined order, you should use the New Object: Report button, then click ____________ in the list.

        11. a. Label Wizard
        b. Autoreport: Tabular
        c. Report Wizard
        d. Autoreport: Columnar

      Access 2000 Project 1 - True/False

      Instructions: Print the page. Circle T if the statement is true or F if the statement is false.

      T

      F

      1. A primary key may have duplicates in a database.

      T

      F

      2. A field contains a specific piece of information within a record.

      T

      F

      3. If you do not specify the width of a text field, Access assigns a width of 25.

      T

      F

      4. You can use the tab key to move to the next field in a record in Datasheet view.

      T

      F

      5. Field names can be no more than 64 characters in length and can include numeric digits.

      T

      F

      6. The only field type available for fields that must be used in arithmetic operations is number.

      T

      F

      7. To delete a record from a table, select the record and then press the delete key.

      T

      F

      8. The simplest way to create a form is to use the New Object: AutoForm button on the Database window toolbar.

      T

      F

      9. To add records to a table that already contains data, open the table and then click the Append Record button.

      T

      F

      10. Eliminating redundancy in a database increases consistency.

      Access 2000 Project 1 - Short Answer

      Instructions: Fill in the best answer.

      1. A(n) _______________ contains information about a given person, product, or event.

      2. A(n) _______________ is a specific piece of information within a record.

      3. The _______________ contains buttons that allow you to perform certain tasks more quickly than using the menu bar.

      4. The _______________ is a small box or bar that is used to select an entire row.

      5. In _______________, a table is represented as a collection of rows and columns.

      6. In Datasheet view, use the _______________ to move to new locations in a table.

      7. To print across the length of a page, use _______________ orientation.

      8. To display data on the screen a single record at a time, use _______________.

      9. _______________ are the lines that are printed for each record and contain only those fields you specify.

      10. Storing the same fact in more than one place is referred to as _______________.

      Last updated: September 15, 2000 by Adrian German for A114/I111