ExcelZone Compendium: Working with external data (Excel 2007 update) Sep 24, 2008
For example, you can drag an entire Access database table or query into an Excel spreadsheet, or use copy and paste. If you just want some of the records, or some of the fields, then you can open the table or query, select all or some of the rows and columns and copy and paste again. (Accounting Web, UK)
Coghead clicks for non-coders Sep 23, 2008
If you improve a customer contact entry form by inserting a new pull-down menu for favorite baksheesh, a nice column for baksheesh appears in the database table holding the information on all of the customers. It's all automatic. (InfoWorld)
Internet accounting's third wave - ERP as a service Jun 6, 2008
ZDNet's examined Workday's approach to handling financial transactions as entries in a ledger database table, Workday's object model design makes the accounting treatment a property that is attached to a particular item - effectively a status flag. "The bookkeeping happens without impacting how the system stores that information," Wainewright explained. (Accounting Web, UK)
Who Gives the Most Jan 25, 2008
A Big Year for Big Giving - Philanthropy. " Last year the university received pledges from two donors on the list, $100-million from the businessman David H. Koch (No. 14 on The Chronicle's list) and $31-million from Irwin M. Jacobs, a telecommunications entrepreneur, and his wife, Joan (tied for No. 40). Led by William Barron Hilton's pledge of $1.2-billion to the Conrad N. Hilton Foundation, in Reno, Nev., donors on the list committed $7.3-billion to charity last year. In 2006, donors made... (The Chronicle of Philanthropy)
Web Services with Ruby on Rails Nov 28, 2007
One custom model class is created for each database table, drawing the names from the table to create the access methods. The RoR tools provide Ruby scripts which can generate source code skeletons for model classes automatically. (Search Webservices)
Astoria: REST Web services extensions from Microsoft Oct 17, 2007
Astoria uses what is known as an , a mechanism that simplifies the way in which a data object or relational database table is exposed as a REST service, and in the process enforces a more intuitive structure to access such data as a service. Take a look at the following listing which illustrates a piece of an Astoria based service. (Search Webservices)
XMLfiles.com Aug 16, 2007
Using this type of technique we're actually creating a data construct similar to a database table. by Michael Qualls This article builds upon the Saving HTML Form Data to XML article. (IntranetJournal)
IBM, Microsoft Show Web 2.0 Wares Jun 20, 2007
"It's a lot more than getting data in a certain format. You want to transform it. If it's just one set of data in a database table available as a feed that's pretty straightforward. But what happens if you browse around the Internet today to different feeds available? There isn't a lot of consistency; data is very ad hoc in the public Internet. Should users sort it? Shift it? Validate it? That's kind of what we are managing to do" with Info 2. 0, she said. (eWeek)
Excel compendium - importing and exporting. By Simon Hurst May 31, 2007
Alastair Harris championed the use of VB but also pointed out how to import a text file into an Access database table. Within an Access database, select the Tables section and then choose the File-Get External Data option. (Accounting Web, UK)
Unsure what properties your fields should have? Let Access 2007's field list set them for you May 8, 2007
One of the most difficult things about designing a database table is setting the field properties. To make it easier, Access 2007 has already designed a number of common fields for you; you simply pick the ones you want from the field list. (TechRepublic)
A Bright Outlook for Giving Apr 2, 2007
The Chronicle, 4/5/2007: Foundation Assets Grow Sharply. " What's more, several foundations said they are less susceptible to big investment losses today because they have diversified their stock portfolios. For example, the W.K. Kellogg Foundation, in Battle Creek, Mich., last year reduced its holdings in the Kellogg Company to 66 percent of the grant maker's total assets. Previously, it held 80 percent of its assets in the cereal maker. And the Lilly Endowment, in Indianapolis, announced in... (The Chronicle of Philanthropy)
