Microsoft Office 2003 Super Bible phần 4

Bạn có thể nhanh chóng chuyển đổi một danh sách số một danh sách gạch đầu dòng bằng cách chọn trong danh sách được đánh số và sau đó nhấp nút Bullets trên thanh công cụ định dạng, và ngược lại. | Chapter 8 Understanding and Creating Access Reports 169 Columnar reports Columnar reports also known as form reports generally display one or more records per page but do so vertically. Columnar reports display data very much as a data-entry form does but the report is used strictly for viewing data and not for entering data. Figure 8-2 is part of a typical columnar report from the Access Auto Auctions database system in the Print Preview window. PRODUCTS Access Auto Ajcticris Pnứacl uforntaft if vt K u CAR-001 O npaon ZJDiSpontf Auction csteeory Car AX ton Bvj ot . Vildan QianBt. in Stock 1 Aixton T p i 0i-SI O0 -lk I Coif Í32Í66ŨD hltr CkdyCSfey Ik tall ftlc . c- k M iota 123 Sox Sc-ox IM RTC IwijM NH 12J01- T nW Fnlru 9 1 1 s a 1 Hit H 1 3 Figure 8-2 A columnar report showing report controls distributed throughout the entire page. Another type of columnar report known as a form subform report generally displays one main record per page like a business form but can show many records within embedded subforms. An invoice is a typical example. This type of report can have sections that display only one record and at the same time have sections that display multiple records from the many side of a one-to-many relationship and even include totals. 170 Part I Getting Functional with Office 2003 Figure 8-3 shows an invoice report from the Access Auto Auctions database system in the Print Preview window. Access Auto Auctions Bringing Out the Adventure m Allot Us 19F 200 Northern Ave Bristol CT 06010 860-555-2233 04-5523698 INVOICE 4 Invoice Odle 2 3 2003 sde Date 1 1520 03 Page 1 of 53 BUYER John Jones Nopa Alio Parts 11253 Main Street Springfield. MA 413 1 PAYhE NT w THOD SALESPERSON VE HICLE LOCATION N Check JJotn Jones _an der PA Product 0 v OcBcripton Price Disc Tai Amout i ĨRK-207 1 2003 Fordman T-150 Regular Cais 20 40000 10 00 0 18 36000 TRK-100 1 i960 Chevy Pickup 6 50000 500 0 6 17500 CAR-002 1 1957 Chevy Sedan 21 .