Access 2007

Visuel non disponible

Microsoft Access 2007 helps you effectively track, report, and share information in a manageable environment. With a library of pre-built tracking applications (database solutions) and the Microsoft Office Fluent user interface, Access 2007 does not require deep database knowledge or programming skills. In this VTC course, Author / IT Instructor, Tim Warner introduces users to database design concepts while assisting them in becoming proficient with building and maintaining an Access 2007 database. To begin learning today, simply click on one of the Microsoft Access 2007 links.

Formateur : Tim Warner
Enregistré sur PC | Langue: Anglais
Durée : 8h5 | Leçons: 132

Compatible Mac, Windows & iPad (en VOD)
143,52 € En stock

Acheter sur CD
ou DVD
Acheter des Crédits
pour Consultation
En savoir plus >>


TVA incluse, Hors Livraison 143,52 €

Accès à l'unité

Cette formation nécessite crédits

10 Crédits 10,00 € TTC commander
35 Crédits 30,00 € TTC commander
60 Crédits 50,00 € TTC commander
130 Crédits 100,00 € TTC commander
Format de la vidéo : Quicktime Flash

  • Importing Data

    • (03:27) Leveraging Data Import
    • (04:41) Importing from Text pt. 1
    • (04:38) Importing from Text pt. 2
    • (03:51) Importing from Excel
    • (04:29) Importing from XML
    • (02:57) Importing from Outlook
    • (03:49) Importing from Access

  • Exporting Data

    • (04:04) Exporting to Text
    • (02:47) Exporting to Excel
    • (03:15) Exporting to XML
    • (03:15) Exporting to Word
    • (03:19) Exporting to Access

  • Modifying Table Design

    • (03:45) Renaming Tables
    • (02:36) Dropping Tables
    • (04:03) Managing Fields pt. 1
    • (04:55) Managing Fields pt. 2
    • (03:40) Managing Fields pt. 3
    • (04:52) Using Undo and Redo
    • (03:51) Changing the Primary Key pt. 1
    • (04:10) Changing the Primary Key pt. 2
    • (03:56) Setting Table Relationships pt. 1
    • (04:45) Setting Table Relationships pt. 2
    • (02:47) Setting Table Relationships pt. 3
    • (03:16) Using the Table Analyzer Wizard

  • Maintaining Data Integrity

    • (04:15) Introduction to Data Types
    • (04:02) Managing Data Types pt. 1
    • (03:12) Managing Field Data Types pt. 2
    • (03:17) Setting Field Length
    • (04:25) Using Input Masks pt. 1
    • (04:08) Using Input Masks pt. 2
    • (03:08) Using Default Values pt. 1
    • (03:00) Using Default Values pt. 2
    • (04:52) Setting a Validation Rule
    • (03:47) Creating a Lookup List pt. 1
    • (03:30) Creating a Lookup List pt. 2
    • (04:52) Creating a Lookup List pt. 3
    • (01:39) Compacting the Database
    • (01:19) Backing Up the Database

  • Using Forms

    • (04:16) Understanding Forms
    • (03:54) Navigating in Forms
    • (04:41) Creating a Form Quickly
    • (04:03) Using the Form Wizard
    • (03:39) Understanding Form Views
    • (03:22) Creating a Blank Form pt. 1
    • (03:32) Creating a Blank form pt. 2
    • (04:24) Aligning Controls
    • (04:50) Sizing Controls
    • (03:44) Controlling Data Input
    • (03:32) Creating an Option Group pt. 1
    • (03:34) Creating an Option Group pt. 2
    • (03:10) Formatting a Form
    • (02:04) Using AutoFormat
    • (01:33) Setting Tab Order
    • (03:18) Creating Subforms pt. 1
    • (03:09) Creating Subforms pt. 2

  • Querying Data

    • (04:15) Sorting Table Records
    • (04:03) Using Basic Filters
    • (03:07) Using Filter By Form
    • (03:31) Using Advanced Filters
    • (04:19) Understanding Queries
    • (04:08) Using the Query Wizard
    • (04:30) Designing Select Queries
    • (04:54) Adding Query Criteria
    • (03:54) Designing Parameter Queries
    • (03:15) Using Calculated Fields
    • (03:58) Designing Action Queries pt. 1
    • (03:54) Designing Action Queries pt. 2
    • (05:10) Designing Action Queries pt. 3
    • (03:24) Generating Totals and Averages
    • (03:32) Using Expression Builder

  • Working with Reports

    • (02:19) Understanding Reports
    • (03:58) Creating a Report Quickly
    • (04:52) Using the Report Wizard
    • (04:49) Formatting a Report
    • (04:27) Creating a Blank Report pt. 1
    • (02:49) Creating a Blank Report pt. 2
    • (04:40) Creating a Blank Report pt. 3
    • (05:26) Using Queries in Reports
    • (04:25) Using Calculated Values
    • (03:40) Previewing and Printing a Report
    • (03:03) Saving a Report as PDF

  • Securing and Sharing Data

    • (04:08) Password-Protecting Your Database pt. 1
    • (04:17) Password-Protecting Your Database pt. 2
    • (04:24) Securing Database Code
    • (04:08) Distributing Your Database pt. 1
    • (03:36) Distributing Your Database pt. 2

  • Customizing Your Database

    • (04:19) Creating a Switchboard pt. 1
    • (03:56) Creating a Switchboard pt. 2
    • (03:42) Creating a Switchboard pt. 3
    • (04:28) Understanding the Navigation Pane
    • (03:55) Defining Custom Categories pt. 1
    • (03:31) Defining Custom Categories pt. 2
    • (04:54) Setting Global Options
    • (03:35) Customizing Quick Access pt. 1
    • (04:09) Customizing Quick Access pt. 2
    • (04:38) Creating a Custom Ribbon
    • (03:41) Using Performance Analyzer
    • (02:31) Using Database Documenter

  • Five Cool Access Tips and Tricks

    • (04:25) Getting Certified in Access 2007
    • (04:10) Great Access 2007 Resources
    • (02:40) Microsoft Virtual Labs
    • (02:44) Access Ribbon Mapping Workbook
    • (04:37) Keyboard Shortcuts

  • Wrap-Up

    • (03:11) Wrap-Up

  • About the Author

    • (03:24) About the Author
Formateur : Tim Warner
Langue : Anglais
Durée : 8h5
Nombre de séquences vidéo : 132 		SKU : 33820
Réf :
ISBN : 1-934743-27-5

Descriptif :

Microsoft Access 2007 helps you effectively track, report, and share information in a manageable environment. With a library of pre-built tracking applications (database solutions) and the Microsoft Office Fluent user interface, Access 2007 does not require deep database knowledge or programming skills. In this VTC course, Author / IT Instructor, Tim Warner introduces users to database design concepts while assisting them in becoming proficient with building and maintaining an Access 2007 database. To begin learning today, simply click on one of the Microsoft Access 2007 links.




Tim Warner

Timothy L. Warner is the Director of Technology for Ensworth High School, a premier independent school in Nashville, TN. An expert instructor, Warner has taught information technology courses for ExecuTrain and Syracuse University, has worked as a senior-level network engineer for Vanderbilt University, and has published extensively on a wide variety of IT-related topics.

Vous souhaitez recevoir l'aide d'un formateur expérimenté pour parfaire votre apprentissage ? C'est possible grâce a notre centre de formation accompagnée a distance.

Nouveaux Parcours

Tous les parcours »
  • Profitez de conseils personnalisés grâce a des entretiens téléphoniques réguliers avec votre formateur.
  • Confrontez-vous a la réalité des entreprises grâce aux exercices proposés pendant la formation.
  • Obtenez une Attestation de Formation Professionnelle.
  • Contactez-nous pour le financement de votre formation par votre OPCA.