Show Me Microsoft Office Access 2003

Are there certain elements I can build into my field designs

Can I modify my fields in design view

I need to change my original field data type

Input mask, captions, validation rules, it's all very confusing

When determining my fields, is there a way to estimate field size that is stored

Can I set up a format so that data is only displayed that way in the field

There are certain field that I want to be required entries

How can I make sure that the correct information is entered

What are look up properties

I need to add a field to a query

Can i pull other fields from different tables to do a query

How do I specify a criteria for multiple fields

What is Expression Builder and how does it work with my fields

Is there a way to find out if my database has duplicate fields