Computer E-Learning

Welcome to the Access 2013 Advanced workshop. This course will teach you how to customize your apps, as well as help you become an advanced user of desktop databases. Sit back, relax, and have fun. You are in for a thrilling ride!

Views are designed for Access 2013 apps to help you find your data fast. In this module, you’ll learn how to add your own view. You’ll also learn how to rename the view and duplicate an existing view. This module explains how to add a popup view so that you can access that view from a field with some types of controls. Finally, we’ll look at how to delete a view you no longer need.

In this module, we’ll look at editing your tables to modify the action bar and moving, resizing, or deleting controls from your forms. We’ll also take a look at the Info tab on the Backstage View for information about your database.

This module takes a closer look at controls. You can add unbound or bound controls, either from the Ribbon or from the Field List that is available when you are editing a table. You can also modify the control properties, which is especially useful if you want to change an unbound control to a bound one that updates the underlying table.

This module shows you how to use additional tools for getting your datasheet looking like you want. First, you’ll learn how to adjust row height and column width in your datasheet. You’ll also learn how to hide/unhide and freeze/unfreeze fields. Finally, this module looks at the connection with Outlook, which allows you to add contacts from Outlook or save a record as an Outlook Contact.

We’ll learn some additional tools for working with your data in this module. First, we’ll learn how to show a totals row in your datasheet. You’ll learn how to require fields and how to require that fields contain unique information. You’ll also learn about indexing fields. Finally, we’ll look at adding fields that are based on lookup tables and relationships.

This module will introduce you to the Design view for tables. You’ll learn how to work with the field properties and the primary key. You’ll also learn how to use the Properties Sheet.

This module focuses on the Expression Builder, and ways that you can use it to improve your database. We’ll start by looking at setting the default value for a field, both in design view and in datasheet view. Then we’ll take a closer look at the Expression builder to create formulas for all different types of uses in Access. Finally, we’ll create calculated value fields.

This module helps you understand how to work with external data. We’ll use Excel for our examples. We’ll start with linking data, which keeps your data updated in Access, allowing you to use the query and reporting tools, but does not allow you to make changes to the data in Excel. Then we’ll look at importing data, which allows you to make changes to the data, but does not provide any updates if changes are made in Excel. Finally, we’ll shift to exporting data.

In this module, you’ll learn how to create queries without using the Wizard. We’ll start with the select query. You’ll also learn how to create a make table query, an append query, and a cross tab query. You’ll also learn how to modify the tables included in your queries by using the Show or Remove tables commands.

In this module, you’ll start creating forms and reports. First, you’ll use the form wizard to create a form. You’ll also use the report wizard to create a report. Then you’ll look at the tools available in both the form layout view and the report layout view.

Although this workshop is coming to a close, we hope that your journey to improve your Advanced Access skills is just beginning. Please take a moment to review and update your action plan. This will be a key tool to guide your progress in the days, weeks, months, and years to come. We wish you the best of luck on the rest of your travels!