TAILIEUCHUNG - Getting Started with Open Office .org 3 part 26

Getting Started with Open Office .org 3 part 26. This Manual Book is for anyone who wants to get up to speed quickly with the latest version . “GETTING STARTED WITH ″ introduces all software programs of the OpenOffice bundle: Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector drawings), Math (equation editor) and Base (database). This book was written by volunteers from the community working through and is distributed under the CreativeCommon Attribution Licence | Figure 183 Example of Description entries Creating tables for the list box When the same information can be used in several fields design a table for each type of information. Each table will contain two fields the information field and ID in this order. Caution You must create these tables with the information field listed first and the and the ID field listed last. Failure to do so will produce the wrong results. For my Payment table I use Name and ID as my fields with Dan Kevin and Cash being the Name entries. The corresponding ID entries are 0 1 2. When the Name field is listed first in the table one of the three names will appear in the payment field of the Fuel table. If the ID field is listed first 0 1 or 2 appear in the payment field instead. 1 Follow the directions in Creating tables in Design View on page 248. In the table we will create the two fields can be Type and PaymentID. Make sure that the AutoValue is set to Yes for the PaymentID field. Set the PaymentID field as the primary key. See Figure 184. 2 Save the table using the name Payment Type. Chapter 8 Getting Started with Base 251 Field Name Field Type Type Text VARC HAR PaymentID Integer INTEGER Figure 184 Table in Design View Note If you have several tables to create with the same fields design one table and produce the other tables by cutting and pasting. See Creating a table by copying an existing table on page 247. Adding data to the list table List tables do not require a form. Instead add their data directly to the table. In this example use the names of the two people with a bank card and Cash for cash purchases. 1 In the main database window click on the Tables icon Figure 176 . Right-click on Payment Type and select Open from the context menu. a Enter Dan in the first row. Use the tab key to move to the second row. b Enter Kevin in the second row. c Enter Cash in the third row. 2 Save and close the table window. The Enter key can also be used to move from field entry to field entry. For

TỪ KHÓA LIÊN QUAN
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.