Microsoft Access 2010 Bible

xxxix Introduction How This Book Is Organized This book contains 38 chapters and three appendixes, divided into seven parts. Par ...

xl Introduction The techniques in Part III would normally take most Access developers several years to master. I’ve carefully se ...

xli Introduction Part VII: Appendixes The last part contains three appendixes. Appendix A documents the Access 2010 specificatio ...

xlii Introduction The main Switchboard menu When you load the completed example file (CollectibleMiniCars.accdb), you’ll see the ...

xliii Introduction The diagram in Figure FM.2 displays the table schema in the Collectible Mini Cars example. As you’ll learn in ...

xliv Introduction Cross-Reference You learn more about relational database theory and how to build tables in Part I of this book ...

xlv Introduction FIGURE FM.3 The Collectible Mini Cars Products form, which allows data entry for all products in inventory The ...

xlvi FIGURE FM.4 The Collectible Mini Cars Invoice form used to show multiple linked subforms and totals Introduction 03_475348- ...

Part I Access Building Blocks IN THIS PART Chapter 1 An Introduction to Database Development Chapter 2 Creating Access Tables Ch ...

04_475348-pp01.indd 204_475348-pp01.indd 2 4/1/10 1:43 PM4/1/10 1:43 PM ...

3 CHAPTER An Introduction to Database Development IN THIS CHAPTER Examining the differences between databases, tables, records, ...

Part I: Access Building Blocks 4 On the CD-ROM All the examples presented in this chapter can be found in the sample database Co ...

Chapter 1: An Introduction to Database Development .................................................................... 5 from m ...

Part I: Access Building Blocks 6 Tables A table is just a container for raw information (called data), similar to a folder in a ...

Chapter 1: An Introduction to Database Development 7 After you create a table, you view the table in a spreadsheet-like form, ca ...

Part I: Access Building Blocks 8 Records and fields As Figure 1.2 shows, the datasheet is divided into rows (called records) and ...

Chapter 1: An Introduction to Database Development 9 Multiple tables simplify data entry and reporting by decreasing the input o ...

Part I: Access Building Blocks 10 Access Database Objects If you’re new to databases (or even if you’re an experienced database ...

Chapter 1: An Introduction to Database Development 11 Instead of asking the question in English words, a person uses the query b ...

Part I: Access Building Blocks 12 Data-entry forms restrict access to certain fields within the table. Forms can also check the ...