Is3110 Chapter 1
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 …show more content…
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. …show more content…
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.
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 …show more content…
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. …show more content…
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.