3/29/15..
- Its a DB, so should be able to create Tables, Queries
- Design view, will give clear idea on how query could be designed, if you add columns, criteria to each column that will automatically create query for you(Check SQL view for that).
Other than DB:
- Create user form, write macros. Assign Queries to the bottons in the form. You could customize the vbscrip methods. Go to the properties of the botton->action-> modify vbscript
- And using the form you could create any kind of user interface
- Other feature is, if you are professional in vbscripting, you could make any kind of functionality to work. That means MSAccess is VBscrip friendly.
- Well once you create different reports playing on queries and tables using vbscript or directly from the interface, you could export the reports to excel or other Microsoft formats.
- Every excel reports(other compatable formats) could be converted to tables in MSaccess, that way you just import them whenever needed a table of that kind in your DB.
-
- Its a DB, so should be able to create Tables, Queries
- Design view, will give clear idea on how query could be designed, if you add columns, criteria to each column that will automatically create query for you(Check SQL view for that).
Other than DB:
- Create user form, write macros. Assign Queries to the bottons in the form. You could customize the vbscrip methods. Go to the properties of the botton->action-> modify vbscript
- And using the form you could create any kind of user interface
- Other feature is, if you are professional in vbscripting, you could make any kind of functionality to work. That means MSAccess is VBscrip friendly.
- Well once you create different reports playing on queries and tables using vbscript or directly from the interface, you could export the reports to excel or other Microsoft formats.
- Every excel reports(other compatable formats) could be converted to tables in MSaccess, that way you just import them whenever needed a table of that kind in your DB.
-
No comments:
Post a Comment