14.22: Discussion- Ways to Manage Access Tables

Last updated
Save as PDF

Page ID: 46672

\( \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: pb.libretexts.org/cafm/?p=608

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

Discussion: Ways to Manage Access Tables. Authored by: Sherri Pendleton. Provided by: Lumen Learning. License: CC BY: Attribution