Microsoft Access Training: Introduction / Intermediate Course

• Understanding Microsoft Access
• Starting Access From the Windows Start Screen
• Starting Access From the Desktop
• Understanding the Start Screen
• Creating a New Blank Database
• Understanding the Backstage View
• Opening an Existing Database File
• Understanding the Access 2013 Screen
• Using the Ribbon
• Working With the Navigation Pane
• Adding Commands to the QAT
• Working With Touch Mode
• Working With a Table
• Working With Other Database Objects
• Closing a Database File
• Exiting From Access

This session is focused on database design. Before creating a database it is critical to design it correctly for it to function efficiently. This session explains the different datatypes that Access can store before leading delegates though the process of designing and refining a database design.

The key topics trained include:

• Understanding How Access Stores Data
• Understanding Access Data Types
• Scoping Your New Database
• Identifying Table Problems
• Refining Table Structures
• Finalising the Design

Having designed a database the next step is to actually create it. This session leads delegates through that process, ie how to create a new file and then the table (or tables) within it. It then looks at creating and defining primary keys for the table created. The next part focuses on working with a multiple table database. It explains how relationships are defined, managed and created. Finally it shows you how to review the relationships within a database.

The key topics trained in this session are:

• Creating A New Database File
• Creating the Lookup Table
• Defining the Primary Key
• Saving and Closing A Table
• Creating the Transaction Table
• Understanding Lookup Table Relationships
• Connecting To A Lookup Table
• Viewing Table Relationships

Once you have created your database the next step is to define the data fields that are held within each of your tables. This session gives delegates a thorough overview of defining and working with table field properties.

The key topics trained include:

• Opening an Existing Table
• Adding Fields to an Existing Table
• Understanding Field Properties
• Changing Field Size
• Changing Field Names
• Changing Decimal Places
• Changing Date Formats

The relationships between tables are critical in an Access database. This session focuses on all aspects of those relationships. It explains how they work, how to view them and then how to create and edit table joins which are defined by table relationships. It finishes by teaching you how to create a report that shows the relationships within a database.

The key topics trained include:

• Understanding Table Relationships
• Understanding Lookup Relationships
• Looking Up the Employees Table
• Looking Up the Expense Types Table
• Viewing Table Relationships
• Understanding Table Joins
• Editing the Employee Table Join
• Editing the Expense Type Table Join
• Creating a New Join
• Creating a Relationship Report

Having established a database which contains a number of linked tables and in which the fields have been established it is time to start using your database to store data. This session focuses on entering data into a database. It shows you how to manually enter records, how to create and use a form to make data entry and how to save that form for future use. It finishes by showing you how to import data into Microsoft Access from Excel.

The key topics trained include:

• Typing Records In A Table
• Adding Records Using A Form
• Saving A Form Layout For Reuse
• Adding Records Using An Existing Form
• Assignment Adding Records
• Importing From Microsoft Excel

• Typing Transactional Records
• Transactional Records Using A Form
• Assignment Adding Transactional Records
• Adding Records Using A Subdatasheet
• Removing A Subdatasheet
• Inserting A Subdatasheet

• Assigning Default Values
• Validation Rules and Text
• Validating Numbers
• Setting Required Fields
• Working With Validations

• Changing Column Widths
• Formatting Cells In The Table
• Changing Fonts
• Moving Columns In A Table
• Freezing Columns In A Table
• Hiding Columns In A Table
• Unhiding Columns

• Exporting Records to Microsoft Excel
• Exporting Records to a Text File
• Importing From Microsoft Excel
• Importing From a Text File
• Linking to an External Source

• Modifying A Saved Query
• Creating AND Queries
• Creating OR Queries
• Querying Numeric Data
• Querying Dates
• Using A Range Expression
• Querying Opposite Values
• Moving Fields In A Query
• Sorting Query Data
• Removing Fields From A Query
• Querying Using Wildcards
• Problem Characters
• Querying With A Lookup Table
• Sorting Query Data Numerically
• Displaying NULL Values
• Querying for Uniqueness

• Understanding Relational Queries
• Creating a Relational Query Design
• Filtering a Relational Query
• Filtering Related Fields
• Adding More Tables and Fields
• Utilising Hidden Fields
• Understanding Query Joins
• Creating an Inner Join
• Creating a Left Outer Join
• Creating a Right Outer Join

• Creating a Parameter Query
• Displaying All Using Parameters to Display a Range
• Using Parameters in Expressions
• Using Parameters With Wildcards

• Creating a Calculated Field
• Formatting Calculated Fields
• Summarising Data Using a Query
• Changing the Grouping
• Calculating With Dates
• Using Criteria in Calculations
• Concatenating String Fields

• Understanding Reporting In Access
• Creating A Basic Report
• Working With Existing Reports
• Previewing and Printing A Report
• Changing The Report Layout
• Using The Report Wizard
• Creating A Grouped Report
• Creating A Statistical Report
• Working With Grouped Reports