Microsoft Access 2013 Beginner to Advanced Training

Key Topics Access 2013: Part 1 Lesson 01 - Getting Started with Microsoft Access 2013 Topic A: Orientation to Microsoft Access Topic B: Create a Simple Access Database Topic C: Get Help in Microsoft Access Lesson 02 - Working with Table Data Topic A: Modify Table Data Topic B: Sort and Filter Records Topic C: Create Lookups Lesson 03 - Querying a Database Topic A: Join Data from Different Tables in a Query Topic B: Sort and Filter Data in a Query Topic C: Perform Calculations in a Query Lesson 04 - Creating Advanced Queries Topic A: Create Parameter Queries Topic B: Create Action Queries Topic C: Create Unmatched and Duplicate Queries Topic D: Summarize Data Lesson 05 - Generating Reports Topic A: Create a Report Topic B: Add Controls to a Report Topic C: Enhance the Appearance of a Report Topic D: Prepare a Report for Print Lesson 06 - Customizing the Access Environment Topic A: The Access Options Dialog Box Access 2013: Part 2 Lesson 01 - Designing a Relational Database Topic A: Relational Database Design Topic B: Create a Table Topic C: Create Table Relationships Lesson 02 - Joining Tables Topic A: Create Query Joins Topic B: Join Tables That Have No Common Fields Topic C: Relate Data within a Table Topic D: Work with Subdatasheets Topic E: Create Subqueries Lesson 03 - Organizing a Database for Efficiency Topic A: Data Normalization Topic B: Create a Junction Table Topic C: Improve Table Structure Lesson 04 - Sharing Data Across Applications Topic A: Import Data into Access Topic B: Export Data to Text File Formats Topic C: Export Access Data to Excel Topic D: Create a Mail Merge Lesson 05 - Advanced Reporting Topic A: Organize Report Information Topic B: Format Reports Topic C: Include Control Formatting in a Report Topic D: Add a Calculated Field to a Report Topic E: Add a Subreport to an Existing Report Access 2013: Part 3 Lesson 01 - Implementing Advanced Form Design Topic A: Add Controls to Forms Topic B: Create Subforms Topic C: Organize Information with Tabs Pages Topic D: Enhance Navigation of Forms Topic E: Apply Conditional Formatting Lesson 02 - Using Data Validation Topic A: Field and Record Validation Topic B: Form Validation Lesson 03 - Using Macros to Improve User Interface Design Topic A: Create a Macro Topic B: Restrict Records Using a Condition Topic C: Validate Data Using a Macro Topic D: Automate Data Entry Using a Macro Topic E: Convert a Macro to VBA Lesson 04 - Using Advanced Database Management Topic A: Link Tables to External Data Sources Topic B: Manage a Database Topic C: Determine Object Dependency Topic D: Document a Database Topic E: Analyze the Performance of a Database Lesson 05 - Distributing and Securing a Database Topic A: Splitting a Database for Multiple User Access Topic B: Implement Security Topic C: Set Passwords Topic D: Convert an Access Database to an ACCDE File Topic E: Package a Database with a Digital Signature Lesson 06 - Managing Switchboards Topic A: Create a Database Switchboard Topic B: Modify a Database Switchboard Topic C: Set Startup Options

Learning@Home is an international learning provider and is committed to excellence in training delivery. We aim to make the option of further education accessible to everyone, allowing you to truly take control over your learning by focusing on those who are unable to attend classroom or taught sessions. We currently offer over 600 distance learning courses accredited by a number of established Awarding Bodies including Active IQ, AQA, CISCO, Edexcel, ICB, Microsoft, NCFE, and Sage.