Re: Access is just to hard to understand


--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy


"Paul (ESI)" wrote:

> Access can be pretty hard when you are just a beginner. It becomes easier as
> you go, but it sure is a weird application. It is definitely not one you can
> learn by simply jumping in head first. You need some kind of outside
> assistance.
>
> --
> Have a nice day!
>
> ~Paul
> Express Scripts,
> Charting the future of pharmacy
>
>
> "Harold via AccessMonster.com" wrote:
>
> > Thanks Bob
> >
> >
> > >>Tom
> > >
> > >The first thing I would do is decide what you want your database to do,
> > >decide what data you need to do it, and then, design the tables (all without
> > >even opening Access.)
> > >For example: You want to be able to look up contacts phone #'s and addresses
> > >and print mailing labels.
> > >You will probably want last name, first name, middle initial, street address
> > >(for FedEx, etc.), mailing address, city, state, zip, phone number.
> > >In this example you will need only one table that will have all of the above
> > >fields.
> > >Now open Access and a new blank db. When asked, name it Contacts or
> > >Contacts_be. The be stands for back end. I recommend that you create a
> > >backend db for tables that will be shared by users. Each user can link to
> > >the backend db tables.
> > >Select New on the Tables tab of your db. I recommend Design View so you can
> > >control all aspects of the design.
> > >In the first Field Name blank type LastName (It is best that all names have
> > >no blanks, that way if you ever convert to SQL you're set), press Tab and
> > >type t (Text will appear). Continue with the rest and you have your table.
> > >Save it with a logical name like Contacts.
> > >For queries, forms, and reports use the wizards.
> >
> >
> > --
> > Message posted via AccessMonster.com
> > http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200508/1
> >
.

Relevant Pages