Skip to main content
Workforce LibreTexts

14.9: Chapter Review - Review Questions

  • Page ID
    32863
  • \( \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 .
    You need to review a database and identify orders placed by a specific customer for more than $50. What type of criteria should you use for this Access query?
    1. wildcards
    2. simple criteria
    3. logical operators
    4. null criteria
    2 .
    What kind of action query would you use to make global changes to a group of records in a table that needs updating?
    1. Action query
    2. Update query
    3. Crosstab query
    4. Delete query
    3 .
    ________ let you carry out calculations on record groups rather than performing individual operations.
    1. Append queries
    2. Update queries
    3. Aggregate queries
    4. Delete queries
    4 .
    What can help build and ensure a relationship between two tables?
    1. Dropdown Wizard
    2. Lookup Wizard
    3. Table Wizard
    4. Microsoft Wizard
    5 .
    What kind of form is inserted into another form (known as the primary form)?
    1. query form
    2. auto-form
    3. subform
    4. drop-down form
    6 .
    The most visually intuitive view to use for form modification is ________.
    1. Design View
    2. Print View
    3. Layout View
    4. Form View
    7 .
    Which feature helps the developer control which section of the form the curser moves to next?
    1. Report Wizard
    2. tab order
    3. property sheet
    4. Field list
    8 .
    Some customers may find that predefined options on a form do not meet their needs. Which control provides customers with the option of entering a new value on a form?
    1. Text Box
    2. Command
    3. Combo Box
    4. Tab order
    9 .
    Which section of a report do you use for information that might normally appear on a cover page, such as a logo, title, or date?
    1. Report Header
    2. Page Header
    3. Group Header
    4. Page Footer
    10 .
    What is the primary purpose of grouping and sorting in Access reports?
    1. to display the report title and general information clearly
    2. to organize data into sections such as Report Header and Footer
    3. to help users quickly identify patterns and trends in the data
    4. to format the report with different font styles and colors
    11 .
    In Access, which view should you use to review a report and see how it will look when you run it?
    1. Design View
    2. Layout View
    3. Form View
    4. Print Preview
    12 .
    What is a macro in the context of Access?
    1. a type of database table used to store user data
    2. a graphical representation of a database schema
    3. a set of instructions for automating tasks or performing operations
    4. a programming language used for creating web applications
    13 .
    How does recording a macro in Access help enhance database functions?
    1. It creates queries with multiple criteria.
    2. It enables the building of queries that aggregate.
    3. It optimizes the Form Wizard to allow users to build a custom form.
    4. It creates a system to accomplish similar operations easily and efficiently.
    14 .
    How can Visual Basic for Applications (VBA) enhance the capabilities of Access for developers?
    1. by providing advanced graphic design tools for creating visually appealing forms
    2. by automatically generating complex SQL queries for data analysis
    3. by offering integration with external databases and servers
    4. by allowing developers to automate tasks, create custom interfaces, analyze data, integrate with other applications, and generate custom reports
    15 .
    When you import data into Access from an external source, what happens to the source data?
    1. Importing data always alters the source data.
    2. Importing data is not as flexible as copying and pasting.
    3. Importing data allows you to modify the structure of linked tables that contain the source data.
    4. Importing data creates a copy of the data in the destination database without altering the source data.
    16 .
    When you export data from Access to Excel, what does the Export Wizard do?
    1. Exporting data from Access to Excel is a manual process that requires copying and pasting.
    2. The Export Wizard in Access allows you to import data from Excel to Access databases.
    3. Access creates a link between the data in Access and Excel when exporting data.
    4. The Export Wizard allows you to save the export routine for future use and automate the export operation.
    17 .
    Which type of dashboard is focused on tracking short-term operational processes and metrics?
    1. strategic dashboard
    2. analytical dashboard
    3. operational dashboard
    4. tactical dashboard

    This page titled 14.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.