Teach Yourself MS Office 2003 In 24 Hours Free Open Book

Teach Yourself MS Office 2003 In 24 Hours

Previous Section Next Section

Looking at Access

When you start Access, you'll see a screen that looks similar to Word, as Figure 17.3 shows. The New File task pane provides you with links you can use to create a new database or load an existing database. As with Word and Excel, Access supports the use of template files on which you can base new database files that conform to a predetermined pattern.

Figure 17.3. The Access screen is empty when you launch Access from the Start menu.

graphics/17fig03.jpg

Here are the fundamental steps you follow most of the time when you want to work with Access:

  • Open an existing database so that you can modify the database structure or work with the database information. Select a database from the list or click the More option to browse a list of existing database files. The section of the New File task pane where you open an existing database is labeled Open.

  • Create a new database, which requires that you manually set up the entire database structure, including tables, fields, and other pertinent database-structure information. You can also create a more advanced database project, which creates a database system that runs in a networked client/server workspace where the Access database might transfer data to multiple workstations attached to the server. The section of the New File task pane where you create a blank database is labeled New.

  • Create a new database that is a copy of an existing database. The New File task pane contains the section for creating a new database file from an existing one. You can get to this option by selecting More. This New File task pane option in effect makes a copy of an existing database file.

  • Create a database file based on a template. Access provides templates that create sample blank databases that track data such as asset management, expenses, and inventories. Microsoft provides additional templates on the Web as well.

    Previous Section Next Section
    Index: [SYMBOL][A][B][C][D][E][F][G][H][I][J][L][M][N][O][P][Q][R][S][T][U][V][W][X][Z]


         Main Menu
    Main Page
    Table of content
    Copyright
    About the Author
    Acknowledgments
    We Want to Hear from You!
    Introduction
    Part I: Working with Office 2003
    Part II: Processing with Word 2003
    Part III: Computing with Excel 2003
    Part IV: Presenting with Flair
    Part V: Organizing with Outlook 2003
    Part VI: Tracking with Access 2003
    Hour 17. Access 2003 Basics
    Database Basics
    Looking at Access
    Creating a Database
    Summary
    Q&A
    Hour 18. Entering and Displaying Access 2003 Data
    Hour 19. Retrieving Your Data
    Hour 20. Reporting with Access 2003
    Part VII: Combining Office 2003 and the Internet
    Part VIII: Publishing Eye-Catching Documents
    Part IX: Appendixes
    Part X: Bonus Hours
    Index


    More Books
    PHP Hacks
    Processing Xml With Java - A Guide To Sax, Dom, Jdom, Jaxp, And Trax
    The Koran (Holy Qur'an)
    Macromedia Flash 8 Bible
    Search Engine Optimization for Dummies
    YouTube Traffic
    PHP 5 for Dummies
    Harry Potter and The Chamber of Secrets
    Harry Potter and the Sorcerer's Stone
    The Pilgrim's Progress
    Wireless Hacks
    Flash Hacks. 100 Industrial-Strength Tips & Tools
    PayPal Hacks. 100 Industrial-Strength Tips and Tools
    Amazon Hacks
    Pdf Hacks
    The Da Vinci Code
    Google Hacks
    The Holy Bible
    Windows XP For Dummies
    Harry Potter and the Half-Blood Prince
    Seo Book
    Upgrading and Repairing Networks
    Macromedia Dreamweaver 8 UNLEASHED
    Windows XP Annoyances
    Windows XP Hacks
    Microsoft Windows XP Power Toolkit
    Teach Yourself MS Office In 24Hours
    iPod & iTunes Missing Manual
    PC Hacks 100 Industrial-Strength Tips and Tools
    PC Overclocking, Optimization, and Tuning - 2th Edition
    PC Hardware In A Nutshell 3rd Edition
    PC Hardware in a Nutshell, 2nd Edition
    Upgrading and Repairing PCs
    Google for Dummies
    MySQL Cookbook
    Teach Yourself Macromedia Flash 8 In 24 Hours
    PHP CookBook
    Sams Teach Yourself JavaScript in 24 Hours
    PHP5 Manual
    Free Games Paper Airplanes
    500 Juegos Gratis 500 Giochi Gratis 500 Jeux Gratuits 500 Jogos Gratis 500 Kostenlose Spiele