Building a Simple Database

I work as an electronic signal specialist (or electronic/computer tech) at
CSX railroad, started employment about 5.5 months ago.

A majority of our repairs are logged in a standard journal or notebook.
Nevertheless, most of the senior techs will not upgrade to a more
sophisticated method of storing data, but if a database is built then they
will use it.

Recently, I purchased a book called "Absolute Beginner's Guide to Microsoft
Office 2003", read 5 chapters; however, their examples does not mesh with my
ideas of designing a simple database. I could use excel, yet access provides
a centralized way of finding data. The book advises that creating tables is
the initial path to go and has three ways of creating a table. I chose "Start
Typing Data into a Blank Table" since excel is my preferred choice (and the
book advised using this method if a user works with excel often); the others
are "Using the Table Wizard" and "Work Directly in Table Design View".

Here are the fields that I want to use:

1. Date
2. Name
3. Incident
4. Description
4. Resolution

When using the method "Start Typing Data into a Blank Table", the
description field will allow someone only to type a certain number of
characters. How can you change the program to allow an infinite number of
characters? The reason the field requires more characters is the technician
writing the explanation to the incident might have a lengthy description.

Any suggestions would be helpful!

On another note, I realize this newsgroup is for MCSD only. However, I deem
a response on this newsgroup is faster and more accurate.


BNS6
MCDST, A+, Network +





--
BNS6

=?Utf-8?B?Qk5TNg==?=

I may already have a DB that you can use. All you would need to do is change the
field names.

Use this form to contact me so that I can send you an email:
http://www.CertGuard.com/contact.asp

--
CertGuard




"BNS6" <> wrote in message
news:2C384A70-F574-4D23-9AF0-...
>I work as an electronic signal specialist (or electronic/computer tech) at
> CSX railroad, started employment about 5.5 months ago.
>
> A majority of our repairs are logged in a standard journal or notebook.
> Nevertheless, most of the senior techs will not upgrade to a more
> sophisticated method of storing data, but if a database is built then they
> will use it.
>
> Recently, I purchased a book called "Absolute Beginner's Guide to Microsoft
> Office 2003", read 5 chapters; however, their examples does not mesh with my
> ideas of designing a simple database. I could use excel, yet access provides
> a centralized way of finding data. The book advises that creating tables is
> the initial path to go and has three ways of creating a table. I chose "Start
> Typing Data into a Blank Table" since excel is my preferred choice (and the
> book advised using this method if a user works with excel often); the others
> are "Using the Table Wizard" and "Work Directly in Table Design View".
>
> Here are the fields that I want to use:
>
> 1. Date
> 2. Name
> 3. Incident
> 4. Description
> 4. Resolution
>
> When using the method "Start Typing Data into a Blank Table", the
> description field will allow someone only to type a certain number of
> characters. How can you change the program to allow an infinite number of
> characters? The reason the field requires more characters is the technician
> writing the explanation to the incident might have a lengthy description.
>
> Any suggestions would be helpful!
>
> On another note, I realize this newsgroup is for MCSD only. However, I deem
> a response on this newsgroup is faster and more accurate.
>
>
> BNS6
> MCDST, A+, Network +
>
>
>
>
>
> --
> BNS6

Robert Williams [CertGuard]

Rob:

I sent you a reply on "CertGuard".
--
BNS6


"Robert Williams [CertGuard]" wrote:

> I may already have a DB that you can use. All you would need to do is change the
> field names.
>
> Use this form to contact me so that I can send you an email:
> http://www.CertGuard.com/contact.asp
>
> --
> CertGuard
>
>
>
>
> "BNS6" <> wrote in message
> news:2C384A70-F574-4D23-9AF0-...
> >I work as an electronic signal specialist (or electronic/computer tech) at
> > CSX railroad, started employment about 5.5 months ago.
> >
> > A majority of our repairs are logged in a standard journal or notebook.
> > Nevertheless, most of the senior techs will not upgrade to a more
> > sophisticated method of storing data, but if a database is built then they
> > will use it.
> >
> > Recently, I purchased a book called "Absolute Beginner's Guide to Microsoft
> > Office 2003", read 5 chapters; however, their examples does not mesh with my
> > ideas of designing a simple database. I could use excel, yet access provides
> > a centralized way of finding data. The book advises that creating tables is
> > the initial path to go and has three ways of creating a table. I chose "Start
> > Typing Data into a Blank Table" since excel is my preferred choice (and the
> > book advised using this method if a user works with excel often); the others
> > are "Using the Table Wizard" and "Work Directly in Table Design View".
> >
> > Here are the fields that I want to use:
> >
> > 1. Date
> > 2. Name
> > 3. Incident
> > 4. Description
> > 4. Resolution
> >
> > When using the method "Start Typing Data into a Blank Table", the
> > description field will allow someone only to type a certain number of
> > characters. How can you change the program to allow an infinite number of
> > characters? The reason the field requires more characters is the technician
> > writing the explanation to the incident might have a lengthy description.
> >
> > Any suggestions would be helpful!
> >
> > On another note, I realize this newsgroup is for MCSD only. However, I deem
> > a response on this newsgroup is faster and more accurate.
> >
> >
> > BNS6
> > MCDST, A+, Network +
> >
> >
> >
> >
> >
> > --
> > BNS6
>
>

=?Utf-8?B?Qk5TNg==?=

Always create the structural design of your table first, including
setting valid datatypes, column lengths, formats and only then start
typing in data. That should be the Table design view, IIRC.

If you want a longer text field, use the Memo datatype.

Cerebrus

Hmmm...sorry, haven't received it.

send it to CertGuard at yahoo.

--
CertGuard




"BNS6" <> wrote in message
news:2C76E379-A2DC-4C6F-A5F8-...
> Rob:
>
> I sent you a reply on "CertGuard".
> --
> BNS6
>
>
> "Robert Williams [CertGuard]" wrote:
>
>> I may already have a DB that you can use. All you would need to do is
>> change the
>> field names.
>>
>> Use this form to contact me so that I can send you an email:
>> http://www.CertGuard.com/contact.asp
>>
>> --
>> CertGuard
>>
>>
>>
>>
>> "BNS6" <> wrote in message
>> news:2C384A70-F574-4D23-9AF0-...
>> >I work as an electronic signal specialist (or electronic/computer tech)
>> >at
>> > CSX railroad, started employment about 5.5 months ago.
>> >
>> > A majority of our repairs are logged in a standard journal or notebook.
>> > Nevertheless, most of the senior techs will not upgrade to a more
>> > sophisticated method of storing data, but if a database is built then
>> > they
>> > will use it.
>> >
>> > Recently, I purchased a book called "Absolute Beginner's Guide to
>> > Microsoft
>> > Office 2003", read 5 chapters; however, their examples does not mesh
>> > with my
>> > ideas of designing a simple database. I could use excel, yet access
>> > provides
>> > a centralized way of finding data. The book advises that creating
>> > tables is
>> > the initial path to go and has three ways of creating a table. I chose
>> > "Start
>> > Typing Data into a Blank Table" since excel is my preferred choice (and
>> > the
>> > book advised using this method if a user works with excel often); the
>> > others
>> > are "Using the Table Wizard" and "Work Directly in Table Design View".
>> >
>> > Here are the fields that I want to use:
>> >
>> > 1. Date
>> > 2. Name
>> > 3. Incident
>> > 4. Description
>> > 4. Resolution
>> >
>> > When using the method "Start Typing Data into a Blank Table", the
>> > description field will allow someone only to type a certain number of
>> > characters. How can you change the program to allow an infinite number
>> > of
>> > characters? The reason the field requires more characters is the
>> > technician
>> > writing the explanation to the incident might have a lengthy
>> > description.
>> >
>> > Any suggestions would be helpful!
>> >
>> > On another note, I realize this newsgroup is for MCSD only. However, I
>> > deem
>> > a response on this newsgroup is faster and more accurate.
>> >
>> >
>> > BNS6
>> > MCDST, A+, Network +
>> >
>> >
>> >
>> >
>> >
>> > --
>> > BNS6
>>
>>

Robert Williams [CertGuard]

Send database to
--
BNS6


"Robert Williams [CertGuard]" wrote:

> Hmmm...sorry, haven't received it.
>
> send it to CertGuard at yahoo.
>
> --
> CertGuard
>
>
>
>
> "BNS6" <> wrote in message
> news:2C76E379-A2DC-4C6F-A5F8-...
> > Rob:
> >
> > I sent you a reply on "CertGuard".
> > --
> > BNS6
> >
> >
> > "Robert Williams [CertGuard]" wrote:
> >
> >> I may already have a DB that you can use. All you would need to do is
> >> change the
> >> field names.
> >>
> >> Use this form to contact me so that I can send you an email:
> >> http://www.CertGuard.com/contact.asp
> >>
> >> --
> >> CertGuard
> >>
> >>
> >>
> >>
> >> "BNS6" <> wrote in message
> >> news:2C384A70-F574-4D23-9AF0-...
> >> >I work as an electronic signal specialist (or electronic/computer tech)
> >> >at
> >> > CSX railroad, started employment about 5.5 months ago.
> >> >
> >> > A majority of our repairs are logged in a standard journal or notebook.
> >> > Nevertheless, most of the senior techs will not upgrade to a more
> >> > sophisticated method of storing data, but if a database is built then
> >> > they
> >> > will use it.
> >> >
> >> > Recently, I purchased a book called "Absolute Beginner's Guide to
> >> > Microsoft
> >> > Office 2003", read 5 chapters; however, their examples does not mesh
> >> > with my
> >> > ideas of designing a simple database. I could use excel, yet access
> >> > provides
> >> > a centralized way of finding data. The book advises that creating
> >> > tables is
> >> > the initial path to go and has three ways of creating a table. I chose
> >> > "Start
> >> > Typing Data into a Blank Table" since excel is my preferred choice (and
> >> > the
> >> > book advised using this method if a user works with excel often); the
> >> > others
> >> > are "Using the Table Wizard" and "Work Directly in Table Design View".
> >> >
> >> > Here are the fields that I want to use:
> >> >
> >> > 1. Date
> >> > 2. Name
> >> > 3. Incident
> >> > 4. Description
> >> > 4. Resolution
> >> >
> >> > When using the method "Start Typing Data into a Blank Table", the
> >> > description field will allow someone only to type a certain number of
> >> > characters. How can you change the program to allow an infinite number
> >> > of
> >> > characters? The reason the field requires more characters is the
> >> > technician
> >> > writing the explanation to the incident might have a lengthy
> >> > description.
> >> >
> >> > Any suggestions would be helpful!
> >> >
> >> > On another note, I realize this newsgroup is for MCSD only. However, I
> >> > deem
> >> > a response on this newsgroup is faster and more accurate.
> >> >
> >> >
> >> > BNS6
> >> > MCDST, A+, Network +
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> > BNS6
> >>
> >>
>

=?Utf-8?B?Qk5TNg==?=