Newbie question about Access and report

[Susan]

I understand that Access database can be created from Excel file. If you
have an Excel file that has each row containing data pertaining to each
individual, is it possible to produce a report where each page will contain
the information for just that row and print it out?

If you have a form each form contains data provided by individual for class
that they would like to teach. The data is then converted to Access data
base. Is it possible to use Access reporting to generate a printed page for
each potential class. In other words if you have a table or spreadsheet in
Excel and each row contains data for each class-- like course title, course
description, starting date, ending date, teacher name, supplies required
(fees), presentation equipement needed, etc. If this was converted to
Access, is there a way to produce printed report with Access so that each
row is printed on a page so that each page contains data for one course.
Therefore paper-oriented person use it and file it away in filing cabinet?

 

[Arvin Meyer [MVP]]

Absolutely.

Simply create the report and place a pagebreak control after a row of data,
each subsequent page will print on its own sheet. Use a Page Header/footer
instead of report header/footer to make sure each page has the same
header/footer

 

[Susan]

Thank you very much. I am about to order Microsoft Office Access(TM) 2007
Inside Out (Microsoft Office Access Inside Out). Do you know any other
books you would recommend?

 

[Arvin Meyer [MVP]]

Excellent choice. Another good one is:

Access 2007 VBA Programmer's Reference (Programmer to Programmer) by Teresa
Hennig, Armen Stein, and a few others

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com