13.1: Reading- Access Training

Last updated
Save as PDF

Page ID: 18692

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

Required Trainings

Read, view, and complete the following tutorials at GCF LearnFree.org, (http://www.gcflearnfree.org/access2013).

Access Basics

#3 – INTRODUCTION TO DATABASES
#4 – INTRODUCTION TO OBJECTS
#5 – GETTING STARTED WITH ACCESS
#6 – MANAGING DATABASES AND OBJECTS

Working with Data

#7 – WORKING WITH TABLES
#8 – WORKING WITH FORMS
#9 – SORTING AND FILTERING RECORDS

Running Queries and reports

#10- DESIGNING A SIMPLE QUERY
#11- DESIGNING A MULTI-TABLE QUERY
#12- MORE QUERY DESIGN OPTIONS
#13- CREATING REPORTS
#14- ADVANCED REPORT OPTIONS

Database Design Tips

#15- MODIFYING TABLES
#16- CREATING FORMS
#17- FORMATTING FORMS
#18 – DESIGNING YOUR OWN DATABASE

More Access Tasks

#19 – CREATING CALCULATED FIELDS AND TOTALS ROWS
#20 – CREATING A PARAMETER QUERY
#21 – CREATING A FIND DUPLICATES QUERY

Optional Additional Tutorials are available from GCF Learnfree.org under EXTRAS.

Supplemental Trainings

You can find the following supplemental training by clicking the MS Office Tutorials link in the course menu.

Atomic Learning – Use these videos to supplement your GCF Learn Free Tutorials as necessary.
MS Office Tutorials – Watch the Access tutorials in MS Office 2013 Video Tutorials link or the MS Office 2010 Tutorials link.
Access Help Menu – Additional learning materials are also available from the Access HELP menu. Click on the BLUE QUESTION MARK in the upper right hand corner of your application HOME page. This will take you to the Access Help page where you will find tutorials and a searchable index of topics.

Introduction to Computer Applications and Concepts. Authored by: Jim Shannon. Provided by: Extended Learning Institute of Northern Virginia Community College. Located at: http://www.nvcc.edu/eli/index.html. License: CC BY: Attribution