Microsoft Access 2010

$495.00

SKU: GC1701 Categories: ,

Microsoft Access 2010

Our Microsoft Access 2010 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.

Contents: Introduction

  • Starting Out • What is Microsoft Access? • What’s New in Access 2010? • Basic Database Terminology • Opening and Closing Access
  • Interface Basics • Understanding Backstage View (File Menu) • Interface Overview • Using the Standard Tabs • Using Contextual Tabs
  • Database Security • Warnings You May See when Opening a Database • Enabling Content • About Digital Signatures • About Trusted Locations • Opening the Trust Center • Assigning a Password to your Database
  • Getting Help • Opening the Help File • Overview of the Help File • Online vs. Offline Help • Searching for Help
  • The Quick Access Toolbar • The Default QAT Commands • Adding Commands • Removing Commands • Customizing the Toolbar
  • Basics of Tabs • About Tabs • Opening Additional Dialog Boxes • Using the File (Backstage) Menu • Minimizing the Ribbon
  • The Home Tab • Views Commands • Clipboard Commands • Sort & Filter Commands • Records Commands • Find Commands • Text Formatting Commands
  • The Create Tab • Templates Commands • Tables Commands • Queries Commands • Forms Commands • Reports Commands • Macros & Code Commands
  • The External Data Tab • Import & Link Commands • Export Commands • Collect Data Commands
  • The Database Tools Tab • Tools Commands • Macro Commands • Relationships Commands • Analyze Commands • Move Data Commands • Add-Ins Commands
  • First Steps • Planning a Database • Creating a Blank Database • Creating a Database from a Template • Using Database Objects • Setting Navigation Options
  • About Records • What is a Record? • Navigation Tips • Adding Records • Editing Records • Deleting Records • Printing Records
  • Creating a Table • About Tables • Creating a Table • Using Design View • Entering Data into a Table • Formatting a Table
  • Formatting Text • Using the Zoom Box • Selecting Data • Cutting, Copying, and Pasting • Using the Format Painter • Using Undo and Redo • Checking your Spelling
  • Creating and Using Forms • What is a Form? • Bound vs. Unbound Controls • Creating a Basic Form • Creating a Form with the Wizard • Using Design View to Modify your Form • About the Form Design Tools Contextual Tabs • Using Forms
  • Creating and Using Queries • What is a Query? • Creating a Query with the Wizard • Using Design View to Modify a Query • About the Query Design Tools Contextual Tab • Using Queries
  • Creating and Using Reports • What is a Report? • Creating a Report with the Wizard • Using Design View to Modify a Report • About the Report Design Tools Contextual Tabs • Using Reports
  • Sorting and Filtering Data • Using Find and Replace • Sorting Ascending or Descending • Toggling Filter • Using Selection Sort • Using Advanced Sort
  • Viewing Data • Using the View Menu • Using the View Icons • Using the Object Tabs • Closing Individual Object Tabs
  • Printing a Database Object • Print Commands • The Print Dialog Box • Using Print Preview • Printing vs. Exporting
  • Case Study
  • Review Questions

Contents: Intermediate

  • Using Windows Explorer within Access • Navigating with Windows Explorer • Performing Basic Tasks with Windows Explorer • Changing Views in Windows Explorer • Using the Navigation Pane
  • Database Management • Compact and Repair a Database • Backing Up your Database • Editing Database Properties • Adding or Removing Database Passwords
  • Saving Your Files • Using the Save As Dialog • An Overview of Additional Database Formats • Packaging a Database • About AutoRecover
  • Exporting Files • Exporting to PDF or XPS • Exporting to Microsoft Office Excel • Exporting to Other Destinations • Using Saved Exports • Packaging and Signing • Exporting to Older Versions of Access
  • Linking Files • Linking to a Microsoft Excel Spreadsheet • Linking to Another Database • Linking to a SharePoint Site • Other Types of Linked Documents • Creating Hyperlinks
  • Customizing Tables • Understanding Field Properties • Adding a Primary Key • Indexing a Field • Inserting, Deleting, and Moving Fields • Adding Quick Start Elements • Importing a Table from another Source
  • Formatting Tables • Formatting Number Fields • Formatting Text Fields • Adding Field Descriptions • Changing Field Data Types • Adding Captions • Step-By-Ste • p • Skill Sharpener
  • Controlling Table Data Entry • Setting a Default Value • Setting a Required Value • Creating and Using Input Masks • Creating and Removing Table Relationships
  • Managing Table Data Entry • Using the Table Tools – Design Tab • Validating Data • Creating a Lookup Field • Modifying a Lookup Field • Creating a Value List • Modifying a Value List
  • Basic Form Controls • Types of Forms • Types of Form Controls • Adding a Control • Using the Control Wizard • Cutting, Copying, Pasting, and Moving a Control • Formatting a Control
  • Advanced Form Controls • Modifying a Control’s Properties • Changing a Control’s Data Source • Changing a Control’s Default Value • Creating a Calculated Control • Using Form Properties
  • Formatting Your Form • Formatting Gridlines • Modifying the Font • Adding Logos • Changing the Layout
  • Formatting Controls • Changing the Color of a Control • Using Control Properties • Aligning and Sizing Controls • Applying Special Effects
  • Using Themes • Using Themes • Modifying Fonts • Modifying Colors • Saving Customized Themes
  • Organizing Report Data • Adding and Removing Fields • Using Report Sections • Changing Section Properties • Grouping and Sorting in a Report • Doing More with Grouping and Sorting • Using Calculated Controls in a Report
  • Formatting Reports • Formatting Gridlines • Modifying the Font • Adding Logos • Changing the Layout • Using Themes
  • Common Report Tasks • Adding a Photo • Adjusting Page Properties • Adding Page Numbers • Using the Label Wizard • Adding Conditional Formatting
  • Basic Queries • Review of Queries • Creating a Query • Sorting a Query • Filtering a Query • Hiding Fields
  • Doing More with Queries • Using AND/OR Operators • About IIF Functions • Creating Multiple Table Queries • Creating a Calculated Field • About the Expression Builder • Using Queries to Summarize Data
  • Advanced Queries • Creating a Parameter Query • Using Parameter Queries • Creating Crosstab Queries • Using Crosstab Queries • Using Make-Table Queries
  • Management (Action) Queries • Append Queries • Delete Queries • Update Queries • Exporting Queries
  • Case Study
  • Review Questions

Contents: Advanced

  • Referential Integrity • Using the Relationships View and Tab • Types of Relationships • Establishing Referential Integrity • Enforcing Referential Integrity • Testing Referential Integrity
  • Table Relationships • About Join Lines • Normalizing Tables • Using Cascade Delete and Cascade Update • Setting Fields for Indexing • Using the Index
  • An Introduction to SQL • What is SQL? • Parts of an SQL Statement • SQL Keywords • Adding Where Clauses
  • Modal Dialog Boxes • Creating a Modal Dialog Box • Adding Controls • Setting Properties • Formatting your Dialog Box
  • Using Subforms • Creating a Subform • Modifying a Subform • Working with a Subform • Synchronizing Subform Data with a Main Form • Displaying a Subform within a Main Form
  • Advanced Form Tasks • Limiting User Access to a Form • Creating Check Boxes and Command Buttons • Creating Event Procedures • Customizing Error Messages
  • Exporting Your Form • Sending a Form via E-Mail • Managing Replies • Exporting your Form to XML
  • Switchboards • Using a Switchboard vs. Using the Navigation Pane and Tab • Using the Switchboard Manager • Creating a Switchboard • Editing a Switchboard • Deleting a Switchboard
  • Creating a PivotTable • About PivotTables • Creating a PivotTable • More about PivotTable Fields • Completing your PivotTable
  • Creating a PivotChart • About PivotCharts • Creating a PivotChart • More about PivotChart Fields • Completing Your PivotChart
  • Using PivotTables and PivotCharts • Using a PivotTable • Using a PivotChart • Editing a PivotTable or a PivotChart • Common PivotTable and PivotChart Editing Commands • Creating a PivotTable and PivotChart from the Same Object
  • Access and Windows • Recovering Access • Starting Access on Windows Boot • Using Office Diagnostics • Checking for Updates
  • Using the Access Viewer • What is the Access Viewer? • Downloading the Viewer • Using the Viewer
  • Using Outlook with Access • Creating an RSS Feed for Outlook • Importing Contacts from Outlook
  • Using SharePoint 2010 with Access • Important Terminology* • Linking Tables and Lists • Publishing a Database in SharePoint • SharePoint Database Management Tasks
  • Using Macros and VBA
  • Case Study