access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2003

Access 2003

resolvedResolved · Low Priority · Version 2003

Doreen has attended:
Access Introduction course
Excel Introduction course
Excel Intermediate course
Access Intermediate course
Access Advanced course
Excel Advanced course

Access 2003

How do I use autoform?

RE: Access 2003

Dear Doreen

Thank you for attending Access Introduction Course!! I hope you enjoyed the course and benefited from it.

To create an Auto form please follow these steps:

1. From the objects bar on the left hand side click on the Forms.

2. Click on the new Button

3. Choose Autoform Columnar, Tabular or Datasheet depending how you want to view the data.

4. Choose the Table or the query you want to create the form for from the small drop down list

5. Press OK

The form will be created. You need to ensure that you save the form with an appropriate name by clicking on the Save button.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Tue 10 Mar 2009: Automatically marked as resolved.


 

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips


Server loaded in 0.08 secs.