Creating a searchable field database

[vipertblck]

I may be in the wrong forum, I apologize in advance if so. Anyway, I've attempted to attach a Word Doc that shows fields I've labeled (customer, date, application & so on). Is there a way to put all this into an Access Document, and create a database that I could search by customer, or by serial #? I've got about 400 of these, but it's all in folders on paper now, would be much easier to do it in an Access database.

Thanks in advance
Kevin

[ranman256]

no,
normally you go FROM access to word via merge. (not the other way)

Now, you could just copy and paste the tables into access.
A VB programmer could scan every document, do the copy paste in to access.

[vipertblck]

I'm not all that familiar with Access, so not sure what all that means. I only took a bit of an Access course in once of my classes earlier this year, it was pretty brief.

[vipertblck]

any idea how I could go about setting this up in an access database? or are there any tutorials anybody would recommend online here?

[June7]

Analyze and build - maybe this will help http://www.rogersaccesslibrary.com/

[vipertblck]

Analyze and build - maybe this will help http://www.rogersaccesslibrary.com/

I'm not sure where I'm suppose to look and follow along in there. maybe this is too complex for me to handle....

[vipertblck]

I attached what I whipped up so far. It has all the fields in the columns that I desire, but I want to be able to click on each row (different numberized unit) to get details/notes about it and I can write about it everytime I work on it. For example, customer a and b are both in there right now, obviously all the fields for their units are not filled in, but the two customers are there. Is there a way I can click on the customers and view more details or open a new window that I can type in a bunch of notes?

[June7]

Of course, use code. https://support.office.com/en-US/Art...rs=en-US&ad=US

Access coding is event driven.

Form and controls have Click event.

[ssanfu]

Some hints/thoughts/whatever ........

From looking at the field names:
ONLY use letters and numbers in object names - NO spaces, punctuation or special characters (underscore is the exception)

Don't use a text field as the PK field. I always use an autonumber. Text fields can be used, but are problematic. If you want to change a customer name from "Joe Blow" to "Joe Blow and Sons", you have just destroyed the links to other tables.
See
Autonumbers--What they are NOT and What They Are
http://www.utteraccess.com/wiki/index.php/Autonumbers

Microsoft Access Tables: Primary Key Tips and Techniques
http://www.fmsinc.com/free/newtips/primarykey.asp

Use Autonumbers properly
http://access.mvps.org/access/general/gen0025.htm



"Date" is a reserved word and shouldn't be used for object names. Here is a list of reserved words:http://www.allenbrowne.com/AppIssueBadWord.html
Plus, "Date" is not very descriptive.....

In a normalized table structure, "Customers" would be in their own table.

[vipertblck]

Of course, use code. https://support.office.com/en-US/Art...rs=en-US&ad=US

Access coding is event driven.

Form and controls have Click event.

Where about do I go here in this link? The VBA thing or the Macros thing? I'm not really familiar with Access at all, so a step by step thing is what I need. It's not easy for me, but I want to try and learn how to do this and get it going, it will make things MUCH easier in the long run...

[orange]

If you are going to use database, you should get familiar with the concepts.
There are a number of links here to help you get oriented.
Good luck.

[June7]

We can't walk you through building a db from beginning to end. We can guide you to resources and analyze specific issues.