Learn your way! Get started

Access 2013, Part 3: Navigation, View and Keys

with expert John Wiley & Sons

Watch trailer

Access 2013, Part 3: Navigation, View and Keys Trailer

Course at a glance

Included in these subscriptions:

  • Creative Design Power Pack
  • Power Pack Plus

Release date Release date 3/16/2015
Level Level Beginner
Runtime Runtime 1h 17m
Published eBooks Published eBooks Included
Hands-on labs Hands-on labs N/A
Sample files Sample files N/A
Exams Exams N/A

Enterprise Solutions
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

In this eight parts leaning series you’ll see how Access 2013 is Microsoft’s database management software that allows users to enter, manage, and build reports on large amounts of data. Get to know the Access work environment, master tables, Data Fields, and Data Types; understand queries and create a simple select query; build a simple UI with forms; and learn how to create simple reports. Advanced topics include automating tasks with macros and Importing, linking, and exporting external data.


This course assumes very little familiarity with Microsoft Access. This course is part of 8 courses; Access 2013: UI, Tables and Forms; Access 2013: Queries, Reports and Data; Access 2013: Navigation, View and Keys; Access 2013: Masks, Lookup and Queries; Access 2013: Groups, Joins and Action; Access 2013: Queries and Forms; Access 2013: Forms and Reports; and Access 2013: Reports, Macros and Importing. Please be sure to view the courses in order if you are new to the material.

Meet the expert

John Wiley & Sons Our Creative Design courses are presented by experts from Wiley Publishing. Wiley is a global provider of knowledge and knowledge-enabled services that improve outcomes in areas of research, professional practice, and education. They are the publisher of award-winning journals, encyclopedias, books, and online products and services.

Course outline

Navigation, View and Keys

Data Entry and Navigation (27:34)
  • Introduction (00:10)
  • Data Entry into a Table (04:22)
  • Moving From Cell to Cell (04:27)
  • Cut, Copy, & Paste (05:02)
  • Navigate the Datasheet View (04:18)
  • Sorting & Filtering (03:04)
  • Find & Replace (02:14)
  • The Navigation Tool (03:44)
  • Summary (00:10)
Sort-Filter and Design View (26:47)
  • Introduction (00:10)
  • More Sorting & Filtering (03:46)
  • Apply Filter & Sort Query (02:38)
  • The Totals Tool (02:59)
  • Tables Design View (03:43)
  • Data Type Properties (04:40)
  • Numbers & Data-Time (02:53)
  • Lookup (03:06)
  • Property Sheet (02:38)
  • Summary (00:10)
Primary Keys and Relationships (23:24)
  • Introduction (00:10)
  • The Primary Key (03:44)
  • Create Table Design (04:13)
  • Lookup Relationship (03:58)
  • Relationships Map (02:27)
  • Cascading Delete (03:23)
  • Create via Drag & Drop (05:17)
  • Summary (00:10)