CIS320
Information Systems
Chapter Reading Questions
 

Copy the chapter questions and paste (as unformatted text) to a word document file. 
Answer the questions (using red text) by double clicking on the red line and typing your answer. 
Make sure that your answers are in red text.
Submit each set of answers to Moodle on or before the due date/time.

 

Appendix A

Copy the following questions and paste into a new Word document.  Save as CIS320Chap00Username.  Read and study the Appendix A on Relational Databases and Database Design.  Answer the questions using red text.  Submit the file to Moodle on or before the due date/time listed on the syllabus.

  1. A ___ is a two-dimensional structure made up of rows and columns.  (p. A2)
  2. A ___ is a single row from a table (p. A2)
  3. Each column has a unique name called the ___ name.  (p. A2)
  4. An ___ is a person, place, object, event, or idea for which you want to store and process data.  (p. A2)
  5. ___ key ensure that each row in a table is unique.  It is a column (field) or a collection of columns (fields) whose values uniquely identify each row in a table.    It also cannot be empty.  (p. A3)
  6. A ___ key is a column or a collection of columns in one table in which each value must match the value of the primary key of another table or must be null.  (p. A4)
  7. A ___ -to-many relationship occurs when any row in one table (called the primary table) can match many rows in a second table (sometimes called the related or foreign table), but any row of the second table can only match a single row of the first table.   (p. A5)
  8.  A ___ -to-many relationship occurs any row of the first table matches many rows of the second table and any row of the second table matches many rows of the first table.  In a relational database you must insert a third table between these two to create two one-to-many relationships.
  9. ___ integrity is the constraint specifying that each nonnull foreign key value must match a primary key value in the primary table.  (p. A11)
  10. Data ___ occurs when you store the same data in more than one place.  (p. A14)
  11. ___ is the process of identifying and eliminating anomalies.  It is the method of converting a bubble diagram or conceptual schema into a relational database structure.  (p. A15)
  12. A ___ key is a primary key that consists of a field or a collection of fields that is an inherent characteristic of the entity described by the table.  (p. A19)
  13. A ___ key is a field that is not an inherent characteristic of the entity but is added to the table to act as the primary key.  Often these are defined with the data type: AutoNumber.  (p. A20)

 

Chapter 1
and
Chapter 2

Copy the following questions and paste into a new Word document.  Save as CIS320Chap0102Username.  Read and study Chapters (Tutorials) 1 and 2.  Answer the questions using red text.  Submit the file to Moodle on or before the due date/time listed on the syllabus.

  1. A ___ is a single characteristic or attribute of an entity (person, place, object, etc.).  (p. 4)
  2. A ___ is a collect of fields that describe an entity.  (P. 4)
  3. A ___ is a row of data from a table.  (p. 4)
  4. A ___ database is a collection of related tables.  (p. 4)
  5. A ___ key is a field or concatenated field whose values uniquely identify each record in a table.  No two records can contain the same value for the primary key field.  Also the primary key field cannot be null.  (p. 5)
  6. ___ a database rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly.  (p. 53)
  7. ___ up a database is the process of making a copy of the database file to protect your database against loss or damage.  (p. 40)
  8. Avoid data ___, which occurs when you store the same data in more than one place.  (p. 47)
  9. The field data ___ determines what field values can be entered into a field.  For example, Text, Number, Data Time, etc.  (p. 54-55)
  10. For each of the following description give the name of the Access data type.  (p. 55)
    1. ___ :  Allows positive and negative numbers
    2. ___ :  Limits response to yes or no.
    3. ___ :  Consists of integer values created automatically by Access
    4. ___ :  Allows field values containing letters, digits, spaces, and special characters.
    5. ___ :  Allows monetary values to be stored.
    6. ___ :  Allows field values contains valid dates and times.
  11. The key symbol placed in front of a field in the Table definition window, identifies the ___ key field.  (p. 67)
  12. A ___ -to-many relationship exists between two tables when one record in the first table (called the primary table) matches zero, one, or many records in the second table (called the foreign table).  (p. 92)
  13. ___ integrity is the constraint specifying that each nonnull foreign key value must match a primary key value in the primary table.  (p. 93  /  A11)
  14. The cascade ___ option allows Access to automatically change any matched foreign key (in the foreign table) whenever the value of the primary key field (in the primary table) is changed.  (p. 93)
  15. The cascade ___ option allows Access to automatically delete any matched records in the foreign table whenever the matched record in the primary table is deleted.  (p. 93)
  16. When creating a relationship between two tables, the relationship diagram shows a line between the primary and foreign keys.  When referential integrity is included a one-to-many relationship is created between these two tables.  On the diagram, the "one" side of the relationship is represented by the digit ___, and the "many" side of the relationship is represented by the ___ symbol.  (p. 96)

 

Chapter 3
and
Chapter 5

Copy the following questions and paste into a new Word document.  Save as CIS320Chap0305Username.  Read and study Chapters (Tutorials) 3 and 5.  Answer the questions using red text.  Submit the file to Moodle on or before the due date/time listed on the syllabus.

  1. A ___ is a question you ask about data stored in a database.  (p. 104)
  2. Most questions about data are generalized queries in which you specify the fields and records you want Access to select.  This type of query is called a ___ query.  The results of this type of query is called a ___.  (p. 116)
  3. ___ is the process of rearranging records in a specified order or sequence.  (p. 123)
  4. Indicate whether the sort is ascending or descending.  (p. 123)
    1. ___ :  A to Z
    2. ___ :  Z to A
    3. ___ :  highest to lowest value
    4. ___ :  lowest to highest value
    5. ___ :  most recent to oldest date
    6. ___ :  oldest to most recent date
  5. When you have non-unique data in a sort field, you might want to use a ___ sort field to further sort the data.  For example, when two people have the same last name, you might want to sort by the person's first name.  (p. 124)
  6. A ___ is a set of restrictions you place on the records in an open datasheet to temporarily isolate a subset of the records.  (p. 127)
  7. Identify the symbol used in each of the following.  (p. 139)
    1. ___ :  In a query condition, what symbol placed around a text phrase?
    2. ___ :  In a query condition, what symbol placed around an actual date?
    3. ___ :  In a query condition, what symbol is the Like operator wild card symbol?
    4. ___ :  In a query condition, what symbol for "equal to?"
    5. ___ :  In a query condition, what symbol for "not equal to?"
    6. ___ :  In a query condition, what symbol for "less than?"
    7. ___ :  In a query condition, what symbol for "less than or equal to?"
    8. ___ :  In a query condition, what symbol for "greater than?"
    9. ___ :  In a query condition, what symbol for "greater than or equal to?"
  8. The ___ logical operator requires both conditions to be true.  (p. 142)
  9. The ___ logical operator requires at least one of the two conditions to be true.  (p. 143)
  10. A ___ field is a query field that displays the results of an expression - typically a numerical calculation.  These values only exists while the query is open.  These values are not permanently stored in a table.  (p. 145-146)
  11. A ___ match selects records with a value for the designated field that matches the pattern of the simple condition value.  The ___ comparison operator is used.   ___ is the wild card symbol for one or more characters, ___ is the wildcard symbol for a single character, and ___ is the wildcard symbol for a single digit.  (p. 221)
  12. A ___ query displays a dialog box that prompts the user to enter one or more criteria values when the query is run.  (p. 233)
  13. A ___ query performs aggregate function calculations (sum, average, count, etc.) on groups of values and displays the results in a spreadsheet format.  (p. 240)
  14. Find ___ query searches for duplicate values based on the fields you select.  (p. 246)
  15. Find ___ query is a select query that finds all records in a table or query that have no related records in a second table or query.  (p. 247)
  16. Data ___ rules verifies a field value.  It verifies that the value is reasonable - not that it is correct.  (p. 264)

 

Chapter 4A
and
Chapter 6
 

Copy the following questions and paste into a new Word document.  Save as CIS320Chap04A06Username.  Read and study Chapters (Tutorials) 4A and 6.  Answer the questions using red text.  Submit the file to Moodle on or before the due date/time listed on the syllabus.

  1. A ___ is an object you use to enter, edit, and view records in a database.  (p. 168)
  2. Typically, a form design is broken down into three different sections.  (diagram on p. 330)
    1. ___ :  The section of the form design in which objects are placed if you want these objects to appear at the top of the form.
    2. ___ :  The section of the form design in which objects are placed if you want these objects to appear in the body of the form - items that appear for each record.
    3. ___ :  The section of the form design in which objects are placed if you want these objects to appear at the bottom of the form.
  3. A ___ is a form object that allows the user to place text on the form.
  4. A ___ is a form object that is used to create a calculated field.
  5. In the design view mode of a form, open the properties window.  Select a data field box from the Detail section.  On the properties window, what property name is used for each of the following properties:
    1. ___ :  text color
    2. ___ :  background color
    3. ___ :  prevents or allows the user to change the contents of the textbox or field.
    4. ___ :  the order of the fields and textboxes when the user tabs through the form.
Chapter 4B
and
Chapter 7

Copy the following questions and paste into a new Word document.  Save as CIS320Chap04B07Username.  Read and study Chapters (Tutorials) 4B and 7.  Answer the questions using red text.  Submit the file to Moodle on or before the due date/time listed on the syllabus.

  1. A ___ is a formatted printout of the contents of one or more tables or queries.  (p. 188)
  2. Typically, a report design is broken down into 5 (no grouping) or 7 sections (with grouping).  (diagram on page 385 shows the report being grouped by InvoiceItem)
    1. ___ :  The section of the form design in which objects are placed if you want these object to appear at the top of the report.
    2. ___ :  The section of the form design in which objects (dates and page numbers - fields are not permitted) are placed if you want these objects to appear at the top of each page.
    3. ___ :  The section of the form design in which objects are placed if you want these objects to appear at the top of each group.
    4. ___ :  The section of the report design in which objects are placed if you want these objects to appear in the body of the form - items that appear for each record.
    5. ___ :  The section of the form design in which objects (often aggregate calculations, such as sums, averages or counts for each group) are placed if you want these objects to appear at the bottom of each group.
    6. ___ :  The section of the form design in which objects (dates and page numbers - fields are not permitted) to appear at the bottom of each page.
    7. ___ :  The section of the form design in which objects (often aggregate calculations, such as sums, averages or counts for the entire report) are placed if you want these objects to appear at the bottom of the report.
  3. Mailing ___ are small, self-adhesive sheets of paper that are placed on envelops and packages.  (p. 403)
  4. Answer the following questions based on the diagrams on pages 404-406.
    1. The created mailing label is designed for a label manufactured by ___
    2. The label is ___ " tall by ___ " wide.
    3. There are ___ labels across the sheet.
    4. What is printed on line 1?  ___
    5. What is printed on line 2?  ___
    6. What is printed on line 3?  ___
    7. What is printed on line 4?  ___
Chapter 10

 

Copy the following questions and paste into a new Word document.  Save as CIS320Chap10Username.  Read and study Chapter (Tutorial) 10.  Answer the questions using red text.  Submit the file to Moodle on or before the due date/time listed on the syllabus.

  1. A ___ is a form that appears when you open a database and that provides controlled access to the database's forms, reports and queries. 
  2. A ___ is an action, or a set of actions, that you want Access to perform automatically for you.  (p. 522)
Chapter 12 Copy the following questions and paste into a new Word document.  Save as CIS320Chap12Username.  Read and study Chapter (Tutorial) 12.  Answer the questions using red text.  Submit the file to Moodle on or before the due date/time listed on the syllabus.
  1. The ___ Analyzer is an Access tool that you can use to optimize the performance of an Access database.  (p. 639)
  2. A ___ table is a table that is stored in a file outside the open database and that can be updated from the open database.  (p. 642)
  3. When splitting a database, the file containing the tables is called the ___ database and the file that contains the other objects, including the user interface, is called the ___ database.  (p. 647)
  4. ___ refers to the protection of a database against unauthorized access, either intentional or accidental.  (p. 651)
  5. ___ translates the data in a database to a scrambled format that's indecipherable to a word processor or other program and stores it in an encrypted format.  (p. 651)
  6. ___ a database reverses the encryption.  (p. 651)
  7. ___ options, are certain actions that take place when a database is opened.  p. 654)