| Title | Date Added | Company | |
|---|---|---|---|
![]() |
The Missing Manual: Creating Databases | 2005-11-18 | O'Reilly Media |
| A database typically refers to any organized collection of information. This paper shows how one can create a Database, from the initial concept to a full-fledged Access file. Using Access's Order Entry template as an example, one learns how to set up all the types of database fields to give the information one wants, when they want it, and in exactly the way one wants it.
Tags: Application Development, |
|||
![]() |
Use Excel Functions Inside Access | 2005-04-14 | O'Reilly Media |
| Excel has many powerful built-in functions for such things as financial and statistical analysis. If one wants to do the same type of analysis in Access, one can do one of the following three things: purchase an off-the-shelf code solution, write their own code for analysis, or use automation to tap into Excel's functions from inside Access. This paper shows how to tap into Excel via automation and use spreadsheet functions, saving time and money over the other options. This hack involves Access working hand in hand with Excel, so one needs to make sure Excel is installed on the machine on which the database will be running. This is a safe assumption in most corporate environments.
Tags: Spreadsheets, |
Business Technology Power Center
Learn about how HP and Intel can help you do more with less.
Oracle Accelerate
Unlimited Possibilities for Limited Budgets.
APAC Data Center City, by Cisco
Blogs, Resources & Events. Take a tour and win US$3000!
Compare your IT salary
Sign-up for free download of IT salary benchmark report 2008.
Learn how the right information puts manufacturers ahead of the competition.