Skip to main content
Workforce LibreTexts

13.9: Chapter Review - Review Questions

  • Page ID
    32849
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)

    \( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)

    ( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)

    \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)

    \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)

    \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)

    \( \newcommand{\Span}{\mathrm{span}}\)

    \( \newcommand{\id}{\mathrm{id}}\)

    \( \newcommand{\Span}{\mathrm{span}}\)

    \( \newcommand{\kernel}{\mathrm{null}\,}\)

    \( \newcommand{\range}{\mathrm{range}\,}\)

    \( \newcommand{\RealPart}{\mathrm{Re}}\)

    \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)

    \( \newcommand{\Argument}{\mathrm{Arg}}\)

    \( \newcommand{\norm}[1]{\| #1 \|}\)

    \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)

    \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    \( \newcommand{\vectorA}[1]{\vec{#1}}      % arrow\)

    \( \newcommand{\vectorAt}[1]{\vec{\text{#1}}}      % arrow\)

    \( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vectorC}[1]{\textbf{#1}} \)

    \( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)

    \( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)

    \( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)

    \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)

    \(\newcommand{\avec}{\mathbf a}\) \(\newcommand{\bvec}{\mathbf b}\) \(\newcommand{\cvec}{\mathbf c}\) \(\newcommand{\dvec}{\mathbf d}\) \(\newcommand{\dtil}{\widetilde{\mathbf d}}\) \(\newcommand{\evec}{\mathbf e}\) \(\newcommand{\fvec}{\mathbf f}\) \(\newcommand{\nvec}{\mathbf n}\) \(\newcommand{\pvec}{\mathbf p}\) \(\newcommand{\qvec}{\mathbf q}\) \(\newcommand{\svec}{\mathbf s}\) \(\newcommand{\tvec}{\mathbf t}\) \(\newcommand{\uvec}{\mathbf u}\) \(\newcommand{\vvec}{\mathbf v}\) \(\newcommand{\wvec}{\mathbf w}\) \(\newcommand{\xvec}{\mathbf x}\) \(\newcommand{\yvec}{\mathbf y}\) \(\newcommand{\zvec}{\mathbf z}\) \(\newcommand{\rvec}{\mathbf r}\) \(\newcommand{\mvec}{\mathbf m}\) \(\newcommand{\zerovec}{\mathbf 0}\) \(\newcommand{\onevec}{\mathbf 1}\) \(\newcommand{\real}{\mathbb R}\) \(\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}\) \(\newcommand{\laspan}[1]{\text{Span}\{#1\}}\) \(\newcommand{\bcal}{\cal B}\) \(\newcommand{\ccal}{\cal C}\) \(\newcommand{\scal}{\cal S}\) \(\newcommand{\wcal}{\cal W}\) \(\newcommand{\ecal}{\cal E}\) \(\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}\) \(\newcommand{\gray}[1]{\color{gray}{#1}}\) \(\newcommand{\lgray}[1]{\color{lightgray}{#1}}\) \(\newcommand{\rank}{\operatorname{rank}}\) \(\newcommand{\row}{\text{Row}}\) \(\newcommand{\col}{\text{Col}}\) \(\renewcommand{\row}{\text{Row}}\) \(\newcommand{\nul}{\text{Nul}}\) \(\newcommand{\var}{\text{Var}}\) \(\newcommand{\corr}{\text{corr}}\) \(\newcommand{\len}[1]{\left|#1\right|}\) \(\newcommand{\bbar}{\overline{\bvec}}\) \(\newcommand{\bhat}{\widehat{\bvec}}\) \(\newcommand{\bperp}{\bvec^\perp}\) \(\newcommand{\xhat}{\widehat{\xvec}}\) \(\newcommand{\vhat}{\widehat{\vvec}}\) \(\newcommand{\uhat}{\widehat{\uvec}}\) \(\newcommand{\what}{\widehat{\wvec}}\) \(\newcommand{\Sighat}{\widehat{\Sigma}}\) \(\newcommand{\lt}{<}\) \(\newcommand{\gt}{>}\) \(\newcommand{\amp}{&}\) \(\definecolor{fillinmathshade}{gray}{0.9}\)

    Review Questions

    1 .
    Data must be ___________ to be useful for digital transformation.
    1. unorganized
    2. inaccessible
    3. actionable
    4. live
    2 .
    The most common type of database used to power transactional systems is __________.
    1. NoSQL
    2. RDBMS
    3. SQL
    4. analytical database
    3 .
    ________ link objects together.
    1. Relationships
    2. Flat files
    3. Joins
    4. Queries
    4 .
    Which database system should be used for testing and experimentation?
    1. production database
    2. development database
    3. transactional database
    4. relational database
    5 .
    Which object in Access stores data for use?
    1. report
    2. query
    3. table
    4. form
    6 .
    When would you use Access instead of Excel?
    1. to store data in multiple tables
    2. to perform complex numerical analysis
    3. to create visualizations
    4. to create a pivot table
    7 .
    How many databases can be open in Access at one time?
    1. one
    2. two
    3. three
    4. four
    8 .
    Queries are used in databases to __________.
    1. access and prepare records
    2. raise questions in business discussions
    3. manage simple datasets
    4. write questions for presentations
    9 .
    In a(n) ______ join, the common fields and data between the two tables are looked at and only displays the matches.
    1. QBE
    2. outer
    3. foreign key field
    4. inner
    10 .
    The parts of an Access query include __________.
    1. field names and criteria only
    2. table names, field names, and other detail
    3. table names, field names, and sort order
    4. criteria and sort questions only
    11 .
    When would you navigate through a database using the navigation buttons on the datasheet?
    1. when you have many records to look at
    2. when you want to see thousands of records at a glance
    3. when you do not want to take the time to create a query
    4. when you are looking at a small set of records (e.g., from a query)
    12 .
    Which statement best explains the process of manually adding a record to a database?
    1. You never add a record manually to a database because this is not a function in Access.
    2. You are unlikely to add a record manually but can do so when necessary.
    3. You are likely to add records to ensure that the database matches the production database.
    4. You will scan records but will not manually input them to update the production database.
    13 .
    What is the keyboard shortcut to save a record manually?
    1. Ctrl+Enter
    2. Shift+Enter
    3. Ctrl+S
    4. There is no shortcut, you have to use the Home tab.
    14 .
    Why should you use reports when working with a database?
    1. because data is confusing
    2. because data is ugly
    3. because reports are attractive
    4. because reports provide data in a more usable form
    15 .
    If you want an image to show up at the top of each page of the report, where do you put it?
    1. detail section
    2. in the page header
    3. in the footer
    4. in the report header
    16 .
    Reports in Access are best used to summarize what type of information?
    1. record detail
    2. header code
    3. total code
    4. summary header
    17 .
    Which tab may not be available unless you select multiple items in the form?
    1. Form Design
    2. Format
    3. Arrange
    4. Create
    18 .
    What tool provides an efficient way to create a form?
    1. Form Wizard
    2. Form Code
    3. Form Grid
    4. Form SQL
    19 .
    Forms can be created based on __________.
    1. reports or other forms
    2. tables or queries
    3. tables or reports
    4. queries or other forms

    This page titled 13.9: Chapter Review - Review Questions is shared under a CC BY 4.0 license and was authored, remixed, and/or curated by OpenStax via source content that was edited to the style and standards of the LibreTexts platform.