Member Login

E-mail:    Password:  




 TitleDate AddedCompany
whitepaper The Missing Manual: Creating Databases2005-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,
  
whitepaper Use Excel Functions Inside Access2005-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,
  

Jump to [1]