Detail Spreadsheet, Meet Database ; Database, Meet Spreadsheet   Oleh:  Haase, F. Philip Jenis: Article from Bulletin/Magazine Dalam koleksi: Journal of Accountancy vol. 188 no. 6 (1999), page 33-42. Topik: database; spreadsheet; database Ketersediaan Perpustakaan Pusat (Semanggi) Nomor Panggil: JJ85.9 Non-tandon: 1 (dapat dipinjam: 0) Tandon: tidak ada     Lihat Detail Induk Isi artikel Just as two heads are better than one, so are two software applications working together. In tandem, some programs can do things that are hard, if not impossible, to do when they’re running alone. That’s why software suites - a collection of cooperative applications - can boost office productivity. To demonstrate the power of office suites as a way to encourage you to broaden your technical skills, this article will show you how to take database information and link it to a spreadsheet’s supercalculation power so you can better interpret data. While the process may appear difficult - and even a bit esoteric - it’s actually quite easy to do. Once you learn the technique, you’ll find it a versatile and practical tool. The fundamental job of a database application is to warehouse informatio - especially diverse information - and then enable users to access and reconfigure it in nearly any customized order. Although spreadsheets can do that job, too, they can’t do it quite as well or as easily as databases. But then, a spreadsheet isn’t a database; it’s a robust, multifaceted calculator and data analyzer that incidentally can perform some database functions. So linking the two applications produces one powerful tool. Microsoft’s finance department applies this same technology to post its financial information to both its staff and to the public ; see “Accounting - The Digital Way,” JofA, May99, page 99. In this tutorial, functions of a Microsoft Access database and Excel PivotTable are paired. (For more information about using the PivotTable, see “Add Perspective to Spreadsheets,” JofA, Dec.98, page 91). Opini Anda Klik untuk menuliskan opini Anda tentang koleksi ini! Kembali

Copyright © 2006, 2007 Unika Atma Jaya, all rights reserved