[mso] Re: Access 2002 normalizing a database :VSMail mx3
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 4 Nov 2004 21:40:17 -0500
<<If you need help
with stuff like the datepart and other functions, there are a number of
Access articles in Linda's newsletter archives. Just look for the articles
by me and they are all Access.>>
All of James's articles are here:
http://personal-computer-tutor.com/abc/authors.htm#james
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
ABC Free Ezine ~ Free Ebooks and Tutorials
*all outgoing mail scanned by Norton AV. If you got a bug that looks like
it came from me, it did NOT!
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of James LaBorde
Sent: Thursday, November 04, 2004 3:28 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access 2002 normalizing a database :VSMail mx3
Suzanne,
How do you identify patients in the office? It may take a little patience,
but it would probably be worth it to use the same identifier in your
database as you do when the patient comes in. If it is the ssn, you start
running into compliance issues and you don't necessarily want to be using
Access. As far as normalizing your existing data, your best bet is to start
by getting your patient info into a new table. You can add your unique
identifier later, just use an autonumber to start. Get your patient info
in, add your unique identifier and dump the autonumber. Next you will want
to work on getting your existing data into a new table for transactions.
The list can help with that when you get to that stage. If you need help
with stuff like the datepart and other functions, there are a number of
Access articles in Linda's newsletter archives. Just look for the articles
by me and they are all Access.
James La Borde
South Western Federal Credit Union
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
