Re: getting into access, can you point me in the right direction?

Your ignorance is exceeded only by your offensive attitude.
I have no need for training wheels, but you really need to get some
knowledge and perspective.

There is no end all be all for any software application platform. For small
to medium size environments where the company or department is on a tight
budget, Access is a perfectly acceptable tool. For a small office with a few
users, installing SQL Server would be using a semi to carry your lunch to
work.

For larger systems, using SQL Server as the data source is a good way to
scale the system up; however, this presupposes the organization can afford a
knowledgeable SQL Server DBA and the additional hardware resources required.

Your statement regarding what is or is not included with Office has no
meaning. For any version of Office that includes Access, Jet and DAO are
both included. And, in case you are not aware (obviously you are not), DAO is
the native method for 2003.

If you have anything positive to contribute to this newgroup, please do;
otherwise, shut up and go away.

Oh, did I mention you are an offensive and annoying idiot?

--
Dave Hargis, Microsoft Access MVP


"Aaron Kempf" wrote:

Access is a great FRONTEND

but for a database engine?
I'd rather use PEN AND PAPER than MDB

I mean UNRELIABLE
I mean UNSCALABLE
I mean UNPREDICTABLE
I mean DEPECRATED

Jet and DAO haven't been included with office, windows or MDAC for 10 years

STFU and lose the training wheels, kid




"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D1C9BD37-3561-41B5-952F-D85258886D7C@xxxxxxxxxxxxxxxx
Absolute nonsense.
--
Dave Hargis, Microsoft Access MVP


"Aaron Kempf" wrote:

yeah don't worry about MS Access

learn SQL Server if you want a job


"golem" <golemshed@xxxxxxxxx> wrote in message
news:1178119613.509326.102170@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello everyone.

I'm starting to use access instead of excel to store data because it's
just more functional. I've built a simple db with two tables, a
relationship from one to many, and it works, i can report from it and
add things as i need to. It's just not as functional as i want it to
be.

What i am trying to capture is the skill level, assessments, and
trainings of employees in a db for my boss.

I'd like to be able to build out reports that can show how much of
each typing has been done (typing and windows training are offered
right now), or just how much of either type.

I'd like to be able to report on the current and possibly past
assessments of staff.

I was thinking of an employee table, a separate training table for
each type of training, and a separate table for each type of
assessment. Also a plan table to discuss my strategy eith each
employee.That makes six tables.

First of all, am i going about this in the right way? This will be
only the second db i've built, and i know i've got a lot to learn. My
boss really wants accountability so i want to give her every way to
tweak and pick apart this data.

Any tips or tweaks will be greatly helpful. I'm sick of excel and my
first db was complimented by my boss, so i want to keep it up. Thanks
again for any help!

bill







.

Relevant Pages

  • Re: getting into access, can you point me in the right direction?
    ... I have no need for training wheels, but you really need to get some ... using SQL Server as the data source is a good way to ... Dave Hargis, Microsoft Access MVP ... trainings of employees in a db for my boss. ...
    (microsoft.public.access.gettingstarted)
  • RE: Problem with query causing Access to go to white screen
    ... Access not to refresh/repaint and go white? ... Dave Hargis, Microsoft Access MVP ... When you say "copy the Access DB to the SQL Server I am running the query off" ...
    (microsoft.public.access.modulesdaovba)
  • RE: Access limitations/suitablity
    ... Sorry for my delayed response. ... I think Tony has some great thoughts on upsizing as to when and how. ... Dave Hargis, Microsoft Access MVP ... performance they had to convert to something like SQL Server? ...
    (microsoft.public.access.gettingstarted)
  • Re: SQL Tables
    ... Microsoft Access MVP ... "Graham R Seach" wrote: ... albeit transferred to SQL Server. ...
    (microsoft.public.access.adp.sqlserver)
Loading