Create a database in Access

To make a database with Access, you don't have to write code or be a database expert because you don't have to know how to do that.

In order to quickly build databases, well-designed templates help you do this quickly. queries make it easy to find the data you want quickly and quickly. Instantly make forms for easy data entry. In grouped and summary reports, sum up data. Dozens of Wizards make it easy to start and get to work quickly.

Create a database

1. Open Access.

   If Access is already open, select File > New.

2. Select Blank database, or select a template.

3. 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.

Import data from Excel

1. Open the Excel workbook, make sure each column has a heading and a consistent data type, and then select the range of data.

2. Select External Data > Excel.

3. Select Browse to find the Excel file, accept the default values, and then click OK.

4. 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.