Tham khảo sách 'microsoft® office access 2007 forms, reports,and queries', công nghệ thông tin, tin học văn phòng phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Contents at a Glance Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 I Creating Forms 1 Creating and Using a Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2 Working with Form Controls . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 3 Designing Forms for Efficient and Accurate Data Entry . . . . . . . . . . . 49 usinesssolutions 4 Designing Forms for Business Use . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77 ? 5 Creating Specialized Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95 II Designing and Customizing Reports 6 Creating and Publishing a Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113 7 Designing Effective Business Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141 8 Designing Advanced Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 ® 9 Creating Specialized Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177 Microsoft Office III Creating Powerful Queries 10 Creating a Basic Query . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199 11 Building Criteria Expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 231 Access 2007 Forms, 12 Working with Multiple-Table Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259 13 Creating Advanced Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 287 14 Creating PivotTable Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 311 Reports,and 15 Querying with SQL Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 341 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
