Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / September 2007

Tip: Looking for answers? Try searching our database.

Newbie question about Access and report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Susan - 26 Sep 2007 15:30 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.