Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How can we create a form to enter and view data in Microsoft Access?

user-image
Question ajoutée par Lubna Al-Sharif , Medical Laboratory Technician , Nablus Specailized Hospital
Date de publication: 2013/11/25
Ahamed Shareef
par Ahamed Shareef , Divisional Head - Quality Assurance , Apollo Tyres Ltd

I think the link is as below for MS Access training-

http://office.microsoft.com/en-001/access-help/training-courses-for-access-2013-HA.aspx

Even if you have issue with the link, please go to Microsoft office page and go to training tab. You can find all the training materials there

Muhammad Usman Usman
par Muhammad Usman Usman , Sr. IT Network Support Engineer , Imtiaz Super Market

Dear Friends;

 

When you use MS Excel  and make new work sheet, and then you put value in the cell, so you can easily remove and edit from keyboard.

If you need  any help so please call me on skype:-

usman_classic is my Skype id.

 

Thanking you,

Muhammad Usman

 

Ali Raza Syed
par Ali Raza Syed , Virtual Assistant (Online) , PIDC-LC

You have not specified which version you are using? Although there's no any big difference if you are using any version between2007 to2012, but if you are still using2003 then there's a big change. Please speficy which version of Microsoft Access you are using?

 

For access2003 you can use the following link. On this link you'll find all necessary information, hopefully.

 

http://office.microsoft.com/en-001/access-help/forms-i-create-a-form-to-enter-and-view-your-data-RZ.aspx

 

Alabbas Bin Ali Bin Ali Yahya Hamidaddin
par Alabbas Bin Ali Bin Ali Yahya Hamidaddin , Planner , Pottery Barn - M. H. Alshaya Co

to use form is better to create the tables first than you can use the form and linked it to table because the tables are the database but forms are the interface to enter the data

Farhad Awan
par Farhad Awan , circular road , ideal cards

newest first

Utilisateur supprimé
par Utilisateur supprimé

Form must be built based on the main table, which was designed to determinethe beginning and thefieldsin the construction ofthe database andof courseselect the keysthat defineanyof these fieldswill be ofunique value. Thenwe designthe fiorm basedonthis table. Sometimesdesignermakes abig mistakewhenhe build thereportdepending on the form, it is very necessary todesign a query at first todeterminethe data we want to show in the report, because reports are printable, or could be published several ways, pdf, xls, doc, or could be sent by email, of course you are not going to send the whole database, so you must use queries.

AHMAD AL-KHATEEB
par AHMAD AL-KHATEEB , Sr. Electrical Eng. , Engicon

First you must add a table to store the data you want to enter it from the form

Then you need to make query to have the d information you want from the data you entered

 

Then you need to design the form with the right tools as text boxes and buttons…etc

More Questions Like This