Microsoft Access 2010 Step by Step (Step By Step (Microsoft))

Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include building an Access database from scratch or from templates; publishing your database to the Web; exchanging data with other databases and Microsoft Office documents; creating data-entry forms; using filters and queries; designing reports; using conditional formatting; preventing data corruption and unauthorized access; and other core topics. Contents 4 Introducing Microsoft Access 2010 10 Modifying the Display of the Ribbon 16 Features and Conventions of This Book 22 Using the Practice Files 24 Getting Help 26 Part 1. Simple Database Techniques 32 Chapter 1. Explore an Access 2010 Database 34 Working in Access 2010 35 Understanding Database Concepts 47 Exploring Tables 48 Exploring Forms 55 Exploring Queries 60 Exploring Reports 64 Previewing and Printing Access Objects 69 Key Points 74 Chapter 2. Create Databases and Simple Tables 76 Creating Databases from Templates 77 Creating Databases and Tables Manually 83 Manipulating Table Columns and Rows 92 Refining Table Structure 95 Creating Relationships Between Tables 100 Key Points 106 Chapter 3. Create Simple Forms 108 Creating Forms by Using the Form Tool 109 Changing the Look of Forms 116 Changing the Arrangement of Forms 124 Key Points 130 Chapter 4. Display Data 132 Sorting Information in Tables 133 Filtering Information in Tables 138 Filtering Information by Using Forms 142 Locating Information That Matches Multiple Criteria 146 Key Points 150 Chapter 5. Create Simple Reports 152 Creating Reports by Using a Wizard 153 Modifying Report Design 160 Previewing and Printing Reports 167 Key Points 170 Part 2. Relational Database Techniques 172 Chapter 6. Maintain Data Integrity 174 Restricting the Type of Data 175 Restricting the Amount of Data 180 Restricting the Format of Data 182 Restricting Data by Using Validation Rules 190 Restricting Data to Values in Lists 198 Restricting Data to Values in Other Tables 203 Key Points 208 Chapter 7. Create Custom Forms 210 Modifying Forms Created by Using a Wizard 211 Adding Controls 218 Adding Subforms 227 Using E-Mail Forms to Collect Data 236 Key Points 238 Chapter 8. Create Queries 240 Creating Queries by Using a Wizard 241 Creating Queries Manually 247 Using Queries to Summarize Data 252 Using Queries to Perform Calculations 255 Using Queries to Update Records 262 Using Queries to Delete Records 266 Key Points 270 Chapter 9. Create Custom Reports 272 Creating Reports Manually 273 Modifying Report Content 278 Adding Subreports 285 Key Points 292 Part 3. Database Management and Security 294 Chapter 10. Import and Export Data 296 Importing Information 297 Exporting Information 313 Copying to and from Other Office Programs 323 Key Points 326 Chapter 11. Make Databases User Friendly 328 Creating Navigation Forms 329 Creating Custom Categories 336 Controlling Which Features Are Available 340 Key Points 344 Chapter 12. Protect Databases 346 Assigning Passwords to Databases 347 Splitting Databases 351 Securing Databases for Distribution 354 Preventing Database Problems 359 Key Points 364 Chapter 13. Customize Access 366 Changing Default Program Options 367 Customizing the Ribbon 377 Customizing the Quick Access Toolbar 382 Key Points 386 Glossary 388 Keyboard Shortcuts 394 General Shortcut Keys 394 Keys for Working with Text and Data 402 Keys for Navigating Records 405 Keys for Working with the Ribbon 418 Keys for Working with Online Help 419 Keys for Basic Office Tasks 420 Index 424 Symbols 424 A 424 B 425 C 425 D 427 E 428 F 429 G 431 H 432 I 432 K 433 L 433 M 434 N 434 O 435 P 435 Q 436 R 437 S 439 T 441 U 442 V 442 W 442 X 443 Y 443 Z 443 About the Authors 446 Offers hints and troubleshooting guidelines to help users navigate the user interface, create a database, produce forms and queries, filter data, customize a database, and use VBA to create Web pages based on data.