Skip to Main Content
Office 2021 All-in-One For Dummies
book

Office 2021 All-in-One For Dummies

by Peter Weverka
February 2022
Beginner content levelBeginner
800 pages
19h 1m
English
For Dummies
Content preview from Office 2021 All-in-One For Dummies

Chapter 3

Entering the Data

IN THIS CHAPTER

Bullet Entering data on a datasheet

Bullet Changing the look of a datasheet

Bullet Creating a form for entering data

Bullet Finding and replacing your data

At last — you can start entering the data. If you set up your database tables, named the fields, and established relationships between the tables, you’re ready to go. This short chapter explains how to enter the data in a database table. It shows you how to enter data on a datasheet or enter data by way of a form. This chapter also describes how to find missing records in case one goes astray.

There’s no getting around it: Entering data is truly a tedious activity. But if you set up the fields well and take advantage of input masks and other field properties, it isn’t so bad. It’s better than stepping on a shovel blade, anyway.

The Two Ways to Enter Data

When it comes to entering data in a database table, you can take your pick between Datasheet view and a form. Figure 3-1 compares and contrasts the two. Here are the advantages of entering data in Datasheet view:

  • Many records appear simultaneously.
  • You can ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Office 2021 for Macs For Dummies

Office 2021 for Macs For Dummies

Bob LeVitus, Dwight Spivey
Microsoft Office 2021 – Das Handbuch

Microsoft Office 2021 – Das Handbuch

Rainer G. Haselier, Klaus Fahnenstich
The Frictionless Organization

The Frictionless Organization

Bill Price, David Jaffe

Publisher Resources

ISBN: 9781119831419Purchase Link