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] - 26 Sep 2007 16:11 GMT
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

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
>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
[quoted text clipped - 12 lines]
> contains data for one course. Therefore paper-oriented person use it and
> file it away in filing cabinet?
Susan - 26 Sep 2007 16:58 GMT
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?
> Absolutely.
>
[quoted text clipped - 18 lines]
>> page contains data for one course. Therefore paper-oriented person use
>> it and file it away in filing cabinet?
Arvin Meyer [MVP] - 26 Sep 2007 23:41 GMT
Excellent choice. Another good one is:
Access 2007 VBA Programmer's Reference (Programmer to Programmer) by Teresa
Hennig, Armen Stein, and a few others

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
> 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
[quoted text clipped - 22 lines]
>>> each page contains data for one course. Therefore paper-oriented person
>>> use it and file it away in filing cabinet?