Access Essentials 2013 Course

Access 2013 Environment

• Understanding Microsoft Access 2013
• Starting Access in Windows 8
• 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 2013

Designing a Relational Database

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

Creating a Database

• Creating a New Relational Database
• Creating a Table (Parent)
• Defining the Primary Key Field
• Saving and Closing a Table
• Creating the Transaction Table (Child)
• Understanding Table Relationships
• Joining Tables
• Viewing Table Relationships (Schema)

Modifying Table Properties

• Opening an Existing Table
• Adding Fields to a Table
• Setting Field Properties
• Changing Field Size Property
• Updating Field Names
• Set Decimal Places
• Changing Date Formats
• Indexing Table Fields
• Deleting Table Fields
• Copying a Table
• Deleting a Table

Adding Records

• Typing Records via a Table
• Create an Basic Form
• Adding Records via a Form
• Saving a Form
• Adding Records via an Existing Form
• Adding Additional Records
• Importing Data From Microsoft Excel

Adding Transactional Records

• Typing Transactional Records
• Adding Transactional Records via a Form
• Adding Additional Transactional Records
• Adding Records via a Subdatasheet
• Inserting and Removing a Subdatasheet

Table Data Validation

• Assigning Default Values to a Field
• Setting Validation Rules and Text
• Validating Numbers
• Setting Required Fields in a Table
• Working with Other Data Validations

Working with Table Records

• Navigating Through Records in a Table
• Going a Specific Record
• Editing an Existing Record
• Deleting a Record
• Undo a Record Update
• Deleting a Record
• Deleting Multiple Records
• Searching for Data in a Table
• Searching in a Field
• Finding and Replacing Data
• Printing Table Records
• Compacting and Repairing a Database

Formatting Tables

• Changing Column Widths
• Formatting Tables
• Changing Table Fonts
• Moving Columns in a Table
• Freezing Table Columns
• Hiding Table Columns
• Un-hiding Table Columns

Sorting and Filtering

• Simple Sorting
• Sorting On Multiple Fields
• Simple Table Filtering
• Working with Table Filters
• Filtering Date Ranges

Creating Queries

• Understanding Access Queries
• Creating a Query
• Working with a Query
• Changing a Query Design
• Applying Record Filter Criteria
• Clearing Selection Filter Criteria
• Saving a Database Query
• Running Queries Directly from the Navigation Pane
• Deleting a Query
• Creating More Queries

Query Techniques

• Modifying an Existing Query
• Utilising AND Criteria in Queries
• Utilising OR Criteria in Queries
• Querying Numeric Fields
• Querying Date Fields
• Using Range Expressions
• Querying for Opposite Values
• Moving Fields in a Query
• Sorting Data in a Query
• Removing Fields from a Query
• Wildcards in Queries
• Working with Problem Characters
• Querying With a Related Tables
• Sorting Data Numerically
• Displaying NULL Values
• Querying For Uniqueness

Creating Reports in Access

• Understanding Reporting In Access
• Creating a Basic Report
• Editing Existing Reports
• Previewing a Report
• Printing a Report
• Changing the Report Layout
• Build a Report Using the Report Wizard
• Grouping Data in a Report
• Statistical Reports
• Managing Grouped Reports

Creating and Using Access Forms

• Understanding Form Structure
• Creating a Basic Main Form
• Creating a Split Form
• Binding a Form to a Query
• Build a Form Using the Form Wizard
• Editing Existing Forms
• Updating Records via a Form
• Deleting Records via a Form
• Deleting a Form