Inserting header/footer in MS Access 2000?

  Llwydyn 00:28 29 Aug 05
Locked

I would like to have a class of pupils working on the same database in MS Access (for initial introduction practice prior to creating their own database). Is it at all possible to insert a header/footer or change the contents of the "print headings" when working with Tables and Queries? (they need to personolise their work in order to know whose work is being printed).

  Durko 12:23 29 Aug 05

Lwydyn

Have a look at this link should be of help.

click here

Durko

  Llwydyn 21:50 29 Aug 05

Thanks for the link Durko, but no info. unfortunately.
It appears that the only solution is to create a report based on the tables/queries in order to be able to personolise the printouts with their names (I was hoping to initially keep the procedure as simple as possible).

  lotvic 10:46 31 Aug 05

the only way to individualise each printout with students name is to rename the table by adding their name after you/they have copied the Master Table to their pc


1. Open Access


2. Open an exiisting file and select the Table to Open then click on OK


3. Make sure that 'Tables' is selected in the Objects pane


4. Right click on the table name (ie: Test Table) and click on 'rename' then add the students name (ie: Fred Bloggs Test Table) and press Enter on keyboard


If you/they create a Form to display the contents of the Table then it is a good idea to include the Object in the name (ie: when you save the Form call it Fred Bloggs Test Form)



This is how I was taught to do it at evening class at college

  Llwydyn 12:33 31 Aug 05

Thanks for your suggestion lotvic.

The procedure you suggest is the method I do use with older pupils regarding coursework.

I always insist my pupils include at least their names in a footer (something they are able to do with most packages). As I mentioned earlier, the correct procedure I suppose is to create a report based on the tables and the outcomes of the queries.

Although I'm aware that MS Works does allow inserting a footer, we are not in a situation to be able to use it unfortunately!

Again thanks for your interest and suggestion.

This thread is now locked and can not be replied to.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

iPhone 9 and beyond: 32 amazing future smartphone developments - graphene, supercapacitor…