Microsoft Access 2013

$495.00

SKU: GC1901 Categories: ,

Microsoft Access 2013

Our Microsoft Access 2013 training materials provides you with a fully-customizable package of courseware content for delivering Microsoft Office training to your employees and/or students. Everything you need to run the course is included, just add trainer!


DOWNLOAD SAMPLE

All courseware print licences are perpetual – buy once and use forever!

  • Complete. Includes content at Foundation, Intermediate and Advanced levels.
  • Fully customizable. Sold on a site licence basis, you can tailor ALL content to meet specific learning or corporate requirements.
  • Digital download. Content is available to download after purchase.
  • Proven. Our course materials are used in hundreds of training centres around the world. Every course is fully beta tested and validated in the classroom before undergoing a full production release.
  • Simple… No need to invest in expensive DTP applications – all files are easily editable in any word processor.
  • Print on demand. You only need to print exactly what you need, when you need it.
  • Totally flexible. Courses can be modified to meet specific requirements. Sections can be removed. New content added. One or more titles can be combined. Whatever your training requirements, our courseware can help you meet that need.
  • Unlimited users. Content is sold on a site licence basis. You can train as many staff or employees at that location as you like. Forever!
  • Buy once. Use forever! You’re buying a perpetual licence. One payment gives you an unlimited site licence for use as long as you need it.
  • No limits! Unlike some content providers, our licence enables you to reprint the courseware as many times as you like. 1 student or 100,000. No limits…


DOWNLOAD SAMPLE

Student manual

Fully customisable. May be opened in any word processor and changed to meet your exact needs.

Student workbook

Fully customisable. Additional book includes series of practical tasks and review questions.

Student workbook exercises

Sample exercises to accompany the student workbook.

Trainer manual

Fully customisable with additional information for trainers.

Timetable and lesson plans

Detailed timetable and plans ensure you deliver the best possible course

PowerPoint presentations

PowerPoint presentations. Fully customisable. Complete set of PowerPoint slides for use by the trainer.

Course contents: Core

  • The Basics • Getting Started • Signing In • Creating a Database • Database Terminology • Saving a Database • Opening a Database • Review Questions
  • Your First Database • About Security Warnings • About Relationships • Searching for Objects • Opening Database Objects • Changing the Object View • Understanding the Types of Views Available • Managing Objects • Review Questions
  • Working with Tables and Records • Creating a Table • Understanding Table Views • Adding and Editing Records • Searching and Browsing Records • Deleting Records • Printing Records • Review Questions
  • Formatting Tables • Selecting Data • Changing Column and Row Width and Height • Applying Text Formatting • Applying Gridlines • Changing Fill Colors • Checking Your Spelling • Review Questions
  • Creating Forms • Creating a Form from an Object • Creating a Form with the Wizard • Creating a Form from Scratch • Understanding Form Views • Using a Form • Review Questions
  • Formatting Forms • Understanding Bound and Unbound Controls • Changing the Theme • Using the Format Painter • Adding Fields • Adding Controls • Adding Images and Logos • Review Questions
  • Creating Reports • Creating a Report from an Object • Creating a Report with the Wizard • Creating a Report from Scratch • Understanding Report Views • Printing Reports • Review Questions
  • Formatting Reports • Changing the Theme • Using the Format Painter • Grouping and Sorting Data • Adding Controls • Adding Images and Logos • Adding Page Numbers, Headers, and Footers • Review Questions
  • Creating Basic Queries • Types of Queries • Creating a Query with the Wizard • Running a Query • Understanding Query Views • Sorting and Filtering a Query • Review Questions
  • Creating Advanced Queries • Creating and Using Parameter Queries • Creating and Using Crosstab Queries • Creating and Using Make-Table Queries • Creating and Using Multiple Table Queries • Creating and Using Append Queries • Creating and Using Delete Queries • Creating and Using Update Queries • Review Questions
  • Managing Your Database • Compacting and Repairing a Database • Encrypting a Database with a Password • Backing Up Your Database • Exporting a Database and Database Objects • Printing Database Objects • Review Questions
  • Customizing the Interface • Collapsing and Pinning the Ribbon • Customizing the Quick Access Toolbar • Hiding and Showing Ribbon Tabs • Creating Custom Ribbon Tabs • Resetting Interface Changes • Review Questions

Course contents: Advanced

  • Managing Data • Types of Relationships • Viewing Relationships • Viewing Object Dependencies • What is Referential Integrity? • Enforcing Referential Integrity • Using Cascade Delete and Cascade Update • Review Questions
  • Advanced Table Tasks • Inserting Application Parts • Using the Table Analyzer Wizard • Creating Validation Rules • Configuring Validation Messages • Review Questions
  • Managing Data Entry in Tables • Marking Fields as Required • Marking a Field for Indexing • Creating Lookup Fields • Creating Value Lists • Creating Input Masks • Review Questions
  • Creating Subforms • Creating Subforms • Using Subforms • Linking Subforms with Parent Forms • Formatting a Subform within a Main Form • Review Questions
  • Creating Navigation Forms • Creating a Navigation Form • Adding Tabs to a Navigation Form • Creating a Tab Hierarchy • Displaying the Navigation Form when the Database Opens • Review Questions
  • Advanced Query Tasks • Understanding SQL Statements • Basic SQL Keywords • Creating SQL Queries • Using the Expression Builder • Review Questions
  • Creating Modal Dialog Boxes • Creating a Modal Dialog Box • Adding Controls • Setting Properties • Formatting a Modal Dialog Box 113
    Review Questions
  • Splitting the Database • Backing Up the Database • Splitting the Database • Configuring Access 2013 for a Multi-User Database • Setting Record Locking Options • Review Questions
  • Using Access with SharePoint Server • Linking Tables and Lists • Moving a Database to SharePoint • Saving a Database to SharePoint • About Access Web Apps • Review Questions
  • Creating Basic Macros • Creating a Standalone Macro • Using the Action Catalog • Adding Comments to Macros • Using If-Then Actions • Handling Macro Errors • Review Questions
  • Advanced Macro Tasks • Creating Event Procedures • Creating Data Macros • Creating Submacros • Grouping Submacros • Review Questions
  • Using Visual Basic for Applications • Converting a Macro to Visual Basic • Using Visual Basic for Applications • Understanding Modules • Building Visual Basic Procedures • Review Questions

Course contents: Expert

  • SQL and Microsoft Access • What is SQL? • What is an SQL Statement? • What is an SQL Naming Convention? • What is SQL Syntax? • Review Questions
  • Using the SELECT Statement • Selecting All Data • Selecting Specific Data • Selecting Conditional Data • Using the ORDER BY Statement • Review Questions
  • Using SQL Joins • Creating Simple Joins • Using an Alias • Sorting Joins • Creating Outer Joins • Review Questions
  • Using Subqueries • What is a Subquery? • Creating a Subquery • Subqueries with Aggregate Functions and Nested Subqueries • Using the IN Keyword with Subqueries • Review Questions
  • Advanced Form Tasks, Part One • Limiting User Access to a Form • Creating Checkboxes and Command Buttons • Building Command Button Events • Creating Event Procedures • Review Questions
  • Advanced Form Tasks, Part Two • Using Hyperlinks in a Form • Adding Links to Other Database Objects • Inserting a Mailto Link in a Form • Adding a Browser Control to a Form • Performing Calculations in a Form • Review Questions
  • Advanced Form Tasks, Part Three • Exporting Your Form to XML • Exporting a Form as a Word Document • Exporting a Form as HTML • Sending a Form as an E-mail Attachment • Exporting a Form to Other Formats • Review Questions
  • Creating Split Forms • Creating a Split Form • Splitting an Existing Form • Using a Split Form • Fixing the Form Separator • Review Questions
  • Using Digital Signatures • What is a Digital Signature? • Obtaining a Digital Signature • Attaching Your Signature to a Database • Extract and Use a Signed Database • Review Questions
  • Using the Trust Center • Opening the Trust Center • Trusting a Database • Configuring Macro Security • Customizing the Message Bar • Review Questions
  • Managing COM Add-ins • Viewing Add-ins • Opening the Add-in Manager • Installing Add-ins • Disabling All Add-ins • Uninstalling Add-ins • Review Questions
  • Customizing Access • Changing User Information • Changing the Office Background and Theme • Setting the Default Database Type and Location • Review Questions