Microsoft Access
  Home arrow Microsoft Access arrow Page 2 - Getting to Know MS Access 2003
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Mobile Linux 
App Generation ROI 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MICROSOFT ACCESS

Getting to Know MS Access 2003
By: Sage Adams
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 27
    2004-10-25

    Table of Contents:
  • Getting to Know MS Access 2003
  • Open a File, Explore the Sample Database
  • Objects: Tables, Queries, Forms and More
  • Using Help

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Getting to Know MS Access 2003 - Open a File, Explore the Sample Database


    (Page 2 of 4 )

    The My Recent Documents folder, located on the left of the Open File dialog box, is used to access databases you have worked on recently. The Files of type menu, at the bottom of the dialog box, allows you see types of files other than the typical Microsoft Office Access file types, which can sometimes be advantageous. You may also choose to search for a file if you don’t know what it is called. To do this, select the arrow next to the word ‘Tools’, in the upper-right corner of the dialog box, and select ‘Search’ from the resulting menu.

    Assuming you don’t currently have a database created in Access, you can use the Northwind sample database that comes with Access 2003, to explore the capabilities of the software. The Northwind sample database is typically located in the following folder:

    C:\Program Files\Microsoft Office\Office\Samples

    Double-click the sample database in the \Samples folder to open the Northwind database. Alternatively, you can open the Northwind database by selecting it from the Help | Sample Databases | Northwind Sample Database menu.

    When opened, Northwind displays a welcome screen – you’ll learn how to make these in a later lesson. For now, click the Display Database Window button, in the welcome screen, to get rid of the welcome screen, and to display the Database window. Your screen should now look similar to the following:

    Getting to Know MS Access 2003

    See that little window inside your main window? That is, for all intents and purposes, the database. Let’s quickly review what’s in the Database window. It has a title and it has standard windows buttons to maximize, minimize, or close the window. It’s also got several buttons in a toolbar that includes a button to open an extant object, a button to create new objects, and a button to delete extant objects. Finally it’s got several options for changing the views of the objects on the screen. Click each of the views to see which one you like best; I prefer the list view.

    The Database window consists of multiple ‘pages’. You display a page by clicking the appropriate object button listed underneath the Objects title button. When opened, each object page replaces the current object page you are viewing.

    More Microsoft Access Articles
    More By Sage Adams


       · good for newbies completely useless in bringing anything new to people who want to...
       · I found de Sample Database in:C:\Program Files\Microsoft...
     

    MICROSOFT ACCESS ARTICLES

    - Linking SQL Express 2005 Tables to MS Access...
    - Working with Access Projects in Access 2007
    - Exploring Access 2007
    - Working with Stored Procedures in an MS Acce...
    - Creating and Using Action Queries
    - Creating Data Access Pages with Charts using...
    - Advanced Ideas using VBA
    - VBA Details
    - Updating Records in MS Access
    - Using ADO`s Record Object with URLs
    - Exporting XML from MS Access 2003
    - Importing XML into MS Access 2003
    - On Using Pass-through Queries in MS Access
    - Distributed Queries in MS Access
    - Configuring a Linked Microsoft Access Server...





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
    Stay green...Green IT