Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Go to homepage The smart course guide
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: autocad 2007 | paramedic training uk | solar energy training | cameraman training | mewp training | venepuncture training | stakeholder management training | adobe captivate training | autocad training london | information architecture , training
Homepage > IT, Computing, Telecommunications > Database Administration > Access

Access 2007 Training

in UK Open Learning Ltd (England)

Multimedia Course

Price:

£195 + VAT

Duration:

48 Hours


See course programme

Requirements:

There are no entry requirements..

Request free information

Course objectives:

In the Access 2007 course from LearnKey you'll learn how the ribbon makes it easy to find the exact tool you need and how easy it is to synchronize your database with SharePoint Servers. Expert Erin Olsen takes you step-by-step through newly designed database templates to management and security of data to presentation and data sharing.

UK Open Learning Ltd

We provide over 200 distance learning courses to students all over the world. They are fully tutor supported and are fully accredited. Choose from Pet Grooming, Web Design, Child Care, Bookkeeping, ...

see more

Contact course provider

 

Request information

Contact directly and with no obligation with
UK Open Learning Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 48 Hours
Method / place Contact course provider Multimedia
Students per class 30
Suitability Anyone requiring skills in Access.
Course objectives In the Access 2007 course from LearnKey you'll learn how the ribbon makes it easy to find the exact tool you need and how easy it is to synchronize your database with SharePoint Servers. Expert Erin Olsen takes you step-by-step through newly designed database templates to management and security of data to presentation and data sharing.
Requirements
There are no entry requirements..
Price £195 + VAT
Get direct information on how to enrol, venues and availability...

Access courses (from other course providers)

 
Microsoft Access Introduction
Prolog Training
Distance - £300 + VAT
 
Access 2002
Sales 101 Ltd
Online - £75 + VAT
Compare the selected courses
+ access Courses + UK Open Learning Ltd Courses

Course programme

Access 2007 Training
Benefits
· Gain valuable database management skills.

· Acquire leverage to better career opportunities.

· Learn the latest information technology.

Course Outline

Session 1

Section A: Understanding Access
  • What Is Access?
  • Access vs. Excel
  • Components, Objects, and Terms
  • Changes In 2007

    Section B: Getting Started
  • Application Overview
  • Using Templates
  • Using the Ribbon
  • The Navigation Pane
  • Shortcut to Forms
  • Finding Help

    Section C: Using the Navigation Pane
  • Effectively
  • Group View Options
  • Item View Options
  • Organizing Items
  • Navigation Options
  • Table Views
  • Query and Form Views
  • Report and Macro Views


    Section D: Data Entry
  • Working with Records
  • Entering and Editing Records Data
  • Deleting Records
  • Sorting Data In Records
  • Finding Data in Records
  • Entering Data In Forms

    Section E: Database Design
  • Design Steps
  • Purpose
  • Tables
  • Fields
  • Relationships
  • Primary Key
  • Making the Relationship
  • Naming Conventions
  • Design Cleanup
  • Example: Purpose and Tables
  • Example: Primary Key and
  • Relationships

    Section F: Creating Databases and Tables
  • Create Blank Database
  • Datasheet View
  • Saving Tables
  • Table Templates

    Session 2

    Section A: Working with Tables
  • Design View
  • Text and Memo Data Types
  • Number Data Types
  • AutoNumber Data Types
  • Yes/No Data Types
  • Data Beyond the Database
  • Creating Tables
  • Setting Primary Keys

    Section B: Field Properties
  • Field Properties Overview
  • Modifying Fields
  • Text Field Properties
  • Number Field Properties
  • Validation Rules
  • Arranging and Deleting Fields
  • Viewing Changes
  • Validation Text
  • More Field Properties
  • Memo Fields
  • Attachment Fields
  • Input Masks

    Section C: Lookup Fields
  • Creating Lookups
  • Design View Lookups
  • Lookup Properties

    Section D: Relationship Theory
  • Relationship Basics
  • Beyond Relationship Basics
  • Relationship Types
  • Putting Relationship Theory
  • Together

    Section E: Creating Relationships
  • Viewing Relationships
  • Building and Modifying
  • Relationships
  • Relationship Reports
  • Joining Table Properties

    Section F: Analyzing Design
  • Cleaning Up
  • Formatting Datasheets
  • Hiding Columns
  • Rearranging Fields
  • Performance Analyzer

    Section G: Subdatasheets and Filters
  • Adding Subdatasheets
  • Subdatasheet Display
  • Removing Subdatasheets
  • Filtering by Selection
  • Number Filtering
  • Filtering by Form
  • Advanced Filters
  • Total Row Summaries

    Session 3

    Section A: Query Basics
  • Query Wizard
  • Selecting Data Sources
  • Selecting Fields
  • Sorting Fields
  • Arranging Fields
  • Criteria
  • Comparison Criteria
  • Range Criteria

    Section B: Intermediate Queries
  • Field Properties
  • Query Properties
  • Unique List
  • Outputting All Fields
  • Removing Tables
  • Multiple Table Queries
  • Query Relationships

    Section C: Calculation in Queries
  • Adding Fields
  • Calculation Fields
  • Null Values
  • Totals
  • Expression Builder

    Section D: Special Queries
  • Crosstab Queries
  • Modifying Crosstab Queries
  • Finding Duplicate Records
  • Finding Unmatched Records
  • Parameter Queries
  • Range Parameters
  • SQL View

    Section E: Action Queries
  • Updating Queries
  • Creating Table Copies
  • Creating Table Queries
  • Saving Action Queries
  • Archiving Records
  • Deleting Queries
  • Deleting Tables

    Section F: Concatenation
  • What is Concatenation?
  • Concatenating Data
  • Reviewing Concatenation
  • Concatenation Examples

    Session 4

    Section A: Importing/Exporting Data
  • Importing Data
  • Importing Objects
  • Importing from Excel
  • Making Changes
  • Exporting Data
  • Add-Ins
  • Save as PDF or XPS

    Section B: Using Mail Merge
  • Introduction
  • Mail Merge Wizard
  • Creating a Merge Letter
  • Sharing Outlook Contacts
  • Importing Outlook Folders
  • Collaboration

    Section C: Basic Forms
  • Lookup Tables
  • Form Wizard
  • Form Tools
  • Layout View

    Section D: Form Controls
  • Design View
  • Controls
  • Move Controls
  • Selecting Multiple Controls
  • Arranging Controls

    Section E: Form Design
  • Font Formatting
  • Conditional Formatting
  • Control Types
  • Query by Form
  • Check Boxes
  • Bind Controls
  • Properties

    Section F: Special Forms
  • Split Forms
  • Subforms
  • Subform Relationships
  • Creating Subforms
  • PivotTable Forms
  • Calculations
  • Filtering PivotTables

    Section G: Reports
  • AutoReports
  • Report Wizard
  • Grouping and Sorting
  • Adding Pictures
  • Page Breaks
  • Label Wizard
  • Charts

    Session 5

    Section A: Controlling Display and Data Entry
  • Form Properties
  • Display Options
  • Data Entry Options
  • Lock Controls
  • Bang and Dot Operator
  • Query Aliases
  • Query Parameters
  • Dynamic Reports

    Section B: Access Automation
  • Remove Grouping
  • Control Wizard
  • Switchboard Manager
  • Edit Switchboard Pages
  • Edit Main Switchboard
  • Customize Switchboards

    Section C: Custom Automation     
  • Overview
  • Unbound Forms
  • Add Record
  • Message Box
  • Close Form
  • Close Database
  • Modal Dialog Formy
  •  

    Section D: Working with the File
  • Custom Navigation Pane
  • Arranging Objects
  • Database Properties
  • Access Options
  • Current Database Options
  • Compact and Repair
  • Back Up Database
  • Database Splitter
  • Linked Table Manager

    Section E: Security
  • Security Types
  • Password Protection
  • User-Level Permissions
  • Creating User-Level Permissions
  • Security Tips

    Section F: Sharing Information
  • Printing Tables
  • Printing Forms
  • Printing Reports
  • Output as File
  • Database Documenter
  • Save as Previous Version
    • see the full course programme

    on request

    get more information on the programme directly from UK Open Learning Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users
    Get direct information on how to enrol, venues and availability...
     

    Course provider details

    Provider description
    We provide over 200 distance learning courses to students all over the world.
    They are fully tutor supported and are fully accredited.
    Choose from Pet Grooming, Web Design, Child Care, Bookkeeping, Counselling, Mental Health and much more.
    Course provider history
    UK Open Learning is a family owned and run business dedicated to providing the correct course to our students and we ensure our tutor support is second to none. Unlike the large companies we know each student and they are not just a number. We are also an Open College Network accredited centre.
    Get direct information on how to enrol, venues and availability...
     

    Most searched for in Access

    Courses IT, Computing, Telecommunications | Courses Database Administration | Courses Access | Courses Database Design | Courses Database training | Courses Microsoft Access XP | Courses Microsoft Office | Courses SQL

    Information related to Access

    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina (new)
    Words related to the courses viewed: sql microsoft office database design sql server
    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights