CBIT Custom Computer Training Courses Custom computer training
   Compétences d'affaires | En ligne | Bureautique | Nos salles | Horaire | Contact | Documents | Exercices | Liens | Cours du mois
Recherche:



| |Microsoft Access 2010 Level 1 Database Fundamentals
| | ID: SAA100 | Course Length: 2
| Module 0: Course Details
|
  1. Duration: 2-day Webinar Or Instructor-led Classroom Setting
  2. Create Tables
  3. Understand and Create Relationships
  4. Create Simple Queries
  5. Prerequisites:
  6. Basics of a Windows-based Computer.
  7. Comfortable Using the Keyboard, Mouse, and Start Menu.
  8. Understanding and Experience with Printing
  9. Able To Use a Web Browser.
  10. Knowledge of Other Software in the Microsoft Suite An Asset.
  11. Objectives: This Course Will Cover
  12. Basic Database Fundamentals
| Module 1: Exploring Access
|
  1. What Is Ms Access
  2. Opening Access
  3. How To Plan and Design Access Database
  4. What Is Normalization
  5. Interface Overview
  6. Understanding Access Objects
  7. Navigating Access
| Module 2: Getting Help
|
  1. Using the Online Help
  2. Using the F1 Key
| Module 3: Using the Trust Center
|
  1. What Are Warnings
  2. Enable Content
  3. About Digital Signatures
  4. About Trust Locations
  5. Open the Trust Center
  6. Assign a Password To the Database
| Module 4: Using the Getting Started Window
|
  1. Exploring the Window
  2. Creating a Database From a Template
  3. Creating a Blank Database
| Module 5: Working with Tables
|
  1. Using Datasheet View
  2. Navigating Fields in Tables
  3. Adding Records
  4. Selecting Records
  5. Editing Records
  6. Deleting Records
| Module 6: Editing Tables
|
  1. Row Height and Column Width
  2. Changing Format
  3. Selecting, Moving and Hiding Columns
  4. Freezing Columns
| Module 7: Creating Tables
|
  1. Creating a New Database
  2. Adding a Field Description
  3. Setting a Primary Key
  4. Using the Table Wizard
  5. Normalizing Tables
  6. Designing Tables
  7. Creating a Table in Design View
  8. Using Design View
  9. Adding Field Names
  10. Using Prefixes
  11. Assigning Data Types
| Module 8: Setting Field Properties
|
  1. Using Field Properties
  2. Limiting Field Size
  3. Setting Number Formats
  4. Setting Date/time Formats
  5. Setting Yes/no Formats
  6. Setting Default Values
  7. Setting Validation Rules
  8. Creating An Input Mask
| Module 9: Creating Relationships
|
  1. Creating a Relationship Between Tables
  2. Rules for Setting Referential Integrity
  3. Exploring Cascading Update and Delete Options
  4. Deleting a Relationship
| Module 10: Importing and Exporting Data
|
  1. Exporting Data To An Excel Workbook
  2. Drag and Drop Data Into Excel
  3. Creating Excel Workbooks - Links
  4. Creating Word Documents - Links
  5. Importing Data in Access
  6. Linking From An Other Application
| Module 11: Finding and Filtering Data
|
  1. Sorting Records
  2. Finding Specific Records
  3. Finding Records Using Wildcards
  4. Using Replace
  5. Using Filter By Selection
  6. Applying/removing a Filter
  7. Using Filter Excluding Selection
  8. Using Filter For
  9. Using Filter By Form
| Module 12: Using Simple Queries
|
  1. Using the Select Query Wizard
  2. Creating a Query in Design View
  3. Understanding the Qbe Grid
  4. Hiding a Field in a Query
  5. Adding a Table To a Query
  6. Joining Tables in a Query
  7. View a Select Query
  8. Using Totaling Queries
  9. Add a Calculated Field
| Module 13: Modifying Query Results
|
  1. Sorting a Query
  2. Adding Criteria To a Query
  3. Printing a Query
| Module 14: Using Operators in Queries
|
  1. Using Comparison Operators
  2. Using An And Condition
  3. Using An Or Condition
  4. Using the Between and Operator
  5. Using a Wildcard Character
| Module 15: Creating Basic Forms
|
  1. Creating Forms
  2. Using Autoform, Using the Form Wizard and Manual Forms
  3. Navigating in Forms
  4. Viewing Records in a Form
  5. Printing Records in a Form
  6. Adding a Record Using a Form
  7. Creating Basic Reports
| Module 16: Using Reports
|
  1. Using Autoreport, Using the Report Wizard and Manual Reports
  2. Using Print Preview - Reports
  3. Printing Pages of a Report
  4. Basing a Report On a Query
| Module 17: Lab
|

    CBIT's Ottawa online training courses
    CBIT's Ottawa soft skills training courses
    CBIT's Ottawa software training courses

    Ottawa Software Training Ottawa Business Skills Training
    Ottawa Technical Training
    CBIT's Ottawa online training courses CBIT's Ottawa soft skills training courses CBIT's Ottawa software training courses
    Détails additionnels Détails additionnels Détails additionnels
              Copyright © 2008 CBIT/CCTI. All rights reserved. Web design by choquettetech.com