G
Guest
I am trying to figure out the differens between Access and Filemaker. What is a form compared to a layout, that filemaker has> can some explain what a report is , I haven't tried to make one yet.
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.
A
Albert D. Kallal
It is always difficult to try and use the previous concepts to learn a
different product. However, when one CAN make conceptual connections between
what one knows..and what one is trying to learn..it helps...
However, the products are very different in their flavor and use. What was
easy, or done without thinking in FM will now be hard in ms-access. (and,
one should note that the EXACT same problem would exist for me to learn, and
use FM).
I think you should get a book..and that will help you reduce your
frustrations..and get you up to speed.
I am guessing that a layout is similar to a form in ms-access. A form in
ms-access is something you build, and the controls and objects you place on
the form result in something that is a "view" or looking glass into a
database. That form can show some, or all data from a table. In fact, the
form can also show data from several tables (you use sub-forms to do this).
You can also build forms that don't actually edit data, but prompt the user.
Here is some examples for forms that JUST prompt the user for data. These
are called un-bound forms
http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html
You also might want to display data as a grid, and for that you can use a
continues form. Here is some ideas:
http://www.attcanada.net/~kallal.msn/Articles/Grid.htm
A report is simply what is means. To create a report that gives totals of
sales man, grouped by country or region is example of a report. So, forms
are for data entry, and building the application user interface. Reports are
for viewing data, and sending data to a printer.
different product. However, when one CAN make conceptual connections between
what one knows..and what one is trying to learn..it helps...
However, the products are very different in their flavor and use. What was
easy, or done without thinking in FM will now be hard in ms-access. (and,
one should note that the EXACT same problem would exist for me to learn, and
use FM).
I think you should get a book..and that will help you reduce your
frustrations..and get you up to speed.
What is a form compared to a layout, that filemaker hasI am trying to figure out the differens between Access and Filemaker.
I am guessing that a layout is similar to a form in ms-access. A form in
ms-access is something you build, and the controls and objects you place on
the form result in something that is a "view" or looking glass into a
database. That form can show some, or all data from a table. In fact, the
form can also show data from several tables (you use sub-forms to do this).
You can also build forms that don't actually edit data, but prompt the user.
Here is some examples for forms that JUST prompt the user for data. These
are called un-bound forms
http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html
You also might want to display data as a grid, and for that you can use a
continues form. Here is some ideas:
http://www.attcanada.net/~kallal.msn/Articles/Grid.htm
A report is simply what is means. To create a report that gives totals of
sales man, grouped by country or region is example of a report. So, forms
are for data entry, and building the application user interface. Reports are
for viewing data, and sending data to a printer.
U
user
A form in access is like a layout in FM, a report in access is also like a
layout in FM, a print layout in preview mode (not for data entry). There
are a lot of other differences depending on what version of FM you are
using, in particular there are no FM 'lookups' in access ( a lookup in
access is totally different), and your database is all in one file (not a
separate file for each table). You will also find that 'relationships' are
usually only one per pair of tables, and there are no 'calculated fields'.
A query in access really has no direct counterpart in FM, except that it
is a 'found set', or more like a 'restored find' in a FM script. 'Find
mode' in FM is sort of like 'filter by form' in access, but works a bit
differently and you can't add more find requests.
The list goes on and on. You will find that the interface building part
of Access is a lot like FM, but the underlying functionality, design, etc.
is very different. Good luck!
Doug M
what a report is , I haven't tried to make one yet.
layout in FM, a print layout in preview mode (not for data entry). There
are a lot of other differences depending on what version of FM you are
using, in particular there are no FM 'lookups' in access ( a lookup in
access is totally different), and your database is all in one file (not a
separate file for each table). You will also find that 'relationships' are
usually only one per pair of tables, and there are no 'calculated fields'.
A query in access really has no direct counterpart in FM, except that it
is a 'found set', or more like a 'restored find' in a FM script. 'Find
mode' in FM is sort of like 'filter by form' in access, but works a bit
differently and you can't add more find requests.
The list goes on and on. You will find that the interface building part
of Access is a lot like FM, but the underlying functionality, design, etc.
is very different. Good luck!
Doug M
What is a form compared to a layout, that filemaker has> can some explainTressian said:I am trying to figure out the differens between Access and Filemaker.
what a report is , I haven't tried to make one yet.