Basic Form Examples in Access.

C

Chiki

hi,

i m very new to access. I want to Learn Access from the very basic.
I just need some help in creating forms & retrieving data into form using
tables queries & forms. I had created a Contacts_table containing field which
i entered the data using the Form into the table.

I want to Create a form from which i want to retrieve data based on the
Contacts of the persons in the table like Basing on the First_Name,Area_Code
& Location.

Also please give me any links of the examples that may be helpful like this.
 
C

Chiki

C

Chiki

Is it possible to Display data in the form using the tables as the back-end
database.if so ,please provide me any examples....i want to study
them..........
thanks in advance.
 
J

John Spencer

Yes it is possible. It is usually better to set the form's record source to a
query than to a table.

Examples:
Duane Hookom has a sample survey database "At Your Survey" at

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=4

This fully functional application uses a small collection of tables, queries,
forms, reports, and code to manage multiple surveys. Users can create a
survey, define questions, enter pre-defined answers, limit to list, report
results, create crosstabs, and other features without changing the design of
any objects.

Allen Browne has some sample databases at
http://allenbrowne.com/tips.html#Application
Just look for links that are tagged with sample Database in the descriptions

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
VBA - retrieve data on last create named range from previous inserted named range 0
Retrieve data from Access database and fill data in form 0
Access Passing data from a form to another form! 0
Access #Error & Excel Pivot 0
Access Need help in making asset history in my current database. 1
Access Sub form opens before the main form in MS Access 0
Having problems understanding sub-form selections and uses of comb 2

Top