microsoft access 2013 tutorial 1 creating a database

mdb) either as a standalone RDBMS on a single workstation or in a shared client/server mode across a network.Ī desktop database can also act as the data source for data displayed on webpages on your company intranet. You can use an Access desktop database (.accdb or. It provides all the data definition, data manipulation, and data control features that you need to manage large volumes of data. You can see the logical names here.Microsoft Access has the look and feel of other Microsoft Office products as far as its layout and navigational aspects are concerned, but MS Access is a database and, more specifically, a relational database.īefore MS Access 2007, the file extension was *.mdb, but in MS Access 2007 the extension has been changed to *.accdb extension.Įarly versions of Access cannot read accdb extensions but MS Access 2007 and later versions can read and change earlier versions of Access.Īn Access desktop database (.accdb or. Our database is going to be comprised of two separate files.

Let's go ahead and take a look at that now. After you type in the name, you'll notice some activity taking place down here in the database file section. At the top is where we're going to name our database. We're going to focus entirely on the general page. It has three different pages in it, the general page, a page for options, and a page for file groups.

You simply come over here to the databases folder under your server instance, right-click and choose new database. Creating databases in SQL Server Management Studio is pretty straightforward.

But what you probably want to know is how to create a database for your own personal project or organization. Following an example database is a good way to get started in SQL Server.

Microsoft access 2013 tutorial 1 creating a database