In Microsoft Access, select Blank Database under Available Templates. If you would like to try it out for the purposes of this article you can download a free trial, which you can use for 60 days, here.
How to create microsoft access database professional#
Please note that Microsoft Office Access is only available in the Professional edition of Microsoft Office, and as a standalone application.
Alternatively, you can click Start > All Programs > Microsoft Office > Microsoft Office Access 2010. For our first database, we will focus on creating our first table.įirst, launch Microsoft Access. Other field properties become necessary depending on the field type chosen. Each field in the record must be given a: Before creating a table in Access, decide on all the fields that will make up your record. Every record is unique and made up of elements called fields. You can then use that information to search for particular information for referencing purposes, do mathematical operations and sort your data using simple commands from customized menus.Ī description of the Microsoft Access 2010 interface (click to enlarge).Ī table contains all the information about a specific subject. You can use a database to store information about the students in a school, members of a church, your friends or varieties of plants in your garden. The principal way of storing information in a Microsoft Access database is with tables.
But a database can be a tool that solves many of your problems.Ī database is a container which stores a variety of information. Many of you have Microsoft Access installed on your computer and aren’t taking advantage of it.