IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Re: Part of Office Pro
Post #119,665
by Nightowl
9/30/03 11:18:55 PM
Reply
New Re: Part of Office Pro
Okay, we obviously didn't install the Northwind Database, so we are gonna consider dealing with that this weekend. We also didn't install other things about Access. I think I have a bare bones concept for it because when we tried to do an analyze option or something, it said to install such and such.

When we first put Office 97 on here, I only wanted the basics, in fact, we didn't even install Outlook or Power point, to my knowledge.

So we have a little adding to do. ;)

I'm also trying to come up with the book "Access 97, Complete Concepts and Techniques" from the Shelly Cashman series. I have the Excel one and it is the BEST book I've used to help me with Excel. Barnes and Noble has it for half price, so we'll consider buying it if I get the job. The other two books I have are less visual, and visual is what helps me the most

So I'll work with my critter database also, but it would probably be a good idea to get the Northwind one... or something else so I can try this multiple tables in a database thing.

One more question... I have an extensive Address list in Word, can it be imported into Access and worked with as a Data Base? Address lists seem to be one of the biggest things people work with.

Thanks.

Nightowl >8#
"I learned to be the door, instead of the mat!" "illegitimi nil carborundum"

Comment by Nightowl
Post #119,668
by orion
Picture of orion
9/30/03 11:49:56 PM
Reply
New Word to Access
Depends on how you entered the data. If it is a fixed width record with the address like this:

Joe Jones 1234 Main Street St. Louis Mo. 63101 314-555-1212

You could save it as a text file and import it into Access as long as the data lined up.

But if you entered them like this:

Joe Jones
1234 Main Street
St. Louis, Mo 63101
314-555-1212

Chances are it won't line up. You'd have to copy and paste it into a format that Access can read, or copy and paste each bit of info into a table field row.

You might have to copy and paste them into a format like this:

"Joe Jones", "1234 Main Street", "St. Louis", "Mo", "63031", "314-555-1212"

Then save it as a text file with an extension of CSV for comma seperated values.

Now I'm not 100% sure because I haven't done it in a while, but if your addresses are in a Word table, you might be able to export it to an Excel spreadsheet and then import that into Access.


"Lady I only speak two languages, English and Bad English!" - Corbin Dallas "The Fifth Element"
     Is there some sort of tutorial disk for Access? - (Nightowl) - (31) - Sept. 30, 2003, 06:14:10 PM EDT
         Okay, first question... :) - (Nightowl) - (17) - Sept. 30, 2003, 06:28:01 PM EDT
             Table is multiple columns together as a unit - (FuManChu) - (5) - Sept. 30, 2003, 06:35:25 PM EDT
                 Re: Table is multiple columns together as a unit - (Nightowl) - (4) - Sept. 30, 2003, 06:38:00 PM EDT
                     Third normal form - (ChrisR) - (3) - Sept. 30, 2003, 06:41:26 PM EDT
                         Re: Third normal form - (Nightowl) - (2) - Sept. 30, 2003, 06:47:30 PM EDT
                             1st Normal Form - (ChrisR) - (1) - Sept. 30, 2003, 08:05:35 PM EDT
                                 Re: 1st Normal Form - (Nightowl) - Sept. 30, 2003, 11:13:56 PM EDT
             Tuples - (ChrisR) - (10) - Sept. 30, 2003, 06:39:08 PM EDT
                 Re: Tuples - (Nightowl) - (1) - Sept. 30, 2003, 06:42:43 PM EDT
                     Could be - (ChrisR) - Sept. 30, 2003, 06:46:59 PM EDT
                 How come critterid isn't IDENTITY? -NT - (mmoffitt) - (7) - Oct. 1, 2003, 09:07:34 AM EDT
                     I'm of two minds on identity - (ChrisR) - (6) - Oct. 1, 2003, 10:15:27 AM EDT
                         Re: I'm of two minds on identity - (Nightowl) - (5) - Oct. 1, 2003, 10:55:12 AM EDT
                             In Access, Identity is an AutoNumber - (ChrisR) - (3) - Oct. 1, 2003, 11:24:56 AM EDT
                                 Re: In Access, Identity is an AutoNumber - (Nightowl) - (2) - Oct. 1, 2003, 11:33:16 AM EDT
                                     AutoNumbers not always continuous - (ChrisR) - (1) - Oct. 1, 2003, 12:04:14 PM EDT
                                         ICLRPD (new thread) - (ben_tilly) - Oct. 1, 2003, 08:21:15 PM EDT
                             Identity being the key - (orion) - Oct. 1, 2003, 08:09:15 PM EDT
         Don't recall if there's a tutorial - (ChrisR) - (4) - Sept. 30, 2003, 06:29:42 PM EDT
             Re: Don't recall if there's a tutorial - (Nightowl) - (3) - Sept. 30, 2003, 06:39:50 PM EDT
                 Part of Office Pro - (ChrisR) - (2) - Sept. 30, 2003, 06:44:05 PM EDT
                     Re: Part of Office Pro - (Nightowl) - (1) - Sept. 30, 2003, 11:18:55 PM EDT
                         Word to Access - (orion) - Sept. 30, 2003, 11:49:56 PM EDT
         Access tutorials - (orion) - (4) - Sept. 30, 2003, 11:39:48 PM EDT
             Re: Access tutorials - (Nightowl) - (1) - Oct. 1, 2003, 12:33:48 AM EDT
                 Re: Access tutorials - (orion) - Oct. 1, 2003, 07:52:33 PM EDT
             It worked, Norman!! ( was Re: Access tutorials) - (Nightowl) - (1) - Oct. 2, 2003, 04:19:41 PM EDT
                 Glad to hear it - (orion) - Oct. 2, 2003, 05:29:23 PM EDT
         the first thing to do - (cforde) - (2) - Oct. 1, 2003, 01:25:49 AM EDT
             Better yet - (orion) - (1) - Oct. 1, 2003, 07:54:21 PM EDT
                 Not that I recommend it... - (ChrisR) - Oct. 1, 2003, 08:58:48 PM EDT

Na'ghimgor thdid lym.
Myn th'x barsoom lu'gndar.
In'path gix mth'nabor.
In'path nox vel'dekk.
Yig sudeth M'cylorum.
M'xxlit kraddath Soggoth im'betnk.
Nog s'dath blexmed!
73 ms