No, it does not work like like a database form in which one user adds lots
of records. Think of it more like a paper form that someone in an office
would fill out to request something that needed approval.
1. Someone creates a form for others to use
2. User gets the form (from an email, a file folder or a SharePoint library)
3. user fills out form and clicks submit, (data can go to a database
(Access, SQL server or other choices). It can also be sent to an Excel file
4. Form goes somewhere for review and approval (if a SharePoint library is
used, data from form can be displayed so that users don't have to open forms
to see the contents.

You can merge multiple forms to get a summary of their contents.

If you want to create complex reports to analzye the data entered on the
forms, you will need another tool.