Related topics
×
Access Quick Start
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Access Quick Start

Create a database

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.

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.

For more info, see Create a new database.

Access templates

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 > New Data Source > From File > 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.

  5. Complete the rest of the wizard screens, and select Finish.

For more info, see Import or link to data in an Excel workbook.

Importing data from Excel

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×