Can the calendar set alarms or give me some kind of notice when appointments are coming up?
CC Calendar does not have any kind of alarms function built into it, though you can easily add one.
The trick here is to get FileMaker to run a script every so often- once you can do that, you can have a script that "finds" upcoming appointments or finds them and then emails you about them.
In order to run a script like this (every x minutes, for instance), you'll need something like the Events Plugin from www.wmotion.com/events or ScriptFire from http://www.dacons.net . In many of our installations, we have a simple FileMaker client running this plugin as an unattended "agent". This agent machine can then do other automated tasks like email notifications, reports, etc.