T
tamim
how can i learne progrmming
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Tamim,
In learning how to program in Access, I would prioritize the following:
- Fully understand Database Normalization. The better your application
tables follow the normalization rules, the less programming will be required,
and the more straightforward it will be.
- Fully understand table "relationships", and foreign keys. In a relational
database, each table should describe attributes of ONE thing, and their
fields should NOT be duplicated in another table. For example, a Customer
table describes the Name, Address, etc. of each Customer. An Orders table,
which stores Customer orders, only requires a foreign key, that is the
primary key of Customers to identify the customer who placed the order. Any
other Customer fields that are required for display or printing are obtained
by linking the two tables by the common field in a query, or by using the
Column property of a combo box.
- Study the sample applications that come with Access. Look at the forms
they use. Explore their properties. Change a property temporarily and see
its effect. Look at the code behind command buttons, AfterUpdate events, to
see what's happening.
- Use the Wizard to place a command button (enable by View, Toolbox, toggle
on the button with a wand and stars). It will ask you what task you want to
do. Then study the code it writes to see how it's doing it.
- Learn how to use the VBA Help system (Help from Module edit mode). You
can look up something specific, or place the cursor on a keyword and press
<F1>. Use the "See Also" and "Example" links to further explore a topic.
- Purchase a comprehensive reference book appropriate to your level of
proficiency. Skim its topics so you understand what it covers, but it's up
to you if you want to read it cover to cover.
- Plan carefully what you want to do, and study examples from similar
situtations in the sample applications.
- When you get stuck, search this Newsgroup forum for similar postings that
might have the answers you're looking for.
- If you can't find anything of help, post a question to the Newsgroup.
In summary, learning Access programming is iterative, and will develop as
you solve new problems. You can learn a little by just diving in, however,
the basics of table normalization, relationships, forms & subforms, the
difference between a *field*, which is where data is *stored* in a table, and
has a specific datatype (Text, Number, etc.) and a form or report *control*
(which is a container where data is *displayed*, and may or may not be
*bound* to a table field) IMO should be mastered before you dive into
programming, or it will be a long struggle.
Good luck.
Hope this helps.
Sprinks
In learning how to program in Access, I would prioritize the following:
- Fully understand Database Normalization. The better your application
tables follow the normalization rules, the less programming will be required,
and the more straightforward it will be.
- Fully understand table "relationships", and foreign keys. In a relational
database, each table should describe attributes of ONE thing, and their
fields should NOT be duplicated in another table. For example, a Customer
table describes the Name, Address, etc. of each Customer. An Orders table,
which stores Customer orders, only requires a foreign key, that is the
primary key of Customers to identify the customer who placed the order. Any
other Customer fields that are required for display or printing are obtained
by linking the two tables by the common field in a query, or by using the
Column property of a combo box.
- Study the sample applications that come with Access. Look at the forms
they use. Explore their properties. Change a property temporarily and see
its effect. Look at the code behind command buttons, AfterUpdate events, to
see what's happening.
- Use the Wizard to place a command button (enable by View, Toolbox, toggle
on the button with a wand and stars). It will ask you what task you want to
do. Then study the code it writes to see how it's doing it.
- Learn how to use the VBA Help system (Help from Module edit mode). You
can look up something specific, or place the cursor on a keyword and press
<F1>. Use the "See Also" and "Example" links to further explore a topic.
- Purchase a comprehensive reference book appropriate to your level of
proficiency. Skim its topics so you understand what it covers, but it's up
to you if you want to read it cover to cover.
- Plan carefully what you want to do, and study examples from similar
situtations in the sample applications.
- When you get stuck, search this Newsgroup forum for similar postings that
might have the answers you're looking for.
- If you can't find anything of help, post a question to the Newsgroup.
In summary, learning Access programming is iterative, and will develop as
you solve new problems. You can learn a little by just diving in, however,
the basics of table normalization, relationships, forms & subforms, the
difference between a *field*, which is where data is *stored* in a table, and
has a specific datatype (Text, Number, etc.) and a form or report *control*
(which is a container where data is *displayed*, and may or may not be
*bound* to a table field) IMO should be mastered before you dive into
programming, or it will be a long struggle.
Good luck.
Hope this helps.
Sprinks