MS Access newbie here

[Piyush]

I want to create an app with these requirements:

It should be created via MS Access. It should be presentable as a form with various fields in which data has to be entered manually. When the app is made to run, the window with fields pops up and user enters the data. When it is saved and closed, it should generate a file with that particular data.

Is it possible? If so, where to start from?

 

[Vyom]

Anything is possible.

Start by learning MS Access. How to create tables. Concept of database will play a big role. Things like Queries and Joins are the key to managing database.
Then you need to create a database for the application you are trying to built. How many tables would you need. How will these tables be linked. Are they needed to link it at all, or will your code/queries be managing tables independently.

After you finalize the database, it would be time to design and finalize the form you want. Things like how many input boxes are required, will all fields be entered by the user, or will some of the fields be calculated and be disabled from entering any data? Also what kind of operations you need to perform on the data. Basic things like Inserting new record and searching is normal. But also you may need a form to alter the records on demand.

Last thing would be to actually use "Forms" in Access to create the form, and add code on buttons. These forms will interact with the tables in the database. Finally, you would need to test if any wrong data being entered would not result in any run time error. Most prominent example is entering an apostrophe in the input fields of the form. When you try to enter any text with an apostrophe like this: "L'Oreal" access will throw an error, if you are using SQL queries. Entering through recordset is safer, but not that easy.

I recommend you to read a book like "Microsoft Access 2013 Bible".