Microsoft Access 2010 Bible

Chapter 1: An Introduction to Database Development 13 FIGURE 1.4 The five-step design flowchart. This design methodology is part ...

Part I: Access Building Blocks 14 The five-step design method shown in Figure 1.4 helps you to create the system that you need, ...

Chapter 1: An Introduction to Database Development 15 include every bit of data managed by an application. Because reports tend ...

Part I: Access Building Blocks 16 FIGURE 1.6 A sales invoice report containing sales information Step 3: Data design The next st ...

Chapter 1: An Introduction to Database Development 17 Customers Report Invoice Report ZIP Code ZIP Code Phone Numbers Phone Numb ...

Part I: Access Building Blocks 18 TABLE 1.2 (continued) Invoice Report Line Item Data Product Purchased (multiple lines) Product ...

Chapter 1: An Introduction to Database Development 19 Step 4: Table design Now for the difficult part: You must determine what f ...

Part I: Access Building Blocks 20 Consolidating and comparing data is a good way to start creating the individual table definiti ...

Chapter 1: An Introduction to Database Development 21 The field that uniquely identifies each row in a table is the primary key. ...

Part I: Access Building Blocks 22 Taking time to properly design your database and the tables contained within it is arguably th ...

Chapter 1: An Introduction to Database Development 23 In this book, you create several basic data-entry forms: l Clusters: Conta ...

...

25 CHAPTER Creating Access Tables IN THIS CHAPTER Introducing Microsoft Access Opening a new database Getting acquainted with th ...

Part I: Access Building Blocks 26 FIGURE 2.1 The opening Access screen provides a number of ways to start working with Access. T ...

Chapter 2: Creating Access Tables .............................................................................................. ...

Part I: Access Building Blocks 28 FIGURE 2.2 The File menu contains many important commands. File button Quick Access Toolbar Pi ...

Chapter 2: Creating Access Tables 29 FIGURE 2.3 The new database screen provides many options for creating Access databases. Bla ...

Part I: Access Building Blocks 30 FIGURE 2.4 Enter the name of the new database in the File Name box. Browse button Default data ...

Chapter 2: Creating Access Tables 31 FIGURE 2.5 The new MyCollectibleMiniCars database is created. Note Access 2010 recognizes a ...

Part I: Access Building Blocks 32 Access 2010 works directly with Access 2000, 2002–2003, and Access 2007.accdb databases. Earli ...