Creating database using MS Access

Asked By hansmith 10 points N/A Posted on - 04/01/2012

What are  the different methods to create a database using Microsoft Access and what is the best of them?

• Status: Open
• Question Views: 904
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Mamangun Ceilo

Go To Solution

Best Answer

Best Answer

Answered By Mamangun Ceilo 0 points N/A #98370

Creating database using MS Access

Hello Hansmith,

There are a few ways to create a database with MS Access.If you want to create a database using your own design , it might be a little tricky since you need to create an empty database and then define every element by yourself , from tables to reports and forms, everything.

The quickest way of creating a database is to search a template using "Office Online", but I believe you need MS Access 2003 to find the template.A template is a .mdb (Access Database File) and it includes everything you need. Just that there's no data, it's empty, waiting for you to fill it up with information.

You can also create a database using the Database Wizard.It's the same as the second solution , it creates queries, forms ,reports, a set of tables and a switchboard for your database. You just have to find the template that best fits what you want.

All of them are good to use , if you know your ways around Access you can create one from scratch and add everything as you please , if you don't know how to do that , it's best you search a template which fits in your requirements and use it.It's entirely up to you.

Best of luck ,

Mamangun Ceilo.

About Mamangun Ceilo

Questions
0

Answers
7

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/01/2012
• Question Category: MS Access

Answered By Sharath Reddy 590495 points N/A #98371

Creating database using MS Access

Here is the simplest way of creating a database using Microsoft Office Access.

• Start Microsoft Office Access then click “File”, “New Database”.
• On the next window, select “Blank Database”. In this example we’ll just use a blank database although in Microsoft Office Access you can use different templates when creating a new database.
• Next step is to select the location of your database. This is the folder where your Microsoft Office Access database will be saved. After this Microsoft Office Access will now display your blank database in the work area.

Besides using Microsoft Office Access to create a database, many DBAs or Database Administrators who already know how to run scripts on the database system use SQL. By the way, the term SQL stands for Structured Query Language. The very basic code used when creating a new database in SQL is “CREATE DATABASE MyDatabase”.

The newly created Microsoft Office Access database

 

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 05/04/2013
• Question Category: MS Access

Answered By hansmith 10 points N/A #98372

Creating database using MS Access

Thanks Techyv experts, for your generous contributions; super explanation as well as very educative solutions. I think that MS Access is a complex task. It is not an easy task for me also I can’t feel comfortable creating database. But now, this kind of experience is very essential for me as a job quality platform. So for learning I was eagerly waiting for your reliable comments and at least by visiting your comments, I’d learned a lot of techniques and gained more knowledge in creating a database. I got the logic with a simple way of creating a database using MS Office Access and the screenshot was really helpful for me as a new learner. Well done friends and thanks Techyv for making this post.

About hansmith

Questions
12

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/24/2013
• Question Category: MS Access