Share this Page URL

Chapter 1. The HelloWorld Database > On Your Own - Pg. 28

The HelloWorld Database 28 The simple, four-field database we created in this chapter serves as a departure point for the rest of the book. In this chapter, you used several of the windows and tools you'll work with when you create a database in Access. We covered the basics of creating a table, adding fields to that table, and defining the characteristics of the fields--their data types and properties. We also saw examples of the sort of work Access helps you with--using a wizard to build a form and design a simple query. At the end, we saw how you can modify a form the wizard creates and how with relative ease you can add Visual Basic code to automate the operations an Access database and its objects perform. Q&A Q1: A1: You said I can print a report. Can I print a form to review data if I need to? Yes, you can print forms, but the results you get are often unsatis- factory. Reports are designed for printing, so you're better off cre- ating a report and printing it if you need to review a hard copy of your data. If queries function like tables, can I enter data into a query? Yes, in some situations you can enter data into a query using the query's Datasheet view. You'll probably find that using forms for data entry is easiest. Can I use a numbering system of my own as a primary key field rather than an AutoNumber field? Yes, as long as each record is uniquely identified. You could use part numbers or other identifying data (such as a U.S. social security Q2: A2: Q3: A3: