Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases > #398 > unrolled thread
| Started by | vmal124@gmail.com |
|---|---|
| First post | 2013-07-01 23:21 -0700 |
| Last post | 2013-07-04 15:05 +0200 |
| Articles | 3 — 3 participants |
Back to article view | Back to comp.databases
Need some help with Fleet Management database in MS Access 2007 vmal124@gmail.com - 2013-07-01 23:21 -0700
Re: Need some help with Fleet Management database in MS Access 2007 Robert Klemme <shortcutter@googlemail.com> - 2013-07-03 21:01 +0200
Re: Need some help with Fleet Management database in MS Access 2007 Wolfgang Keller <feliphil@gmx.net> - 2013-07-04 15:05 +0200
| From | vmal124@gmail.com |
|---|---|
| Date | 2013-07-01 23:21 -0700 |
| Subject | Need some help with Fleet Management database in MS Access 2007 |
| Message-ID | <dc95f5d7-f9ef-48fe-a322-0e5379c34d41@googlegroups.com> |
Can someone please advice how I can start to build Fleet Management Database for my friend's Fleet business? I am using MS Access 2007. I have intermediate knowledge with MS Access. How many tables? attributes etc.... entity relation diagram? forms? reports?
[toc] | [next] | [standalone]
| From | Robert Klemme <shortcutter@googlemail.com> |
|---|---|
| Date | 2013-07-03 21:01 +0200 |
| Message-ID | <b3jao5Fsij6U1@mid.individual.net> |
| In reply to | #398 |
On 02.07.2013 08:21, vmal124@gmail.com wrote: > Can someone please advice how I can start to build Fleet Management > Database for my friend's Fleet business? Talk to your friend, understand the business, gather requirements, start designing at least the architecture, pick proper tools and start implementing. And don't forget QA along the way. > I am using MS Access 2007. I have intermediate knowledge with MS > Access. When I hear "fleet" that sounds like "many vehicles". That does not fit very well to desktop database. You probably at least want to use Access as frontend only and store the data someplace else. > How many tables? attributes etc.... entity relation diagram? Yes, you should do that. > forms? Useful for data entry. > reports? Useful if your friend wants to know how his business runs. Cheers robert -- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/
[toc] | [prev] | [next] | [standalone]
| From | Wolfgang Keller <feliphil@gmx.net> |
|---|---|
| Date | 2013-07-04 15:05 +0200 |
| Message-ID | <20130704150550.441f4eba4aa1c2375aa76928@gmx.net> |
| In reply to | #398 |
> Can someone please advice how I can start to build Fleet Management > Database for my friend's Fleet business? > I am using MS Access 2007. I have intermediate knowledge with MS > Access. > How many tables? attributes etc.... > entity relation diagram? > forms? > reports? Start by using an actual RDBMS for storage of the data, such as e.g. PostgreSQL. And a front-end that supports PostgreSQL natively (Access doesn't, the ODBC "support" is garbage), such as e.g. LibreOffice Base. Next, get a clue of the semantics of the application domain. An internship with the end user could be helpful. Sincerely, Wolfgang
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases
csiph-web