Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rating: Thread Rating: 20 votes, 5.00 average. Display Modes
Old 06-01-2009, 01:55 PM   #16
Atomic Shrimp
Humanoid lifeform
 
Join Date: Jun 2000
Location: Portsmouth, England
Posts: 1,954
Thanks: 0
Thanked 8 Times in 7 Posts
Atomic Shrimp has a spectacular aura about Atomic Shrimp has a spectacular aura about
Re: The Ten Commandments of Access

Never shalt thou utter the words 'I don't need to solve [real-world scenario] because it will never happen". The man or woman that says this is to be taken to a public place and beaten with a trout.

Atomic Shrimp is offline   Reply With Quote
Old 06-03-2009, 08:29 AM   #17
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,107
Thanks: 81
Thanked 1,601 Times in 1,485 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: The Ten Commandments of Access

Mike G: Waste of a good trout. How about a channel mullet or a choupique (local Louisiana trash fish)?
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
The Following User Says Thank You to The_Doc_Man For This Useful Post:
avcastner (12-26-2013)
Old 06-03-2009, 02:53 PM   #18
statsman
Newly Registered User
 
statsman's Avatar
 
Join Date: Aug 2004
Location: Toronto ON
Posts: 2,074
Thanks: 4
Thanked 3 Times in 3 Posts
statsman will become famous soon enough
Re: The Ten Commandments of Access

Thou shall never attempt User or Group Level Security on the original database. Thou shalt always use a copy. For when the sinner screws up the Security, he shall always have a safe harbour to which he may return.
Here endeth the lesson.

__________________
Dart players always have a point.
statsman is offline   Reply With Quote
Old 07-01-2009, 12:47 AM   #19
Lightwave
Ad astra
 
Lightwave's Avatar
 
Join Date: Sep 2004
Location: Edinburgh
Posts: 1,399
Thanks: 123
Thanked 137 Times in 129 Posts
Lightwave will become famous soon enough
Re: The Ten Commandments of Access

Thou shalt sit the user down preferably at management level and padlock him to a desk with paper copies of his own procedures and tell him to work through each procedure to ensure they are logical.

Thou shalt not let him leave until you are confident that they fully understand the critical paths and potential dangers.

During this minimum week period you shall remember to feed them
Lightwave is offline   Reply With Quote
Old 07-24-2009, 12:59 AM   #20
oumahexi
Free Range Witch
 
oumahexi's Avatar
 
Join Date: Aug 2006
Location: Brig O'doon
Posts: 1,998
Thanks: 4
Thanked 2 Times in 2 Posts
oumahexi is on a distinguished road
Re: The Ten Commandments of Access

On adhereing to these wonderful commandments the Gods will surely favour you with new and wonderous employment opportunities, but beware, thou shalt be smitten if thou leavest in haste with little to no relevant and understandable documentation.
__________________
And ever mind the Rule of Three:
What ye send out, comes back to thee.
oumahexi is offline   Reply With Quote
Old 09-01-2009, 06:30 AM   #21
bulrush
Newly Registered User
 
Join Date: Sep 2009
Location: West Michigan, USA
Posts: 209
Thanks: 2
Thanked 0 Times in 0 Posts
bulrush is on a distinguished road
Re: The Ten Commandments of Access

You people forgot a major one for managers:

"Thou shalt not hire a database manager without at least a 4 year degree in computer science or the equivalent."


You would not believe how common it is for a secretary to be doing database design. Not that secretaries are bad. But I don't want a brain surgeon fixing my car either.
bulrush is offline   Reply With Quote
Old 09-01-2009, 06:40 AM   #22
shadow9449
Newly Registered User
 
Join Date: Mar 2004
Location: Toronto, Ontario
Posts: 963
Thanks: 7
Thanked 41 Times in 39 Posts
shadow9449 will become famous soon enough shadow9449 will become famous soon enough
Re: The Ten Commandments of Access

Quote:
Originally Posted by bulrush View Post
You people forgot a major one for managers:

"Thou shalt not hire a database manager without at least a 4 year degree in computer science or the equivalent."
That is an interesting point. I do have a university degree in computer science and I'd actually be interested in speaking to others here about their feelings of how much it has or hasn't helped in their career.

SHADOW

shadow9449 is online now   Reply With Quote
Old 09-09-2009, 06:08 PM   #23
mrrayj60
Newly Registered User
 
mrrayj60's Avatar
 
Join Date: Sep 2009
Location: Brooksville,FLorida
Posts: 101
Thanks: 7
Thanked 0 Times in 0 Posts
mrrayj60 is on a distinguished road
Send a message via MSN to mrrayj60 Send a message via Yahoo to mrrayj60
Re: The Ten Commandments of Access

I told my boss about the help I was getting from this site and noted how many people were from England, She quickly noted that its always cold and raining there, no reason to go outside. lol Thanks all, especially the brits! Stay warm and dry.
Ray
Brooksville, Florida
mrrayj60 is offline   Reply With Quote
Old 09-10-2009, 02:29 AM   #24
Rabbie
Super Moderator
 
Rabbie's Avatar
 
Join Date: Jul 2007
Location: Returning to Scotland
Posts: 5,906
Thanks: 110
Thanked 76 Times in 68 Posts
Rabbie is a jewel in the rough Rabbie is a jewel in the rough Rabbie is a jewel in the rough
Re: The Ten Commandments of Access

Quote:
Originally Posted by shadow9449 View Post
That is an interesting point. I do have a university degree in computer science and I'd actually be interested in speaking to others here about their feelings of how much it has or hasn't helped in their career.

SHADOW
When I worked for a major UK computer manufacturer my old boss once told a professor of computer science that the one advantage that a computer science graduate had was that we didn't need to show them how to turn their PC on.
__________________
The best solution is the simplest one that meets all requirements.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Rabbie is offline   Reply With Quote
Old 09-10-2009, 06:02 PM   #25
shadow9449
Newly Registered User
 
Join Date: Mar 2004
Location: Toronto, Ontario
Posts: 963
Thanks: 7
Thanked 41 Times in 39 Posts
shadow9449 will become famous soon enough shadow9449 will become famous soon enough
Re: The Ten Commandments of Access

Quote:
Originally Posted by Rabbie View Post
When I worked for a major UK computer manufacturer my old boss once told a professor of computer science that the one advantage that a computer science graduate had was that we didn't need to show them how to turn their PC on.
That's interesting because when I was in Computer Science, there was a joke passed around like this:

Q: How many Computer Science grads does it take to change a lightbulb?
A: None. That's a hardware problem

The truth is that we studied JK Flipflops, logic gates, integrated circuits, multiplexers, and far more. But given anything practical with regard to hardware and we'd be at a loss.

I maintain that I'm a better coder because of the university background than I would have been without it. Before I touched Access, I spent years programming in C and C++ both in school and commercially. I'm curious what other people with degrees have experienced.

SHADOW
shadow9449 is online now   Reply With Quote
Old 09-28-2009, 04:42 PM   #26
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,563
Thanks: 88
Thanked 1,479 Times in 1,395 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: The Ten Commandments of Access

The most dasterdly work of the evil one has been entirely overlooked. Set the caption property of the fields in a few tables, set up some relationships, make some queries and build a form or two with the wizard. Change between the design and datasheet views of the tables and queries a couple of times.

Then try to modify the queries or forms using functions in derived fields or the control source of a textbox without getting confused. Table Level Lookups will appear comparatively benign.

Field captions are the programming equivalent of looking up at a stick while turning around, then droping the stick on the ground and jumping over it.

I tried one field caption property just once and immediately deleted it. Last weekend I worked in a database where they had been extensively used. You would swear you were going crazy. Well you would swear at least.
Galaxiom is offline   Reply With Quote
Old 09-30-2009, 01:02 AM   #27
mans123
Registered User
 
Join Date: Sep 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
mans123 is on a distinguished road
Re: The Ten Commandments of Access

Excellent Information....! thanks all poster for sharing your useful views.
mans123 is offline   Reply With Quote
Old 10-15-2009, 01:08 AM   #28
copcop
Registered User
 
Join Date: Oct 2009
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
copcop is on a distinguished road
Re: The Ten Commandments of Access

Quote:
Originally Posted by bulrush View Post
You people forgot a major one for managers:

"Thou shalt not hire a database manager without at least a 4 year degree in computer science or the equivalent."


You would not believe how common it is for a secretary to be doing database design. Not that secretaries are bad. But I don't want a brain surgeon fixing my car either.
I totally agree with bulrush's views. A right person at a right place can really create a difference.
copcop is offline   Reply With Quote
The Following User Says Thank You to copcop For This Useful Post:
avcastner (12-26-2013)
Old 10-15-2009, 01:12 AM   #29
Rabbie
Super Moderator
 
Rabbie's Avatar
 
Join Date: Jul 2007
Location: Returning to Scotland
Posts: 5,906
Thanks: 110
Thanked 76 Times in 68 Posts
Rabbie is a jewel in the rough Rabbie is a jewel in the rough Rabbie is a jewel in the rough
Re: The Ten Commandments of Access

Quote:
Originally Posted by bulrush View Post
You people forgot a major one for managers:

"Thou shalt not hire a database manager without at least a 4 year degree in computer science or the equivalent."


You would not believe how common it is for a secretary to be doing database design. Not that secretaries are bad. But I don't want a brain surgeon fixing my car either.
Disagree entirely. There are many good database managers without degrees who have learned their skills on the job and are much better than some people with degrees. The important thing is that the person understands what they are doing and not whether they have a degree.
__________________
The best solution is the simplest one that meets all requirements.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Rabbie is offline   Reply With Quote
The Following 2 Users Say Thank You to Rabbie For This Useful Post:
access7 (08-31-2011), avcastner (12-26-2013)
Old 10-15-2009, 01:55 AM   #30
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,769
Thanks: 55
Thanked 1,022 Times in 988 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: The Ten Commandments of Access

Quote:
Originally Posted by Galaxiom View Post
The most dasterdly work of the evil one has been entirely overlooked. Set the caption property of the fields in a few tables, set up some relationships, make some queries and build a form or two with the wizard. Change between the design and datasheet views of the tables and queries a couple of times.

Then try to modify the queries or forms using functions in derived fields or the control source of a textbox without getting confused. Table Level Lookups will appear comparatively benign.

Field captions are the programming equivalent of looking up at a stick while turning around, then droping the stick on the ground and jumping over it.

I tried one field caption property just once and immediately deleted it. Last weekend I worked in a database where they had been extensively used. You would swear you were going crazy. Well you would swear at least.

Captions are surely an abomination

I haven't examined all the facilities available in A2007, but are not these "features" continually being extended into other areas - did someone on here not comment about multi value fields (I havent looked to see what they do, but it doesnt sound realtional). I also dont like/see the point of the + sign in tables.

__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 97 Linking to tables in Access 2000 Amileaux General 6 10-16-2013 04:55 AM
FTP Upload Module gisash1 General 12 01-21-2010 05:07 AM
Beginner's Guide to ODBC Banana Access FAQs 1 06-18-2009 08:10 PM
User Defined Type - Access 97 to 2000/2002 Mile-O Access FAQs 0 12-01-2005 06:35 AM
Access Charts/Graphs durdle17 Reports 5 10-04-2004 02:42 AM




All times are GMT -8. The time now is 07:42 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World