Skip to main content
Business LibreTexts

14.22: Discussion- Ways to Manage Access Tables

  • Page ID
  • \( \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}}\)

    Now you have some experience with what you can do in Access. If you have seen an Access file that contained several tables and many saved queries it may seem a bit overwhelming. What are a few ways to help manage the queries and tables as they begin to accumulate?

    While the video shows an older version of Access (MicrosoftAccess 2016), the same solutions work in other versions ofAccess, including 2019 and 365.

    Watch the video about tips for managing Access tables and ask yourself a few questions and discuss your answers to them.

    Thumbnail for the embedded element "Access 2016: Tips For Managing Tables"

    A YouTube element has been excluded from this version of the text. You can view it online here:

    You can view the transcript for “Tips for Managing Tables” here (opens in new window).

    Discussion Questions

    • Do you think you will use the hide a table tool to keep the view manageable? If so, when and why?
    • Which of the different ways to rearrange tables and queries do you prefer? Why?
    • Would you use these tips if you had only a few tables or not? Why?

    Share your opinions below and respond to two of your classmates’ thoughts.

    Contributors and Attributions

    CC licensed content, Original
    • Discussion: Ways to Manage Access Tables. Authored by: Sherri Pendleton. Provided by: Lumen Learning. License: CC BY: Attribution
    All rights reserved content
    • Access 2016: Tips For Managing Tables. Authored by: Kirt Kershaw. Located at: License: All Rights Reserved. License Terms: Standard YouTube License

    14.22: Discussion- Ways to Manage Access Tables is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?