Creating database using MS Access
Asked By
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?
Best Answer
Best Answer
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
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.
Latest Articles
Krikya Bangladesh Review: A Comprehensive Guide To Its Betting Services
Discover the ins and outs of Krikya Bangladesh, a prominent bookmaker in the online betting scene. This detailed review covers everything from the diversity of sports betting options and casino games to user experience, security measures, and customer support efficiency. Whether you're a seasoned bettor or new to the online gambling world,
find out how Krikya stands out in the competitive market of Bangladesh.
Top Construction Management Apps
Construction management is essential to ensure project completion in a timely and cost-effective manner. Construction management software support businesses to operate efficiently. The software is available for all types of construction projects, including residential...
Best Mirrorless Cameras
Mirrorless camera is the latest obsession among the photographers. The cameras have altogether replaced the traditional DSLR models with their unique and special features.
A mirrorless camera is a light-weighted electronic device device that utilizes...
Latest Blogs
Top 10 New Laptop Entrants That Shook The Public
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
10 Facts About The Dark Web
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
Top 10 Latest Steam Cleaner Machines
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Latest Tips
Top 10 Internet Monitoring Software
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
Top 10 Best Partition Manager Software
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software.
1....
Top 10 Best Online Music Production Software
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
