Office
 

Microsoft Access 2010 : Viewing a Sample Database & Creating a New Database

1/30/2012 5:37:04 PM

1. Viewing a Sample Database

One of the best ways to get a feel for using Access is to work with an existing database. The Northwind database, which you install along with Access, is a complete database with tables, queries, reports, and forms you can examine to see what goes into a solid database design.

1.1. Open a Sample Database

  1. Start Access 2010.

  2. Click Sample Templates.

  3. Click Northwind.

  4. Click Create.


Note:


The Northwind database contains a form that appears when you open the database. The form enables you to log in using different user accounts. If a database you create doesn’t include accounts for individual users, that form won’t appear.

2. Creating a New Database

If you want to create a new database from scratch, you can do so by creating a blank database and then adding your own tables and other objects. You can also create a new database based on an existing database, saving yourself lots of time and effort.

2.1. Begin a New Database

  1. Click the File tab.

  2. Click New.

  3. Click Blank Database.

  4. Type a name for your database.

  5. Click the folder icon.

  6. Navigate to the folder where you want to store the database.

  7. Click OK.

  8. Click Create.

2.2. Create a New Database Based on Another Database

  1. Open the database you want to use as a model and then click the File tab.

  2. Click Save Database As.

  3. Navigate to the directory where you want to save the new database.

  4. Type a different name for the new database.

  5. Click Save.


Note:


If you don’t type a new name for your database, you will just save the existing database, not create a new file.

 
Others
 
- Microsoft Access 2010 : Designing a Database
- Microsoft Outlook 2010 : Sending Text Messages from Outlook & Sending Mobile Alerts from Outlook
- Microsoft Outlook 2010 : Using Alerts and Mobile Features - Setting Up a Text Messaging Service
- Microsoft OneNote 2010 : Upgrading from a Previous Version
- Microsoft Word 2010 : Customizing Word - Changing Advanced Document Properties & Changing Research Options
- Microsoft Word 2010 : Customizing Word - Setting Advanced General Options & Setting Compatibility Options
- Microsoft Project 2010 : Setting Up Resources - Adjusting Working Time for Individual Resources
- Microsoft Project 2010 : Setting Up Resources - Entering Resource Pay Rates
- Microsoft Visio 2010 : Displaying the issues for the current selection
- Microsoft Visio 2010 : Displaying the rule for a selected issue
- Accessing PowerPoint on the Web and Mobile Devices (part 2) - Setting SkyDrive Permissions
- Accessing PowerPoint on the Web and Mobile Devices (part 1) - Setting Up SkyDrive
- Microsoft PowerPoint 2010 : Managing Themes
- Microsoft Excel 2010 : Printing in Excel - Adjusting Page Margins & Inserting Page Breaks
- Microsoft Excel 2010 : Setting the Print Area
- Microsoft Outlook 2010 : Setting Up Mobile Alerts for Important Messages
- Microsoft Outlook 2010 : Setting Up Calendar Alerts
- Microsoft OneNote 2010 : Searching for Stray Notes (part 2)
- Microsoft OneNote 2010 : Searching for Stray Notes (part 1)
- Microsoft PowerPoint 2010 : Managing Slide Masters
 
 
Most View
 
- Adobe Flash Professional CS5 : Manipulating Symbols in 3D Space (part 1) - Controlling the camera view: Perspective and vanishing point
- Adobe Flash Professional CS5 : Manipulating Symbols in 3D Space (part 2) - Transforming symbols with the 3D Rotation tool
- Mobile Web Apps : Loading Pages (part 3) - Going Backwards
- Microsoft Dynamics AX 2009 : Design and Implementation Patterns (part 1) - Class-Level Patterns
- Introducing the iPhone SDK (part 5) - Programming Paradigms
- Beginning Android 3 : Set Up the Emulator
- Microsoft Excel 2010 : Analyzing Worksheet Data - Adding Data Validation to a Worksheet
- Microsoft Dynamic CRM 2011 : Resolving a Service Request Case
- Accessing PowerPoint on the Web and Mobile Devices (part 1) - Setting Up SkyDrive
- Microsoft Excel 2010 : Using Print Preview