Yes Filemaker can do this but can you do it with fileMaker? There are training tutorials--even youtube videos and you can go to a site like Amazon and research both books on the subject and the reader reviews posted about them.
How to create a table in a FileMaker File:
Select Manage | Database from the File Menu.
Click the Tables tab.
Enter the name of the table and click create.
You now have added a table to your file, but it has zero fields defined and no relationships to other tables.
You can click the fields tab and add fields much like you just added the table--enter a name and click create, but now you can specify a "field type" for each field such as date, text, number, etc.
When you create a new table, FileMaker creates a box on the relationships tab with the same name. this box is called a "table occurrence". It is a way to refer to your table of the same name, but you can create more 'boxes' than this first one that also refers to your table. FileMaker also creates a layout for you with the same name as your table. If you go to this table, enter layout mode and select "Layout Setup..." from the layouts menu, you'll see a dialog appear with a drop down list called "Show Records From". You'll find that fileMaker has selected your table occurrence of the same name as your table for you in this drop down and thus your layout can be used to display and edit records from your new table. Just as you can create more table occurrences that refer to the same table, you can also create more layouts that refer to the same table occurrence.