Re: Returning too many lines


"TraderAnalysis" <TraderAnalysis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F4B910B0-3141-4333-906B-3D72249D3D36@xxxxxxxxxxxxxxxx
It would take me forever to create all of those new tables.

Trader Analysis,

Good database design does require some effort. Forever, though, is an exageration.


The tables I
currently have are being used for multiple sources so I really don't want to
change them and want to keep it down to minumum (doesn't sound possible?).
So here is a breakdown of my tables:

Reserved Names
Issue: Stock
AMEX: text
CBOE: test
ARCA: test, etc.

That table design is going to give you a permanent set of problems.

Steve's general design is more normalized and thus will better support queries.

Here are some general database, SQL, and and MS Access resources.


Websites:

http://www.mvps.org/access
http://allenbrowne.com/
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Top
http://www.rogersaccesslibrary.com/
http://www.accessmvp.com/djsteele/SmartAccess.html


Books: General: Beginner

Database Design for Mere Mortals by Michael J. Hernandez

SQL Queries for Mere Mortals by Michael J. Hernandez, John L. Viescas


Books: General: Intermediate/Advanced

Advanced SQL Programming, For Smarties, 3rd Edition, by Joe Celko

SQL Puzzles and Answers, by Joe Celko


Books: General: Advanced

The Data Modeling Handbook, Michael C. Reingruber and William W. Gregroy


Books: Access : Intermediate

Access Cookbook by Getz, Litwin, and Baron
(Compilation of solutions, listed by task-category)


Books: Access: Advanced

Access Database Design & Programming by Steven Roman (3rd Edition)

Access Developer's Handbook (for your version of Access)


Sincerely,

Chris O.


.

Relevant Pages

  • Re: RSFC advice column
    ... I've thought about the database stuff too. ... SQL would actually make ... Wrox has some pretty good books on learning basic computer stuff -- ... Mere Morlals) SQL is easy to do with a good database design. ...
    (rec.sport.football.college)
  • Re: Database Design Books
    ... Thank you very much for the books list and for pointing me ... to some good resources. ... >Database Design for Mere Mortals ... >The Data Model Resource Book, ...
    (microsoft.public.sqlserver.server)
  • Re: Are there manuals for Office XP products?
    ... suggesting books which are suitable for beginning and intermediate users. ... To learn database design and structure, which should be your first concern, ther are 2 books which come to mind: ... For Access database design and general usage of Access databases, one of the finest authors is John L. Viescas. ... don't find anything on my original disk and I don't see anything online... ...
    (microsoft.public.access.gettingstarted)
  • Re: Access is just to hard to understand
    ... Database Design, if you get that you will get Access. ... Relational Database Design. ... People using Access without this understanding will find it an exasperating ... > about $200 worth of Access books, and a stack of Access information I ...
    (microsoft.public.access.gettingstarted)
  • Re: A database design question
    ... If you think of Authors and Books and Libraries, then one Author can write many ... Database design rests on reducing all data linkages to a one-to-many ... AuthorBook - this has two fields, ...
    (comp.lang.pascal.delphi.misc)