Microsoft Access

Access 2016: Level 1 – Access Basics & Database Fundamentals (3.0 hr)

Microsoft Access is a relational database application. This is the perfect tool when you begin to outgrow your data collection in Excel. With Access, you can obtain better collection results by creating user-friendly forms with rules to protect the validity of your data. You can create queries to analyze and filter your data, and reports that can be regenerated anytime you need them.

Topics for this workshop include database concepts, planning a database, and a hands-on introduction to tables, queries, forms and reports. This workshop assumes you are comfortable with a computer and have some knowledge of other Microsoft Office programs.

Gainesville Schedule Jacksonville Schedule Handout
Presentation


Access 2016: Level 2 – Import/Link and Export
(1.5 hr)

In this workshop, we will import and link Excel worksheets and Access tables into a new Access database. Topics include ‘cleaning’ the Excel data; linking to Excel; importing from Excel; handling import errors; exporting tables and queries to Excel; linking to tables in another Access database; importing database objects, such as queries, from another Access database; and working with Saved Import/Exports.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)

 

Access 2016: Level 2 – Intro to Forms & Reports (2.0 hr)

Topics include using the AutoForm/AutoReport tool, and the Form and Report Wizards. Creating forms and reports in the design view – including: using the property sheet; field placement, sizing, aligning, and formatting; simple command buttons; working with multiple sections on a report; stacked and tabular tables; sorting reports; and creating mailing labels. Completion of “Access: Basics” highly recommended.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)

 

Access 2016: Level 2 – Intro to Select Queries (2.0 hr)

Queries compile data from tables into a desired dataset. You can choose multiple fields from one or more data tables, and set criteria to limit the records displayed. By its simplest definition, a query is a saved filter, but they can also be used to combine fields, preform calculations, and create summaries.

Topics for this workshop include using data filters, setting custom sorts, using criteria, creating joined field expressions, calculating simple math, summarizing with totals, formatting numbers, and creating crosstabs. This workshop highly recommends completion of “Access: Basics”.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)