A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Basic Form Examples in Access.



 
 
Thread Tools Display Modes
  #1  
Old April 21st, 2010, 06:37 AM posted to microsoft.public.access.gettingstarted
Chiki
external usenet poster
 
Posts: 22
Default Basic Form Examples in Access.

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.
  #2  
Old April 21st, 2010, 01:03 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default Basic Form Examples in Access.

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

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

Chiki wrote:
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.

  #3  
Old April 21st, 2010, 05:24 PM posted to microsoft.public.access.gettingstarted
Chiki
external usenet poster
 
Posts: 22
Default Basic Form Examples in Access.



"John Spencer" wrote:

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

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

Chiki wrote:
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.

.


Thanks for the links.
  #4  
Old April 23rd, 2010, 03:48 AM posted to microsoft.public.access.gettingstarted
Chiki
external usenet poster
 
Posts: 22
Default Basic Form Examples in Access.

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.
  #5  
Old April 23rd, 2010, 01:11 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default Basic Form Examples in Access.

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/f...pics.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

Chiki wrote:
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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.