Where to start for entries, reports

[KT]

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!

 

[John W. Vinson/MVP]

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.

 

[KT]

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.

 

[gls858]

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.

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

 

[Larry Linson]

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