Datasheets I: Create a table by entering data

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!

Start course button

About this course

This course includes:

  • 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 Quick Reference Card you can take away from the course.


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.

Topics in this course

  1. You type, Access listens

  2. Easy data entry

  3. What's in a name?

  4. A quick look at data types

  5. Data types, automatically

  6. But not all the data types

  7. And you can change data types as needed

  8. Practice

  9. Quick reference card

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!