Strategy for a databse

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi group,

I have seen several suggestions in this forum that one should take
enough time to make a good plan for the database, rather than jumping
straight in building tables. But I have not been able to find good
texts on a strategy for the planning.

I have some experience with building a database of people, their
adresses and some other parameters. I constucted queries and reports
and forms. All in all it held well over a thousand people of two
specific kinds, from five different countries and about 8 different
regions. I could merge with Word for labels and letters to selected
targets.

So I am not a total newbie at this, and I know of some mistakes that
would have been better avoiding early in the creation. I understand it
is good to have a strategy. My big book on "Using Access" also tells
me so. But that is about it!

Now I would like to read a text on the subject itself.

I am captain of a 100 ft long high speed passenger boat. Mostly we do
regular trips but often also charters of various lenghts. There are
various numbers of passengers, various crew members. I need to plan
well ahead with ordering fuel, always having enough but not carrying
needless amounts that way the ship down.

For all these things, and many others I have reports, in Excel format,
where timings and numbers need to go.

Plans on trips etc change more often than I would like them to. And I
am getting increasingly tired of updating the same info in several
different Excel books. I think an Access database could serve me well,
but I am unsure of where to start.

I am not looking for something to buy.

Tia

Lars
Stockholm
.

Relevant Pages

  • Re: Maintenance Plan Caused System To Hang
    ... ran DBCC CHECKDB) I was connected to the server through Terminal Services. ... Even though the server has 2 GB of RAM and is used exclusively for SQL 2005, ... maintenance plan in SQL 2005 and ran it. ... Back up the database and transaction log ...
    (comp.databases.ms-sqlserver)
  • Re: Strategy for a databse
    ... Rebecca Riordan's 'Designing Effective Database Systems' is the best source ... regular trips but often also charters of various lenghts. ... I need to plan ... For all these things, and many others I have reports, in Excel format, ...
    (microsoft.public.access.gettingstarted)
  • Re: DBCC Checkdb,
    ... Fehler beim Maintenance Plan mit dem ich leider nichts anfangen kann. ... ich habe zur leichteren Fehlerfindung alle weiteren Step disabled - es ... bleibt nur der erste Step Check Databases über. ... The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053 ...
    (microsoft.public.de.sqlserver)
  • Re: Wiki software for genealogy (long)
    ... "When we've ironed out the bugs, this will be the one everyone wants" hands-down over any given 5-year plan of business. ... You can kludge most of 'em into doing the other, and you can even browbeat 'em into doing a migration database, but they won't do 'em as well as a dedicated program will. ... Which is why a first requirement should be for a package, not a single program, to be built around a database for which a decent toolset is available - at the very least for reporting. ... If the data is accessible in that way and the data model is well designed in the first place a whole set of programs can be built round it, either by the vendor or by sufficiently skilled users. ...
    (soc.genealogy.britain)
  • Re: network permissions for Btrieve (PSQL 8.x) files
    ... should read the manual carefully (plan to have an hour of quiet time to ... database, but once implemented, you can lock out all user access from ... still use the database from both Btrieve and SQL/ODBC. ... > files for the usual client-users, ...
    (comp.databases.btrieve)