Access 2007 Training Course - Egremont - Cumbria - UK Open Learning - I33062

Access 2007 Training Course - Online

• Course description
  Relational databases are a critical component of our electronic society and now creating, maintaining, and utilizing them are even easier. 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. At the conclusion of this course you’ll be organizing, retrieving and sharing data easily.
  
  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 Form
  
  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

Other programs related to information technology

• Type of course
• Courses in UK
• Courses in England
• Courses in Cumbria
• Courses in Egremont

• Mode of study
• Courses Information Technology Distance in UK
• Courses Information Technology Distance in England
• Courses Information Technology Distance in Cumbria
• Courses Information Technology Distance in Egremont
• Courses Computer Science and Information Technology Distance in UK
• Courses Computer Science and Information Technology Distance in England
• Courses Computer Science and Information Technology Distance in Cumbria
• Courses Computer Science and Information Technology Distance in Egremont

• Category
• Courses Information Technology in UK
• Courses Information Technology in England
• Courses Information Technology in Cumbria
• Courses Information Technology in Egremont
• Courses Computer Science and Information Technology in UK
• Courses Computer Science and Information Technology in England
• Courses Computer Science and Information Technology in Cumbria
• Courses Computer Science and Information Technology in Egremont

• Region
• Masters and Courses in UK
• Masters and Courses in England
• Masters and Courses in Cumbria
• Masters and Courses in Egremont