Thursday, March 14, 2013

How to create a desktop database in Access 2013

Access database used to store data & track information about the data. Information can be of any type like inventory, contacts etc. There are many steps to create & add data in access desktop 2013.
Let's have a look of all the steps:
To create desktop database in Access 2013, first you have to start Access Database 2013:
First Start Access:
  1. In Windows 7, Start button>>All Programs>>Microsoft Office 2013>>Access 2013
  2. Click on Access 2013

After that you will see the Start screen of Access 2013:

Create Blank Desktop Database: In start screen, you will see the option of 'Blank Desktop Database', Click on that button.
After that enter the file name in text box & Click on 'Create' button:

Now you will see this picture:

In this screen, there are main 5 sections that are used in most of the time:

FILE: We can use this option to open, save & close file just like in other access database versions.

HOME: This option is just like other access database versions.

CREATE: Through this option, you can create table, forms, reports etc. First time when you open access database 2013, you see a blank table in Datasheet view where you can add data. To add another table, use following steps:

  • Create tab > Table.
  • Now You can easily enter data in the empty field.

External Data: You can use this option to Import or link external data. To link & import data, use following steps:
Click on External Data tab, click on the data format that you want to import from or linking to. Or if the format is not visible in this option then click on More to find out more format options
Now Follow the instructions in the Get External Data dialog box.

Database Tools: You can use database tools to manage your data. There is one tool that is Table Analyzer Wizard which you can use to organize the data into separate tables. Here are all steps to use this tool:
  • Open the Access database table that you want to analyze.
  • Click Database Tools > Analyze Table.

Are you using Access desktop database? If so, let us know your thoughts in the comments below!

No comments:

Post a Comment