It is not used to create large or enterprise-level databases but mainly used to create small databases. Users can easily analyze the large amount of data stored in it. It helps the users for managing the related data more efficiently than Microsoft Excel or other applications of spreadsheets. It mainly provides the graphical user interface for accessing the data and the tools for software development. It actually stores the data on the basis of the relational Jet Database Engine. It is released by Microsoft in November 1992. MS-Access is application software for managing the databases. We can do that next when we Create a Table.Microsoft Access Tutorial What is MS Access?

So we need to add some more columns to the table and give the table a name. We know this database is blank because it only contains one table (called Table1) and that table only has one column (called ID). Once you've completed the above steps, you should see a blank database, like this: You can either use the default location or click the folder icon to change the location: You also have other options, but we'll just use a blank database here: (Skip this step if you already chose Blank desktop database at step one). If you already have Access open, you can go to the File menu: In this case, you can simply select Blank desktop database (then skip to Step 3). You may notice that, when you first start Microsoft Access 2013, you see the following screen.Then throughout the rest of the tutorial, we'll make additions to it so that it suits the needs of our favorite space travel company.Ĭreating a database in Microsoft Access is as easy as creating a Word document! This lesson demonstrates how to create a database in MS Access. The first step to creating a database is to, well, create the database! We will create a blank database first.

Let's use Microsoft Access 2013 to create a database just for their needs. So they come to Space Trips whenever they need to purchase a new space ship.īusiness is booming and the company now needs a database to keep track of their customers and the products they purchase.

They prefer the 'self-fly' holidays when they visit other planets. This company sells space ships! Space Trips' customers are the adventurous type who like to make their own travel arrangements thank you very much. For this tutorial, we're going to create a database for a ficticious company called 'Space Trips'.

Microsoft access 2013 tutorial 6