Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Excel Database

The Data Form helps.. for other people entering the information.

I would love to be able to use Crystal Reports to create my own thing; But I
don't know the first thing to it.

I appreciate your time. I am going to keep this spreadsheet simple. It does
what I need it to do. I always have a habit of making things better, but I'm
done. It's over, and it works. Always the best part.

Thanks again,
Jeremy

"Kooster" wrote:

It sounds like you set this up like a relational database, i.e., multiple
tables (sheets). Excel works as a flat-file database (one file/table,
multiple fields and records). You can use lookup functions on Excel to help
with data entry, e.g., salesperson number produces name in another column.
You can use the data form to produce a data entry screen in field order.

You can produce an area in the spreadsheet to summarize data and act on it.
Look this over:
http://office.microsoft.com/en-us/as...186941033.aspx

Personally, I would use Crystal Reports (has a better report writer), or
Excel using Microsoft Query. Look he
http://office.microsoft.com/en-us/as...864661033.aspx

P.
--
Overcome Sales Barriers
http://salesbarriers.typepad.com/

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you Sparse a field in Excel??? and Database Query?? TotallyConfused Excel Discussion (Misc queries) 3 December 6th 05 11:24 PM
Query Excel database from desktop Lost But Trying Hard Excel Discussion (Misc queries) 1 September 11th 05 01:46 PM
Set Database in Excel joeeng Excel Discussion (Misc queries) 3 August 22nd 05 11:46 PM
Excel Database mikedix Excel Discussion (Misc queries) 0 June 8th 05 09:37 PM
Query a Access database that has a module from Excel Oggie Excel Discussion (Misc queries) 1 January 4th 05 08:43 AM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"