Microsoft Office Professional 2010 Step by Step eBook

Creating Databases and Tables Manually 803 On the Create tab, in the Tables group, click the Table button. Access creates a ne ...

804 Chapter 26 Create Databases and Simple Tables Database Design In a well-designed database, each item of data is stored only ...

Manipulating Table Columns and Rows 805 Manipulating Table Columns and Rows. In Chapter 25, “Explore an Access 2010 Database,” w ...

806 Chapter 26 Create Databases and Simple Tables You cannot adjust the height of a single row. On the Home tab, in the Records ...

Manipulating Table Columns and Rows 807 The Unhide Columns dialog box opens. You can select and clear check boxes to control whi ...

808 Chapter 26 Create Databases and Simple Tables Click the Phone field name to select that field. Then drag the field to the l ...

Refining Table Structure 809 This page has two parts. The top part consists of the following: ● Selector You can click the shade ...

810 Chapter 26 Create Databases and Simple Tables The Field Properties area at the bottom of the design page displays the proper ...

Refining Table Structure 811 Select the ZIP field name, change it to PostalCode, and then change its data type to Text. Tip If ...

812 Chapter 26 Create Databases and Simple Tables Click the State field. Then in the Field Properties area, click the Caption b ...

Creating Relationships Between Tables 813 With Field1 selected, type Title, and press Enter. Click the Title field name. Then i ...

814 Chapter 26 Create Databases and Simple Tables Less common relationships include: ● One-to-one In this type of relationship, ...

Creating Relationships Between Tables 815 Tip The coverage of relationships in this topic is deliberately simple. However, relat ...

816 Chapter 26 Create Databases and Simple Tables The Tables page of the Show Table dialog box. Troubleshooting If the dialog bo ...

Creating Relationships Between Tables 817 In the Customers field list, click CustomerID, and drag it down and over CustomerID i ...

818 Chapter 26 Create Databases and Simple Tables On the Design contextual tab, in the Relationships group, click the Show Tabl ...

Key Points 819 Key Points. ● Access 2010 includes templates to help you create databases and application parts to help you add r ...

Chapter at a Glance Create forms by using the Form tool, page 822 Change the look of forms, page 829 Change the arrangement of f ...

821 27 Create Simple Forms In this chapter, you will learn how to ✔ Create forms by using the Form tool. ✔ Change the look of fo ...

822 Chapter 27 Create Simple Forms In this chapter, you’ll discover how easy it is to create forms to view and enter information ...