Microsoft Access (Level 1)

Whether you are a new user or have been using Access for years, this course will vastly increase your understanding of Access. Existing users will learn how to get the most out of Access, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert Access trainers.

Course Goals:

Delegates will learn fundamental principles of relational database concepts and the use of these concepts when designing and building a database in Microsoft Access. Delegates will also learn shortcuts and tips about how to use Access in the most efficient way.

Topics:

Getting Started

• Relational Database Concepts

• Relationships

• Planning a database

• Using Access to design and build a database

Creating Tables

• Naming Conventions

• Field Names

• Data Types

• Lists

• Assigning a Primary Key Field

• Field Properties

Datasheet view

• Record Entry

• Cancel Record

• Modify Record

• Delete Record

• Format Datasheet

• Print/Preview

• Hide/Show

• Sort

• Find

Filters

• Edit/Sort

• Apply

• Field Selection

• Advanced Filter

Forms

• Wizard

• Create

• Auto Form

• Add Record

• Views 

• Design Form

• Design Layout

• Toolbars

• Controls

• Selection Techniques

• Align Control

• Align Text

• Vertical Spacing

• Horizontal Spacing

• Grids

• Colour Palette

• Adjust Tab Order

Enhancing a Form  

• Adding Fields

• Combo Boxes

• List Boxes

• Calculated Fields

• Modify Properties

Queries

• Creating in design view

• Using search criteria

• Comparison Operators

• Wildcards

• Parameter Queries

• Totals Queries

• Calculated Fields

• Multiple tables

• Joins in tables

Understanding Relationships

• Primary Keys

• One-to-Many

• Relationship Diagram

Basic Reports

• Using Wizards

Office 2016 features

• What's new

• Cloud storage and OneDrive

• Office 365

• Signing-in to Office 2016

• Using Office 2016 on multiple devices

• Easier file sharing

• Views are Easier to Modify

• Callouts for Setting Properties

• Related Items Control

• AutoComplete Control

• Drill-Through Links

• Getting Started Window

• Office Backstage View

• Navigation Pane

• Status Bar

• Tabbed documents

• File Type

• Formatting

• New Table Features

• Sorting and Filtering

• Datasheet Total Row

• Adding Fields

• New Form and Report Features

• Quick Create

• New Layout Views

• New Report View

• Group and Sort

• Stacked and Tabular Layouts