09/12/2011
      No Comments
      latif
  1. Tutorial: Introduction to access 2007
    1.  Access 2007
    2. Create a database
    3. Open a database
    4. Tour the interface
  2. Tutorial: Table Part 1
    1. Create a table
    2. Set a primary key
    3. Select data types
    4. Add and remove data
  3. Tutorial: Table Properties
    1. Field Size
    2. Input mask
    3. Default
    4. Validation
    5. Indexes
    6. Extras
  4. Tutorial: Normalize Data
    1. Good database design
    2. Import data
    3. Divide data
    4. Create relationships
  5. Tutorial: Simple Queries
    1. Query Wizard
    2. Design a select query
    3. Set simple criteria
  6. Tutorial: Simple forms
    1. Create
    2. Editing Layout View and design View
    3. Work with data
  7. Tutorial: Design a Form
    1. Form wizard
    2. Add fields
    3. Work with controls and formats
  8. Tutorial: Query Design
    1. Multiple Table Queries
    2. Joins = inner or Qui outer or left/right
    3. Maintenance
  9. Tutorial: Advanced Queries
    1. Make a new table
    2. Delete records
    3. Append Data
    4. Update data
    5. View SQL Code
  10. Tutorial: Simple Reports
    1. Create a report
    2. Use report wizard
    3. Leverage Criteria
    4. Create Mailing Labels
  11. Tutorial: Report Design
    1. Design a Report
    2. Format a Report
    3. Work with Groups
    4. Calculation Fields
  12. Tutorial: Advanced Forms
    1. Create a sub form
    2. Create a tabbed form
    3. Add controls
    4. Work with properties
  13. Tutorial: Simple Macros
    1. Create Macros
    2. Add conditions
    3. Run Macros from Form and Reports
    4. Link Events
  14. Tutorial: Calculate with Queries
    1. Add a calculated Field
    2. Work with totals
    3. Create crosstab queries
  15. Tutorial: Advanced Reports
    1. Create a pivot chart
    2. Insert a sub report
    3. Add controls
    4. Work with properties
  16. Tutorial: Database Tools
    1. Administer a database
    2. Backup data
    3. Repair a database
    4. Work with options
  17. Tutorial: Security
    1. Set permissions
    2. File Type Differences
    3. Encrypt the database
    4. Use the trust center
    5. Package and sign
  18. Tutorial: External Data
    1. Import/Export Data
    2. Create a mail merge
    3. Manage emails
    4. Create PDF XPX files
  19. Tutorial: Create an Application
    1. Create objects
    2. Create macros
    3. Create a switchboard
    4. Create an accde file
    5. Hide objects
  20. Tutorial: MCAS Exam Preparation – 77-605
    1. View exam objectives
    2. Tips for studying
Tags: , , ,