Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Overview
Create tables as you type  

Learn how to enter data in Access quickly and easily — just a few mouse clicks — with the new design features in Datasheet view. Go on, explore!

Don’t have the 2007 Office release? You can download a free 60-day trial or buy it now.

  • Length: 30–40 minutes
 


GOALS

After completing this course you will be able to:

  • Create a new, blank database with a new table.
  • Enter data in the new table.
  • Set or change field (column) names.
  • Set and change data types, settings that help you enter the correct type of data in each column.
 
ABOUT THIS COURSE

This course includes:

  • One self-paced lesson and one practice session for hands-on experience. The practice requires Access 2007. You can't use a previous version of Access to complete this course.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.
AUDIO TEXT

If you're familiar with Excel, you know how easy it is to get started entering data. You open a worksheet, click a cell, and start typing.

You can do the same thing in Access. You create a new database and enter data in a table — the component in a database that stores your data. If you're new to Access, tables are the backbone of any database.

This course explains how to create a new database, enter data in a table, and set each column in that table to accept a specific type of data. It's fast and it's easy, so don't let databases intimidate you.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

  Go to previous page (disabled)    Next Go to next page
advertisement