Where to start for entries, reports

I'm not aware of Microsoft Database. What is it?

Bonnie
http://www.dataplus-svc.com

KT wrote:
>I've been using Excel and Microsoft Database prior, to create a database of
>Foundations. I'm trying to switch over to Access 2007, but I need to be able
>to see a report in the same way you can see it in Database, a viewable report
>for a single entry. I've been trying the wizards, as well as the tutorials,
>but I can't seem to find anything that points me in the correct direction.
>I'm starting to wonder if this is even possible or if I'm going about the
>database in the wrong way. Do I have to switch back to Database? Is there a
>tutorial or wizard that someone can point me to?
>Thanks so much for your help!

--
Message posted via http://www.accessmonster.com

Microsoft Database was a Works program that allowed you to create a simple
form, and enter the data in an excel-style spreadsheet. You could then view
the data in the form entry by entry. Now I need a program where, lets say a
memo needs to be written, I can take Columns B,D,F,H-R, and enter the data
for Entry 17 and put them into the memo.
I'm sure it's possible to do this in Access, but it's not the most
user-friendly program. I've tried to the tutorials and the wizards to try and
figure out how to create this, but I'm still in the dark. I'm asking if there
are any better and more in depth tutoritals I could be pointed to. I've tried
to play with the forms, but it just won't do what I need it to at this point.

"John W. Vinson/MVP" wrote:

> On Tue, 29 Jul 2008 09:21:03 -0700, KT <KT.TakeThisOut@discussions.microsoft.com>
> wrote:
>
> >I've been using Excel and Microsoft Database prior, to create a database of
> >Foundations. I'm trying to switch over to Access 2007, but I need to be able
> >to see a report in the same way you can see it in Database, a viewable report
> >for a single entry. I've been trying the wizards, as well as the tutorials,
> >but I can't seem to find anything that points me in the correct direction.
> >I'm starting to wonder if this is even possible or if I'm going about the
> >database in the wrong way. Do I have to switch back to Database? Is there a
> >tutorial or wizard that someone can point me to?
> >Thanks so much for your help!
>
> Microsoft Access is not a flawed implementation of Microsoft Database
> (if indeed the latter program even exists; do you mean Works, or some
> other program?)
>
> If you want to see and interact with data onscreen, a Form is the
> preferred tool. If you want to print it to paper, a Report is
> appropriate. You can open a Report in preview mode to see it onscreen.
> A Report can be based on a query which selects a single record, or you
> can use code to open a report (or form) to a selected record. Just how
> you would do so depends on your table structure and just how you have
> the database set up - which of course we cannot see.
>
> --
>
> John W. Vinson/MVP
>

KT wrote:
> Microsoft Database was a Works program that allowed you to create a simple
> form, and enter the data in an excel-style spreadsheet. You could then view
> the data in the form entry by entry. Now I need a program where, lets say a
> memo needs to be written, I can take Columns B,D,F,H-R, and enter the data
> for Entry 17 and put them into the memo.
> I'm sure it's possible to do this in Access, but it's not the most
> user-friendly program. I've tried to the tutorials and the wizards to try and
> figure out how to create this, but I'm still in the dark. I'm asking if there
> are any better and more in depth tutoritals I could be pointed to. I've tried
> to play with the forms, but it just won't do what I need it to at this point.
>
> "John W. Vinson/MVP" wrote:
>
>> On Tue, 29 Jul 2008 09:21:03 -0700, KT <KT.RemoveThis@discussions.microsoft.com>
>> wrote:
>>
>>> I've been using Excel and Microsoft Database prior, to create a database of
>>> Foundations. I'm trying to switch over to Access 2007, but I need to be able
>>> to see a report in the same way you can see it in Database, a viewable report
>>> for a single entry. I've been trying the wizards, as well as the tutorials,
>>> but I can't seem to find anything that points me in the correct direction.
>>> I'm starting to wonder if this is even possible or if I'm going about the
>>> database in the wrong way. Do I have to switch back to Database? Is there a
>>> tutorial or wizard that someone can point me to?
>>> Thanks so much for your help!
>> Microsoft Access is not a flawed implementation of Microsoft Database
>> (if indeed the latter program even exists; do you mean Works, or some
>> other program?)
>>
>> If you want to see and interact with data onscreen, a Form is the
>> preferred tool. If you want to print it to paper, a Report is
>> appropriate. You can open a Report in preview mode to see it onscreen.
>> A Report can be based on a query which selects a single record, or you
>> can use code to open a report (or form) to a selected record. Just how
>> you would do so depends on your table structure and just how you have
>> the database set up - which of course we cannot see.
>>
>> --
>>
>> John W. Vinson/MVP
>>

Google for Access 2007 tutorial you will get quite a few hits.

Here's just one as an example

http://inpics.net/tutorials/access2007/basics.html

gls858

Visit Office Online at http://office.microsoft.com, and follow the links to
training. I know the Access 2003 online training was pretty good, and know
there are updates for Access 2007 -- though I don't know how many have been
converted, nor how good they are, comparatively speaking. Access MVP
Crystal Long has training material at
http://www.accessmvp.com/Strive4Peace/Index.htm. A good book for the novice
is "Access 2007 Step by Step" from Microsoft Press; one that starts at the
beginning and goes deeper is "Access 2007 Inside Out" by Viescas and Conrad
from Microsoft Press.

Larry Linson
Microsoft Office Access MVP


"gls858" <gls858 RemoveThis @yahoo.com> wrote in message
news:%2381smnx9IHA.5404@TK2MSFTNGP04.phx.gbl...
> KT wrote:
>> Microsoft Database was a Works program that allowed you to create a
>> simple form, and enter the data in an excel-style spreadsheet. You could
>> then view the data in the form entry by entry. Now I need a program
>> where, lets say a memo needs to be written, I can take Columns B,D,F,H-R,
>> and enter the data for Entry 17 and put them into the memo. I'm sure it's
>> possible to do this in Access, but it's not the most user-friendly
>> program. I've tried to the tutorials and the wizards to try and figure
>> out how to create this, but I'm still in the dark. I'm asking if there
>> are any better and more in depth tutoritals I could be pointed to. I've
>> tried to play with the forms, but it just won't do what I need it to at
>> this point. "John W. Vinson/MVP" wrote:
>>
>>> On Tue, 29 Jul 2008 09:21:03 -0700, KT <KT RemoveThis @discussions.microsoft.com>
>>> wrote:
>>>
>>>> I've been using Excel and Microsoft Database prior, to create a
>>>> database of Foundations. I'm trying to switch over to Access 2007, but
>>>> I need to be able to see a report in the same way you can see it in
>>>> Database, a viewable report for a single entry. I've been trying the
>>>> wizards, as well as the tutorials, but I can't seem to find anything
>>>> that points me in the correct direction. I'm starting to wonder if this
>>>> is even possible or if I'm going about the database in the wrong way.
>>>> Do I have to switch back to Database? Is there a tutorial or wizard
>>>> that someone can point me to?
>>>> Thanks so much for your help!
>>> Microsoft Access is not a flawed implementation of Microsoft Database
>>> (if indeed the latter program even exists; do you mean Works, or some
>>> other program?)
>>>
>>> If you want to see and interact with data onscreen, a Form is the
>>> preferred tool. If you want to print it to paper, a Report is
>>> appropriate. You can open a Report in preview mode to see it onscreen.
>>> A Report can be based on a query which selects a single record, or you
>>> can use code to open a report (or form) to a selected record. Just how
>>> you would do so depends on your table structure and just how you have
>>> the database set up - which of course we cannot see.
>>>
>>> --
>>>
>>> John W. Vinson/MVP
>>>
>
> Google for Access 2007 tutorial you will get quite a few hits.
>
> Here's just one as an example
>
> http://inpics.net/tutorials/access2007/basics.html
>
> gls858

You've been pointed in the right direction for some tutorials for Access 2007,
but you need to understand this: Works Database is a point-and-click program
designed to produce very simple databases. Access, on the other hand, is a
complex, full fledged RDBM system. The chances that you will be able to
develop a comparable database in Access, after only an hour or two of reading
tutorials, is slim. You're really going to have to devote some time to
learning the basics.

Good luck!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200808/1