Part I: Access Building Blocks
88
- Open the other Access database and choose Edit Paste from the shortcut menu, or click
the Copy button in the Clipboard group on the Home tab. - Provide the name of the new table and choose one of the Paste options (Structure
Only, Structure and Data, or Append Data to Existing Table). - Click OK to complete the operation.
Adding Records to a Database Table
Adding records to a table is as simple as clicking the table in the Navigation Pane to open the table
in Datasheet view. Once the table is opened, enter values for each field. Figure 2.33 shows adding
records in datasheet mode to the table.
You can enter information into all fields except CustomerID. AutoNumber fields automatically
provide a number for you.
FIGURE 2.33
Using Datasheet view to add records to a table
New record
Although you can add records directly into the table through the Datasheet view, it isn’t the most
efficient way. Adding records using forms is better because code behind a form can dynamically
provide default values (perhaps based on data already added to the form) and communicate with
the user during the data entry process.
Understanding Attachment Fields
Microsoft recognizes that database developers must deal with many different types of data.
Although the traditional Access data types (Text, Currency, OLE Object, and so on) are able