David Lind
David_Lind at acordia.com
Fri Jun 4 11:27:22 CDT 2004
Robert, Thanks for the suggestions. Right now my being self-taught is the biggest problem. Because I am self-taught, I've managed to not teach myself good programming basics. (I am looking into legal action against myself right now!) The biggest problem I have is non-normalized tables. The tech came down and spent 3 days here and one of the biggest issues was the normalization of the tables. (I have one table with 80+ fields including the ANPK. Didn't realize it was quite that bloated!) There are other issues such as I have a financial table currently setup that handles both debits and credits. However multiple debits can refer to a single credit and sometimes multiple credits can refer to a single debit. The lady I am working for is quite upset about what we've termed "The Rounding Issue" of Access. I never realized that Access automatically figures everything out to the 11th decimal point on calculations. That creates a real problem when trying to get exact finances and a clear statement for an insurance bill! Those are just the big problems, and I haven't even begun to scratch the surface. I would love to get as much input as possible to get things fixed (in fact I wouldn't mind 2nd or 3rd opinions on what the tech we had said), however, we have strict security issues and I think the tech that helped had to have blood drawn, produce three forms of ID, prove that the last 4 generations of his and his wife's families were not in any way linked to any possible criminal activity and promise the life of his firstborn child (if he ever has one) just to be allowed to look at our data. The database I'm working on is for the Medical Malpractice division of an insurance company that was recently bought by a bank, so we have all kinds of security and privacy issues involved. David -----Original Message----- From: Robert L. Stewart [mailto:rl_stewart at highstream.net] Sent: Friday, June 04, 2004 9:08 AM To: accessd at databaseadvisors.com Cc: David Lind Subject: Re: Getting Started David, First, I would suggest that you send a few willing ones on the list the changes that your contracting company is making so we can evaluate it for you and help you to not get trapped into using then for all future changes. And, the big one is to make sure the design of the table structure is correct. If the table design is bad, you will have nothing but trouble in the future. I would venture to say that all of us on the list are self-taught. Some I would also venture have been able to find a mentor to help us. Personally, I am self-taught and have been such a mentor. Second, you do NOT want them to do the rebuild and hand it to you. You want to be involved in the sign off of each area of the design, tables, forms design, report layout, commenting within all the code, etc. I would be willing to help you in the evaluations if you like. Robert At 06:36 PM 6/3/2004 -0500, you wrote: >Date: Thu, 3 Jun 2004 14:06:14 -0400 >From: "David Lind" <David_Lind at acordia.com> >Subject: RE: [AccessD] OT? Getting Started >To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> >Message-ID: > <BCD28C764F55FF40AD40C23D410E40297FCC04 at EASTMAIL.broker.corp> >Content-Type: text/plain; charset="iso-8859-1" > >Hi All. > >I'm new to these lists and am in need of some guidance. > >I've been working in Access97 for a number of years. Everything I know I >taught myself by trial and error. Compared to some of the code and stuff >I've seen sent back and forth on here over the past 2 days, I'm nowhere >near the same level/class of programmers that y'all are. In fact, the >database that I've built for the section of the company I work for has >expanded to a level way over my head and GanCom has been called in to help >rebuild it, probably in Access03. I know VERY little about module >programming/VB. While I am sure y'all are a great resource and I would >definitely ask questions in the future when I get stuck, I need some help >with the basics. What kind of resources should I be looking at to get >started? From what the GanCom rep said when he was here, they'll do the >rebuild, then hand it back to me. I'd like to be on my way of being able >to do some if not all of the future work on my own instead of outsourcing >it to someone else. Due to my being on the low end of t! >he totem pole around here, finances is an issue, so a $600 seminar is out >of the question at the moment. > >TIA >David