Esson has attended:
Excel Advanced course
Creating forms on excel spreadsheets
Is it possible to create a form that will populate fields within your database?
RE: creating forms on excel spreadsheets
Hello Esson
Thank you for your question.
There is an in-built form in Excel that you can use to add new records to a database.
To add a new record:
1. Select a cell within the database.
2. Go to Data - Form
3. Click New, and enter data into each field.
4. Click Close when finished. The new record appears at the end of the database.
Kind regards
Amanda