Office Basics

• 1

  Buying Office ✓

  If you're thinking about buying Office 2013, there are a few things you should consider before your purchase.

• 2

  Understanding Office 365 ✓

  Learn what you need to know about Office 365, a subscription-based version of Office 2013.

Access Basics

• 3

  Introduction to Databases ✓

  Learn all about an Access database and how it works.

• 4

  Introduction to Objects ✓

  Learn about each of the four objects in Access to understand how they interact with each other to create a fully functional relational database.

• 5

  Getting Started with Access ✓

  Familiarize yourself with the Access environment, including the Ribbon, Backstage view, Navigation pane, Document Tabs bar, and Record Navigation bar.

• 6

  Managing Databases and Objects ✓

  Learn how to open and close an Access database, as well as how to open, close, and save objects.

Working with Data

• 7

  Working with Tables ✓

  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.

• 8

  Working with Forms ✓

  Learn how to use forms to enter new records and view and edit existing ones.

• 9

  Sorting and Filtering Records ✓

  Learn how to sort and filter data so you can customize how you organize and view your data.

Running Queries and Reports

• 10

  Designing a Simple Query ✓

  Learn how to create a simple one-table query.

• 11

  Designing a Multi-Table Query ✓

  Learn how to design and create a multi-table query.

• 12

  More Query Design Options ✓

  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.

• 13

  Creating Reports ✓

  Learn learn how to create, modify, and print reports.

• 14

  Advanced Report Options ✓

  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

• 15

  Modifying Tables ✓

  Learn how to create and rearrange table fields, as well as set validation rules, character limits, and data types.

• 16

  Creating Forms ✓

  Learn how to create and modify forms using options like design controls and form properties.

• 17

  Formatting Forms ✓

  Learn how to add command buttons, modify form layouts, add logos and other images, and change form colors and fonts.

• 18

  Designing Your Own Database ✓

  Learn how to create a database from an existing template and find resources to learn more about database design.

More Access Tasks

• 19

  Creating Calculated Fields and Totals Rows ✓

  Learn how to create calculated fields and totals rows.

• 20

  Creating a Parameter Query ✓

  Learn how to run an Access parameter query to find the data you need using variable criteria in your search terms.

• 21

  Creating a Find Duplicates Query ✓

  Learn how to run an Access duplicates query to erase duplicates and strengthen your database.

Extras

• 22

  Query Criteria Quick Reference Guide ✓

  Use this quick reference guide for 20 of the most common criteria used in Access queries.

• 23

  4 Free Alternatives to Microsoft Office ✓

  Learn more about free alternatives to using Microsoft Office, including Google Docs, Office Online, OpenOffice, and LibreOffice.