13.18: Putting It Together- Microsoft Access Intermediate Skills

Last updated
Save as PDF

Page ID: 46648

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

In this section we spent a great deal of time learning how to work with Access datasheets: adding and deleting data, displaying data, sorting and filtering data, aggregating data, and previewing and printing records. This is important as an MS Access user will spend a good deal of time taking advantage of the ease-of-use of this view to get work done.

More broadly, we dove in to some important database principles and how database technology can be applied to create useful commercial applications. The fact that multiple users can consume information—even utilize different views at the same time—from a database application is of tremendous value. Database applications as simple as generating mailing lists to as complex as airline reservations rely on the database principles we discussed.

Contributors and Attributions

Putting It Together: Microsoft Access Intermediate Skills. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution