Access 2016

Access Basics

• 1

  Introduction to Databases arrow_forward_ios ✓ Learn all about an Access database and how it works.
• 2

  Introduction to Objects arrow_forward_ios ✓ Learn about each of the four objects in Access to understand how they interact with each other to create a fully functional relational database.
• 3

  Getting Started in Access arrow_forward_ios ✓ Familiarize yourself with the Access environment, including the Ribbon, Backstage view, Navigation pane, Document Tabs bar, and Record Navigation bar.
• 4

  Managing Databases and Objects arrow_forward_ios ✓ Learn how to to open and close an Access database, as well as how to open, close, and save objects.

Working with Data

• 5

  Working with Tables arrow_forward_ios ✓ Learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with.
• 6

  Working with Forms arrow_forward_ios ✓ Learn how to use forms to enter new records and view and edit existing ones.
• 7

  Sorting and Filtering Records arrow_forward_ios ✓ Learn how to sort and filter data so you can customize how you organize and view your data.

Running Queries and Reports

• 8

  Designing a Simple Query arrow_forward_ios ✓ Learn how to create a simple one-table query in Access.
• 9

  Designing a Multi-table Query arrow_forward_ios ✓ Learn how to create a complex multi-table query in Access.
• 10

  More Query Design Options arrow_forward_ios ✓ Learn how to modify and sort queries, as well as how to use the Totals function to create a query that can perform calculations with your data.
• 11

  Creating Reports arrow_forward_ios ✓ Learn learn how to create, modify, and print reports.
• 12

  Advanced Report Options arrow_forward_ios ✓ Learn how to use the Report Wizard to create complex reports and use Access formatting options to change the look of your report.

Database Design Tips

• 13

  Modifying Tables arrow_forward_ios ✓ Learn how to create and rearrange table fields, as well as set validation rules, character limits, and data types.
• 14

  Creating Forms arrow_forward_ios ✓ Learn how to create and modify forms using options like design controls and form properties.
• 15

  Formatting Forms arrow_forward_ios ✓ Learn how to add command buttons, modify form layouts, add logos and other images, and change form colors and fonts.
• 16

  Designing Your Own Database arrow_forward_ios ✓ Learn how to create a database from an existing template and find resources to learn more about database design.

More Access Tasks

• 17

  How to Create Calculated Fields and Totals Rows arrow_forward_ios ✓ Learn how to create calculated fields and totals rows.
• 18

  Creating a Parameter Query arrow_forward_ios ✓ Learn how to run an Access parameter query to find the data you need using variable criteria in your search terms.
• 19

  How to Create a Find Duplicates Query arrow_forward_ios ✓ Learn how to run an Access duplicates query to erase duplicates and strengthen your database.

Extras

• 20

  Query Criteria Quick Reference Guide arrow_forward_ios ✓ Use this quick reference guide for 20 of the most common criteria used in Access queries.
• 21

  Buying Office 2016 arrow_forward_ios ✓ If you're considering purchasing Office 2016, learn about some important changes you should know about.

Quiz

• 22

  Access Quiz arrow_forward_ios ✓ Test your knowledge of Access by taking our quiz.