- 4/22/2008 11:32:00 AM - 0 comments

Lynda - Access 2003 Essential Training



Access 2003 Essential Training with Mark Swift is a movie-based tutorial that will enable new and existing database designers to develop an understanding of the latest version of Microsoft Access. This training begins with an introduction to database concepts and a design methodology that will help new designers organize the data being stored, and quickly advances to cover many of the features and tools needed to design exceptional database applications. This training also looks at features that are new or improved in Microsoft Access 2003. Exercise files are included, allowing you to follow along and learn at your own pace.

Introduction
    
       
           welcome          0:25    4.4 MB   
  
    
1. Database Fundamentals
    
       
           what is a database?          2:09    4.6 MB   
     
           understanding database design          2:11    1.7 MB   
     
           system overview          4:03    3.9 MB   
     
           analyze current system          1:53    1.3 MB   
     
           define data elements          11:16    10.5 MB   
     
           normalization          7:41    7.3 MB   
     
           establish relationships          8:09    11 MB   
     
           testing and review          2:11    1.7 MB   
     
           naming conventions          4:03    3.6 MB   
  
    
2. The User Interface
    
       
    exploring the interface    2:33    2.2 MB   
  
    
3. Creating Databases
    
       
    creating a new database    6:23    6.7 MB   
     
    Office Online    2:36    4.5 MB   
  
    
4. Creating Tables
    
       
    creating tables    5:36    7.5 MB   
     
    design view    3:52    4 MB   
     
    the table wizard    4:48    5.7 MB   
     
    tables by inputting data    4:31    4.2 MB   
     
    data types    13:31    15.1 MB   
     
    setting field properties    15:24    15.4 MB   
     
    propagating field properties    1:09    1.1 MB   
     
    object descriptions    1:53    1.9 MB   
  
    
5. Working with Table Records
    
       
    editing records    5:18    4.7 MB   
     
    display settings    7:05    8 MB   
     
    the find feature    2:35    2.6 MB   
     
    sorting and filtering    3:47    3.4 MB   
     
    copying tables    2:32    2.9 MB   
  
    
6. Creating Relational Databases
    
       
    keys    11:15    12.6 MB   
     
    table relationships    17:34    18.5 MB   
     
    object dependencies    2:07    2.2 MB   
  
    
7. Using Select Queries
    
       
    what are queries?    2:07    1.8 MB   
     
    creating select queries    8:24    7.8 MB   
     
    using the query wizard    4:34    4.9 MB   
     
    working with results    0:21    0.45 MB   
     
    query criteria    3:55    4 MB   
  
    
8. Calculations in Your Queries
    
       
    performing calculations    9:44    11.9 MB   
     
    duplicate records    2:00    1.9 MB   
  
    
9. Creating Forms and Controls
    
       
    AutoForm    3:19    3.6 MB   
     
    form wizard    2:51    3 MB   
     
    working with controls    14:54    27.7 MB   
     
    control properties    7:04    10.8 MB   
     
    form properties    1:36    2.7 MB   
     
    printer forms    0:35    1 MB   
     
    adding a subform    2:16    3 MB   
     
    adding headers & footers    1:16    1.7 MB   
  
    
10. Creating and Using Reports
    
       
    AutoReport    2:57    4.6 MB   
     
    using the report wizard    4:01    5.9 MB   
     
    report sections    1:41    3.1 MB   
     
    controls & properties    4:04    7.2 MB   
  
    
11. Enhancing Forms and Reports
    
       
    using AutoFormat    1:58    3.1 MB   
     
    special effects    1:41    2.7 MB   
     
    opening a form on startup    2:10    2.3 MB   
     
    adding graphics    2:29    3.1 MB   
     
    AutoCorrect & error checking    1:29    1.6 MB   
     
    switchboards    5:10    6.1 MB   
  
    
12. Working with External Data
    
       
    exporting data    1:38    2.3 MB   
     
    importing external data    3:57    4.8 MB   
     
    linking to external data    3:05    3.8 MB   
  
    
13. Adding Security
    
       
    passwords    4:50    5 MB   
     
    encryption & decryption    1:41    2 MB   
     
    using the security wizard    9:29    13.8 MB   
  
    
14. Access and the Web
    
       
    dynamic vs. static data    3:05    3.6 MB   
     
    data access pages    1:44    1.9 MB   
     
    hyperlinks    2:08    3.6 MB   
     
    importing & linking html    3:07    4.3 MB   
  
    
15. Speed Up a Database Application
    
       
    modules & call trees    3:31    3.7 MB   
     
    tuning your computer    1:51    1.8 MB   
     
    repair - when it's useful    3:16    3.1 MB   
     
    backing up    1:14    1.3 MB   
  
    
Conclusion
               
goodbye    0:13    2.2 MB



More info : http://movielibrary.lynda.com/html/modPage.asp?ID=98

Download:


http://rapidshare.com/files/17159939/lnd-ma2k3.exe
http://rapidshare.com/files/17161464/lnd-ma2k3.rar.1
http://rapidshare.com/files/17163031/lnd-ma2k3.rar.2
http://rapidshare.com/files/17163882/lnd-ma2k3.rar.3

0 Responses to "Lynda - Access 2003 Essential Training"

Post a Comment