1. Technology

Video:Microsoft Access: Create a Database From Scratch

with Nick Flegg

Creating a database from scratch may seem daunting, but it doesn't have to be. In this About.com video, learn how to create your own database in Microsoft Access 2010.See Transcript

  • All Videos
  • All Technology Videos
  • Databases Videos

Transcript:Microsoft Access: Create a Database From Scratch

Hi, I'm Nick and today for About.com, I'm going to show you how to create a blank database in Microsoft Access 2010.

Microsoft Access comes with a number of pre-built templates, but sometimes, you might want to start completely from scratch, using your own design.

Create Your Own Design in Microsoft Access 2010

To do this, open Access and choose the Blank Database option, in the Available Templates section of the home screen.

On the right hand side of the screen, you'll be able to give your new database a name, as well as select the save destination of the file, by clicking the folder icon next to the text box. Choose an appropriate save location for your database and then click the OK button to continue. Now, all you need to do is press the Create button to get started with your new database.

Insert Information in Microsoft Access 2010

Your new database will open with a basic table already open, so you can start entering information immediately by clicking on the columns in your table and defining their format, or by clicking on blank cells and entering the data that you want to be inserted into your table.

Before you get too far into your database, you'll want to save your table, so head to the save icon at the top left of the screen and then give your table a name in the 'Save As' window that appears. When you're happy, click 'OK' and your table will be saved.

Add Tables in Microsoft Access 2010

If you need to add more tables, or functions such as queries or forms, you can head to the 'Create' menu in the ribbon.  Anything you add here will be added to your database. You can switch between these new elements by double-clicking on their name in the Navigation Pane on the left hand side of the screen. You can also click the tabs directly above your table to switch between them quickly.

Now you know how to create a blank database in Microsoft Access 2010. For more Access help, including how to create a database using a template, be sure to visit About.com.

About videos are made available on an "as is" basis, subject to the User Agreement.

©2014 About.com. All rights reserved.