Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases > #399

Re: Need some help with Fleet Management database in MS Access 2007

Show all headers | View raw

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/

Back to comp.databases | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

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

csiph-web