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