How to create access database

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Keith J Harmon
Answered By 10 points N/A #178861

How to create access database

qa-featured
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.
Best Answer
Best Answer
Answered By 10 points N/A #178862

How to create access database

qa-featured

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.

Login/Register to Answer

Related Questions