Section 508 Website Accessibility

Skip to site navigation Skip to main content
Skip to main content
Technology Skills Orientation

Technology Skills Orientation

Access 2016 Tutorial

 
 

Getting Started

  • File Menu Tab
  • The Ribbon
  • Quick Access Toolbar

Customize

  • Options
  • General
  • Current Database
  • Datasheet
  • Object Designers
  • Proofing
  • Client Settings
  • Customize

Database Terms

  • Table
  • Query
  • Recordset
  • Form
  • Report

Creating a New Database

  • New Database
  • Database Templates

Create a Table

  • Table Views
  • Adding New Fields
  • Data Types
  • Editing Data Types in Fields

Keys

  • Primary Key
  • Composite Key
  • Foreign Key

 

Table Relationships

  • One-to-One Relationship
  • One-to-Many Relationship
  • Creating a Table Relationship
  • Print a Table Relationship Report

Managing Data

  • Add Records to a Table
  • Find and Replace
  • Totals
  • Sort Records
  • Filter

Querying a Database

  • Query Wizard
  • Query Design Feature
  • Query Criteria

Calculated Fields

  • Expressions
  • Zoom

Designing Forms

  • Form Views
  • Create a Form
  • Form Wizard

Generating Reports

  • Report Views
  • Create a Report
  • Report Wizard
  • Custom Calculated Fields

Print a Report

  • Print a Report

 

 

Office 2013 Tutorials · Word · Excel · PowerPoint · Access

FGCU only provides support for Office 2013 to FGCU students, faculty, and staff.