ok, first you need a query. The query that leads to the form should be
simple. Try not to use multiple tables. If you want to connect tables, you
should create the extra tables as subforms and link them into the main form.
For the report you will also need to create queries. I am not sure what your
skill level is on queries but the design view is pretty user friendly and
searching the internet for help on queries is possible. Once you have a query
that provides the data that you want to show on the report (note, it will not
contain totals, counts, etc, since that can be done in the report), you
should run the Report Wizard (this is one of the choices when you hit New
Report). The report wizard is very helpful and gives you options for sorting,
grouping, and totals.
I am sorry if this is too simplistic for you. You may want to go through
some tutorials on creating reports and forms, although I do not know of any
off hand. I would be much more help if you ask a specific question about one
of the pieces of your project.