Microsoft Access 2007 Complete Courseware Courseware and Training Materials

Microsoft Access 2007

Just £325 ex-VAT for your complete courseware solution

  • Buy once, use forever!
  • Unlimited reproduction rights
  • Fully customizable content
  • Student and instructor content and resources
  • Foundation, Intermediate, Advanced and Expert levels

Download a free sample of this courseware title

Summary
SummaryOffice tests from knowledge@gtslearning - register for a free trial

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

Fully customisable courseware content, buy once, print many

Why choose a print licence from the Courseware Company?

  • Fully customizable. Sold on a site licence basis, you can tailor the courseware 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, it doesn’t matter…

 

What's included?
What’s included?
Available for delivery as a download from our web server or provided on CD, this courseware package includes the following resources to make your trainer’s life much, much easier.

This courseware package includes:

Student Manual. Fully customisable. May be opened in any wordprocessor and changed to meet your exact needs.
Student workbook. Fully customisable. Additional book includes series of practical tasks and review questions.
Ice breakers and classroom activities Student workbook exercises. Fully customisable. Sample exercises to accompany the student workbook.
Trainer manual. Fully customisable with additional information for trainers.
Timetable and lesson plans Timetable and lesson plans. Fully customisable. 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.

To get started, just open this ‘Microsoft Access 2007′ training courseware in your favourite word processor. You can fully customise the materials to suit your exact learning needs and include your own branding. Your own tailor-made course, delivered ‘off-the-peg’ and saving you thousands of pounds in development time and man-hours. Just press print and the perfect learning experience is yours to deliver.

Course outline
Course outline

Course contents: Foundation Level

  • Starting Out What is Microsoft Access? — What’s New in Access 2007? — Basic Terminology — Opening Microsoft Access — Interface Overview — Closing Microsoft Access
  • Using the Getting Started Window Overview of the Window — Navigating Through the Window — Creating a Database from a Template — Creating a Blank Database
  • The Trust Center 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 Screen — Overview of the Help Screen — Online Help vs. Offline Help — Searching for Help
  • Using the Quick Access Toolbar About the Default Buttons — Adding Buttons — Removing Buttons — Customizing the Toolbar
  • Basics of Tabs About Tabs — Opening Dialog Boxes from the Tab — About the Office Menu
  • The Home Tab Views — Clipboard — Font — Rich Text — Records — Sort and Filter — Find
  • Create Tab Tables — Forms — Reports — Other
  • External Data Tab Import — Export — Collect Data — SharePoint Lists
  • Database Tools Tab Macro — Show/Hide — Analyze — Move Data — Database Tools
  • First Steps Planning a Database — Creating a Database from a Template — Creating a Blank Database — Using Database Objects — Setting Navigation Options
  • About Records What is a Record? — Navigation Tips — Adding Records — Editing Records — Deleting Records — E-Mailing Records — Printing Records
  • Creating a Table About Tables — Creating a Table — 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 Forms What is a Form? — Bound vs. Unbound Controls — Creating a Form with the Wizard — Using Design View to Modify Your Form — Using Forms
  • Creating Queries What is a Query? — Creating a Query with the Wizard — Using Design View to Modify a Query — Using Queries
  • Reports What is a Report? — Creating a Report with the Wizard — Using Design View to Modify a Report — Using Reports
  • Sorting and Filtering Data Using Find and Replace — Sort Ascending or Descending — Toggling Filter — Using Selection Sort — Using Advanced Sort
  • Viewing Data Using the View Menu — Using the View Icons — Using the Tabs — Closing Individual Tabs
  • Printing a Database Object Using the Print Menu — Using Print Preview — Using the Print Preview Tab — Printing vs. Exporting

Course contents: Intermediate Level

  • Using My Computer within Access Navigating with My Computer — Performing Basic Tasks with My Computer — Changing Views with my Computer — Using the My Places Toolbar
  • Database Management Compact and Repair a Database — Backing up Your Database — Editing Database Properties
  • Saving Your Files Using the Save As Dialog — Using the Save As Menu — Using File Properties — Using AutoRecover
  • Exporting Files Exporting to PDF or XPS — Exporting to Word or Excel — Exporting to Other Destinations — Using Saved Exports — Exporting to a CAB File — Exporting to Older Versions of Access
  • Linking Files Linking to an Excel Spreadsheet — Linking to Another Database — Linking to a SharePoint Site — Other Types of Linked Documents — Creating a Hyperlink
  • Customizing Tables Understanding Field Properties — Adding a Primary Key to a Table — Indexing a Field — Inserting, Deleting, and Moving Fields — Importing a Table from another Source
  • Formatting Tables Formatting Number Fields — Formatting Text Fields — Adding Field Descriptions — Changing Field Data Types — Adding Captions
  • 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 Design Tab — How to Validate Data — Creating a Lookup Field — Modifying a Lookup Field — Creating a Value List — Modifying a Value List
  • Basic 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 Controls — Applying Special Effects
  • Formatting Records Modifying Fonts — Using AutoFormat — Using the Format Tab — Using the Arrange Tab
  • Organizing Report Data Adding and Removing Fields — Using Report Sections — Changing Section Properties — Grouping and Sorting in a Report — Changing Group Properties — Using Calculated Controls in a Report
  • Formatting Reports Formatting Gridlines — Modifying the Font — Adding Logos — Changing the Layout — Using AutoFormat
  • Common Report Tasks Adding a Photo — Adjusting Page Properties — Adding Headers and Footers — Adding Page Numbers — Using the Label Wizard
  • Basic Queries Review of Queries — Creating a Query — Sorting a Query — Filtering a Query — Hiding Fields — Using AND OR Operators — Use of IIF Functions
  • Multiple Table Queries Creating a Multiple Table Query — Creating a Calculated Field — Using the Expression Builder — Using Queries to Summarize
  • 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

Course contents: Advanced Level

  • 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
  • Switchboards Using a Switchboard vs. Using the Navigation Pane and Tab — Using the Switchboard Manager — Creating a Switchboard — Editing a Switchboard — Deleting a Switchboard
  • 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
  • Using Outlook and SharePoint with Access Creating an RSS Feed for Outlook — Importing Contacts from Outlook — Importing Contacts from a SharePoint Server — Moving your Database to a SharePoint Server — Publishing to a Web Server
  • 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
  • An Introduction to SQL What is SQL? — Parts of an SQL Statement — SQL Keywords — Adding Where Clauses

Course contents: Expert Level

  • COM Add-Ins What is a COM Add-In? — Using the Add-Ins Tab — Opening the Add-In Manager — Loading Add-Ins — Using the Trust Center
  • Digital Signatures What is a Digital Signature? — Obtaining a Digital Signature — Attaching Your Signature to a Database
  • Smart Tags What is a Smart Tag? — Inserting Smart Tags into a Database — Customizing Smart Tags — Setting Smart Tag Options
  • Managing Your Database Analyzing Performance — Analyzing Tables — Viewing Object Dependencies — Splitting a Database — Database Replication
  • Customizing Access Opening the Options Dialog — Overview of the Options Dialog — Changing User Information — Setting Security Options — Making Access Work Backwards
  • Macro Basics Creating Macros — Playing Macros — Macro Security — Deleting Macros
  • Other Macro Tasks Embedding a Macro — Assigning a Macro to a Keystroke — Assigning a Macro to an Event — Assigning a Macro to a Control
  • Visual Basic and Macros Opening the Visual Basic Editor — Adding Code to your Macro — Adding Comments to VBA Code — Declaring Variables — Prompting for User Input — Using If-Then-Else Statements
  • Macro Groups Creating a Macro Group — Running a Macro Group — Editing a Macro Group
  • SharePoint Basics What is SharePoint? — System Requirements — Creating a Workspace — Accessing a Workspace — Publishing to a Workspace
  • SharePoint Data Using Offline Lists — Exporting a List — Restricting Permission for Data Objects
  • Your Personal SharePoint Space Public and Private Views — Shared and Private Documents — Creating a List — Creating a Page — Personalizing your Space
  • Understanding SQL What is an SQL Database? — What is an SQL Statement? — What is an SQL Convention? — What is SQL Syntax? — Linking a Database to an SQL Server
  • Using the SELECT Statement Selecting All Data — Selecting Specific Data — Selecting Conditional Data — Using the ORDER BY Statement
  • Using Subqueries What is a Subquery? — Creating a Subquery — Subqueries with Equality — Subqueries with Aggregate Functions — Nested Subqueries and Uses of the IN Keyword
  • Using SQL Joins Creating Simple Joins — Using an Alias — Sorting Joins — Creating Outer Joins

FAQs

FAQs for this course title

No FAQs specifically for this title have been uploaded yet. Please check out the Product FAQs for general questions about the products.

Download free sample files for this title
Please enter your details in the form below to get an instant sample of this course title.

First Name:
Last Name:
Organization:
Telephone:
e-Mail:
Please check box if you don't want to receive regular updates from the Courseware Company and gtslearning:


Your e-mail address will only be used for the purposes of this initial contact or for subsequent mailings. Your details won’t be passed to any third-parties and, in accordance, with current regulations, you may request that your details are removed from our database by contacting sales@gtslearning.com.


Bundle and save…

This course is included in the following great-value bundles: