Re: [MS_AccessPros] Database design - best practice

 

Duane

I found the Access Project Management template that comes with Access.  With a bit of redesigning to move everything down a level (the database is for one project, table "Projects" becomes tblRequirements, table Tasks remains but becomes tasks of the requirement and I create another table for details of tasks - linking to Word documents etc) I have a workable solution.  Most of the embedded forms and reports don't need much tweaking.

Thanks for the nudge in the right direction.

Ray

---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

Ray,

When you stated "Access being the preferred route" I assumed you wanted to build your solution in Access.

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of rayfrew@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, September 27, 2018 7:04 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Database design - best practice

 

Hi Duane

Thanks for your thoughts.  I hadn't thought of creating a database to manage the project but I like the idea of linking to other, more specialist types of files (Word, Excel, MS Project etc).  I'll experiment - thanks for the prompt.

Best regards

Ray 

---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

I'm not sure Access alone can/should handle all of these requirements. I would suggest as just a kick start for discussion three tables:

 tblProjects

 tblTasks

 tblDetails

Projects is the top level with Tasks being a child of projects and Details being a child of Tasks. Each of these tables would have fields like:

Title

Description

ExpectedDate

CompletionDate

PercentComplete

ResponsiblePerson

Sequence

This could probably managed in a single table with parent and child IDs. At the project level there could be links to project documents and project notes.

You might also want to incorporate Word docs, MS Project or Planner as well as other tools.

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of rayfrew@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, September 26, 2018 4:45 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Database design - best practice

 

Hi Everyone.  

I'd appreciate your thoughts and pointers about how to design, track development and achieve customer acceptance of a database (Access being the preferred route).

I would have a workflow of:

1. Discuss what the customer wants - this gets you Quality expectations, Acceptance criteria and major requirements.

2. Break the major requirements into smaller requirements which can be prioritised and estimated.

3. Create a plan for the tasks (design db, design style, build tables, queries, forms, test, and no doubt change)

4. Cope with change (oh, by the way, can you just...)  (I don't like it ....)

What I'm interested in is techniques and/or tools to manage / track the above.  Most of the books I've read about Access go into the techniques of how to use Access but don't mention the User / Business reasons for having a database in the first place.  Any hints, tips, websites, books, forums, ideas welcomed.

Many thanks

Ray

__._,_.___

---

Posted by: rayfrew@gmail.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (7)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___