Hello,
Greetings for the day!
I’m an, Independent Advisor and Microsoft user like you. Thanks for writing here at this forum.
With Access, you can build a database without writing code or being a database expert.
Well-designed templates help you quickly build databases. Easily find just the data you want with queries. Instantly create forms for simple data entry. Summarize data in grouped and summary reports. Dozens of Wizards make it easy to get started and get productive.
To create a new Database,
- Open Access.
- If Access is already open, select File > New.
- Select Blank database, or select a template.
- Enter a name for the database, select a location, and then select Create.
If needed, select Enable content in the yellow message bar when the database opens.
To import data,
- Open the Excel workbook, make sure each column has a heading and a consistent data type, and then select the range of data.
- Select External Data > Excel.
- Select Browse to find the Excel file, accept the default values, and then click OK.
- Select Does the first row of your data contain column headings?, and then click Next.
- Complete the rest of the wizard screens, and select Finish.
Please find the detailed instruction here,
https://support.microsoft.com/office/f200d95b-e429-4acc-98c1-b883d4e9fc0a
https://support.microsoft.com/office/32a1ea1c-a155-43d6-aa00-f08cd1a8f01e
Below link has detailed steps which would be helpful for you.
https://www.makeuseof.com/how-to-create-database-microsoft-access/
Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it
Hope this information would be useful to you. Please feel free to get back if you need any additional info.
Thank you!
Ravikumar
Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.