Share this Page URL

Part I: Getting Started - Pg. 1

1 Part I. Getting Started For people who haven't worked with Microsoft Access before and for people who want to learn more about the requirements and benefits of building a database, the first three chapters in Part I of this book introduce you to most of the basic features of Access, describe the foundations of an Access database, and provide background information that will inform many of the decisions you make as you plan and design a database. You'll learn, for example, about how you can structure an Access database as a single database file or as linked files, which provide advantages when the database will be used by more than one person. You'll learn how to join one database table with another so that you can display related data in a single view. You'll also gain plenty of hands-on experience with Access as well, creating tables and defining the fields the tables contain and using some of the wizards that Access provides to help you accomplish the tasks you need to get done. In Chapter 4, "Importing and Linking to Data you'll learn about one of the ways you can get data into an Access database-importing the data from a spreadsheet, a text file, or from other formats-and how to make the data in another database available to the database you're working with. Finally, in the last chapter in this part, Chapter 5, "Using Visual Basic to Automate Your Database you'll dis- cover how, with little difficulty, you can program an Access database to perform operations auto- matically.