Access Integer field size is for values

Access Integer field size is for values

Access 2010: Chapter 1 – Short Answer Instructions: Fill in the best answer. 1.

A data management system, such as Access, is software that allows you to use a computer to create a database. 2. The rows in the tables are called records.

3. The Long Integer field size is for values in the range of –2,147,483,648 to 2,147,483,647. 4. In Access, all the tables, reports, forms, and queries that you create are stored in a single file called a(n) Access database. 5.

Design view, is only used to create a table or to modify the structure of the table. 6.To see the field size and/or caption for a field, click the field’s row selector, the small box that precedes the field. 7. Portrait orientation means the printout is across the width of the page. 8. Queries are simply questions, the answers to which are in the database.

9. When working with a report in Access, there are four different ways to view the report. They are Report view, Print Preview, Layout view, and Design view. 10. If a problem occurs, you correct the problem by copying this backup copy over the actual database, often referred to as the live database. Access 2010: Chapter 1 – True/FalseInstructions: Circle T if the statement is true or F if the statement is false. T| F| 1.

A record contains a specific piece of information within a field. | T| F| 2. The determination of database requirements is part of a process known as systems development. | T| F| 3.

Access 2010 has a number of reserved words, words that have a special meaning to Access. You cannot use these reserved words as field names. | T| F| 4.

The most common type of relationship you will encounter between tables is the many-to-one relationship. | T| F| 5. Redundancy means storing the same fact in more than one place.

T| F| 6. The Status bar, located at the bottom of the Access window, presents information about the database object, the progress of current tasks, and the status of certain commands and keys; it also provides controls for viewing the object. | T| F| 7. Database users typically use standard guidelines for naming tables. | T| F| 8. To change the default printer that appears in the Print dialog box, click File on the Ribbon, click the Print tab in the Backstage view, click Print in the Print gallery, then click the Name box arrow and select the desired printer. | T| F| 9.

When importing data, you have two choices. You can create a new table or add the records to an existing table. | T| F| 10. Report view allows you to make changes, but it does not show you the actual report. | Access 2010: Chapter 1 – Multiple Choice Instructions: Circle the best answer. 1. In a ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

a. dynamic b. relational c.

static d. linked 2. A unique identifier also is called a(n) ____ key. a. important b.

first c. secure d. primary 3.Each field has a data ____, which indicates what can be stored in the field. a.

type b. property c. tag d. flag 4.

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added. a.

AutoField b. AutoNumber c. AutoRecord d. AutoProperty 5.

Fields whose data type is Number often require you to change the field ____, which is the storage space assigned to the field by Access. a. size b.

width c. depth d. length 6. The ____ contains a list of all the objects in the database.

You use this to open an object. a. Start menu b.Status bar c. Navigation Pane d. Access Pane 7. You work on objects such as tables, forms, and reports in the Access ____ area.

a. report b. datasheet c. table d. work 8.

____ orientation means the printout is across the height of the page. a. Landscape b. Portrait c. either a. or b. d.

neither a. nor b. 9. Database ____, also known as metadata, can include such information as the file’s author, title, or subject.

a. tags b. flags c.

fields d. properties 10. The simplest approach to recovery involves periodically making a copy of the database (called a ____ copy or a save copy). a. vault b. restore c. backup d.

archive