Access 2013 Advanced

This course is designed to teach you a deeper understanding of Access 2013 in a practical way. The participants will learn how to use the advance features of Access to help them better manage a database. This course incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.

This course is meant to provide a safe learning environment where they can practice and learn Access 2013 Advanced functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to learn the advanced features of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology.

Course Outline

Module One: Getting Started

Module Two: Using App Views

• Understanding Views
• Adding a New View
• Editing a View
• Deleting a View
• Adding a Popup View
• Module Two: Review Questions

Module Three: Customizing Apps (I)

• Checking Your Database Name or Server Location
• Modifying the Action Bar
• Opening a Table for Editing
• Moving, Resizing, or Deleting Controls
• Module Three: Review Questions

Module Four: Customizing Apps (II)

• Adding Controls from the Ribbon
• Adding Controls from the Field List
• Changing Control Properties
• Module Four: Review Questions

Module Five: Advanced Record Tasks

• Showing Totals
• Adding from Outlook
• Saving a Record as an Outlook Contact
• Adjust Row Height
• Hiding and Un-hiding Fields
• Freezing and Unfreezing Fields
• Formatting Text
• Module Five: Review Questions

Module Six: Adding Other Types of Fields

• Adding Rich Text and Long Text Fields
• Adding Attachment Fields
• Adding Hyperlink Fields
• Adding Lookup & Relationship Fields
• Adding Calculated Fields
• Module Six: Review Questions

Module Seven: Advanced Field Tasks

• Adjusting the Field Size/Width
• Setting Field Default Value
• Working with More Fields
• Working with Field Validation Options
• Using the Field List
• Module Seven: Review Questions

Module Eight: Working in Table Design View

• Opening Design View
• Working with Field Properties
• Setting the Primary Key
• Using the Properties Sheet
• Working with Table Properties
• Viewing Table Relationships
• Using Relationship Tools
• Viewing Object Dependencies
• Module Eight: Review Questions

Module Nine: Working with External Data

• Linking Data
• Importing Data
• Using the Table Analyzer
• Refreshing Data
• Exporting Data
• Module Nine: Review Questions

Module Ten: Creating Queries

• Creating a Select Query
• Creating a Make Table Query
• Creating an Append Query
• Creating a Cross tab Query
• Showing and Removing Tables
• Module Ten: Review Questions

Module Eleven: Creating Queries

• Module Eleven: Creating Forms and Reports
• Creating a Form with the Form Wizard
• Creating a Report with the Report Wizard
• Modifying Form Layout
• Navigating the Field List
• Key Features on the Form Tools Tabs
• Key Features on the Report Tools Tabs
• Module Eleven: Review Questions