How to create access database

Asked By Mia Molly 20 points N/A Posted on - 03/10/2013

Hello everyone, 

I have an assignment on the Microsoft access database. But I am newbie about this. Please help me about how to create access database on Microsoft access, it will be helpful for me.

Thanks.

• Status: Open
• Question Views: 978
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Keith J Harmon

Go To Solution

Answered By Peter A May 10 points N/A #178861

How to create access database

MS Office 2010: To create a MS Access database at first launch the MS Access then you will show on the window “File Name” and a text box with “Database1.accdb”. Below of this textbox here a button name “Create”. After creating just save it (“Ctrl + s” shortcut key)

 

Or, 

 

MS office (others): First launch and choose the option File > New > click on the Blank database option > Type a name of your database > click on create.

 

Best of luck.

About Peter A May

Questions
11

Answers
101

Best Answers
44

• Vote Up 0 Vote Down

• Posted on - 03/11/2013
• Question Category: MS Access

Best Answer

Best Answer

Answered By Keith J Harmon 10 points N/A #178862

How to create access database

Dear Mia,

I'll give some basic tutorial on how to create a Microsoft Access Database. I'll be explaining on Microsoft Access 2010.

1. First, launch Microsoft Access. You will see this startup window from which you double click on blank database or click create at the bottom right.

– If Ms Access is already open you can go to file menu then new, where the same window will appear

– Above the create button is the file name where you can enter the name and select the directory to save the database to.

 

2. To create tables , you can go to the "Create" tab then choose "Table".

3. From the left panel right click on the table and choose "Design View" or you can click on the small button at the right down corner. Then you will name your table with the proper name.

4. Here is how the Design View Looks like.

5. In Design view you can name table columns, assign the data type and write a short description.

And you can apply desired constraints over columns from Field Properties.

6. After you finish editing you need to switch back to Table view, by clicking on the first button in the right down corner.

You will be asked if you want to save the table now? Click yes.

7. Now you are in Table view again. You can now add the data you want.

About Keith J Harmon

Questions
9

Answers
61

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 03/12/2013
• Question Category: MS Access