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

forms

ResolvedVersion 2003

Doug has attended:
Access Introduction course

Forms

Is it possible to creat blank forms that people use to enter details to the database? I think I only saw forms that were continuations of existing entries.

RE: Forms

Hi Doug,

Thank you for your question.

When you create your tables in your database in Design View, you can then create forms based on the tables.

This form will be blank and ready for you to enter your records. Once you have entered some records, you can also use the form to add additional records or edit existing records.

I hope this answers your question.

Regards

Simon

Wed 29 Apr 2009: Automatically marked as resolved.

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.