Access 2010

Easy-to-undestand video tutorials

As part of the release of the Office 2010 software suite, Microsoft is introducing the latest version of Access, their entry-level database application software. Don't let the words 'entry-level' fool you, this is one very powerful database tool. Access was designed to collect, store, manage, report, and dissect data for individuals and small businesses. The release of the 2010 version continues to raise the bar of what an entry-level database product can do. In this course, Mark Long takes you from opening Access 2010 for the first time through the entire process of creating a database. He covers tables, queries, forms, reports, and many of the other bells and whistles that make up Access 2010. Click the movie links below to get started now!

Durée 9
Avec : Mark Long
Formation téléchargeable
FORMATION TÉLÉCHARGÉABLE
Formation téléchargeable
VISIONNAGE ILLIMITÉ
Formation téléchargeable
DISPONIBLE SUR USB

Nos clients ont également vu :

  • Access 2010 Basics

    • (04:59) What Can I Do with Access?
    • (05:04) Access Database Objects
    • (04:35) Opening Access 2010
    • (03:34) Creating a Database
    • (06:15) Getting Around in Access
    • (06:23) Where to Really Start
  • Working with Tables

    • (03:48) Creating Our Database
    • (02:03) Quick Access Toolbar Shortcut
    • (03:44) Datasheet or Design?
    • (03:25) Access Data Types
    • (05:25) Field Size Settings
    • (02:58) Date/Time Formats
    • (04:32) Custom Date/Time Formats
    • (05:57) Creating Our Tables
    • (03:05) Required Fields
    • (01:37) Deleting Rows
    • (03:30) Input Masks
    • (03:21) Setting the Field Size
    • (03:45) Default Values
    • (05:38) Allow Zero Length
    • (03:42) Renaming Fields & Tables
    • (05:15) Editing a Table
    • (05:57) Data Validation
    • (05:36) Adding an Index
    • (03:22) Deleting a Table
    • (02:38) Using Caption
    • (05:32) Using the Data Documenter
  • Relationships

    • (04:38) Determining Relationships
    • (05:12) Creating a Relationship
    • (05:57) Relationship Options
    • (02:58) Relationship Reports
  • Working with Datasheet View

    • (04:50) Using Auto Numbering
    • (04:13) Adding Data to the Table
    • (06:34) Using Data Lookups
    • (05:28) Datasheet View Basics
    • (04:04) Replacing Values
    • (02:43) Datasheet Formatting
    • (03:23) Filter By Form
    • (02:27) Freezing & Thawing
  • Accessing Your Data

    • (05:24) Query Basics
    • (04:44) Access & SQL
    • (05:33) Access 2010 Query Types
    • (04:28) Using the Query Wizard
    • (05:03) Using the Query Design View
    • (05:09) Writing Queries in SQL
    • (05:37) Total Queries
    • (05:18) Make Table Queries
    • (05:12) Action Queries
    • (05:56) Crosstab Queries
    • (04:48) Union Queries
    • (04:09) Top Queries
    • (06:40) Multi-Table Queries
    • (05:45) Understanding Query Joins
    • (03:20) Distinct Queries
  • Data Forms

    • (03:21) Access 2010 Forms
    • (03:59) Why Use Forms?
    • (03:21) Using AutoForm
    • (04:32) Using the Form Wizard
    • (06:44) Starting from Scratch
    • (05:07) Layout or Design View?
    • (03:00) Form Controls
    • (06:26) Adding Controls
    • (06:30) Using the Control Wizard
    • (04:22) Control Properties
    • (05:48) Using Combo Boxes pt. 1
    • (04:37) Using Combo Boxes pt. 2
    • (03:55) Navigation Form
    • (03:34) Setting the Tab Order
    • (03:25) Creating a Pop-up Form pt. 1
    • (04:20) Creating a Pop-up Form pt. 2
  • Access 2010 Reports

    • (05:04) Report Basics
    • (03:11) Report Types
    • (03:12) Reports the Easy Way
    • (05:57) Reports the Wizard Way
    • (04:34) Reports the Real Way
    • (04:20) Finding the Data
    • (04:35) Basic Report Design
    • (04:36) Sorting & Grouping Data
    • (05:15) Report Headers
    • (06:00) Group & Sum Totals
    • (04:21) Using Expressions
    • (06:38) Report Cosmetics pt. 1
    • (07:00) Report Cosmetics pt. 2
    • (04:48) Report Cosmetics pt. 3
  • External Data

    • (03:29) You Need It Where?
    • (06:41) Exporting Data
    • (06:14) Importing Data
    • (04:52) Linking to Data
    • (04:19) Linking Issues
  • Multi-user Access Applications

    • (04:37) Multi-User Application Basics
    • (04:04) Network Performance Issues
    • (03:23) Splitting the Database
    • (03:51) Pass-Through Queries
    • (06:35) Database Locking
  • More Cool Access Stuff

    • (02:53) Copying Tables
    • (04:23) Access Analyzer Tools
    • (01:29) Database Backups
    • (05:34) Pivot Tables & Charts
    • (05:48) Intro to Macros & Events
    • (06:22) Intro to VBA
  • Conclusion

    • (04:27) Course Wrap Up
  • Credits

    • (01:59) About the Author
Formateur : Mark Long
Langue : Anglais
Durée : 9
Nombre de séquences vidéo : 121
SKU : 34224
Réf :
ISBN : 1-936334-91-7
Date de publication : 2011-05-12
Compatibilité : Apple Mac OS X (PPC & Intel) | Windows XP, Vista, 7, 8
Formations compatibles iPad en VOD et via l'application TutoShop sur l'AppStore.

Descriptif :




Mark Long

Mark Long is a Microsoft Certified Trainer living in Nashville, Tennessee with his wife and daughter. Mark provides training and consulting services for organizations ranging from real estate agents to the country music industry. He began his career in the Information Technology field with South Central Bell (later BellSouth) where he worked for 18 years before starting his own training and consulting company.

+ 10 000 TUTOS EN VIDÉO
FORMEZ-VOUS EN ILLIMITÉ
SUR
VOD.TUTOROM.FR

A partir de 19€/mois seulement
Abonnez-vous