Overview of Access Database 2013 Apps

Access app is an advanced feature of Access Database 2013 that is used in web browser for sharing and collaboration within your organization. To use an Access app, you need Access 2013 and SharePoint Server 2013. You can create an app using two options: 

From a template:

• Click on Access startup screen>> featured templates>>click on globe icon to create Access apps:

• Click on template and enter a name in the App Name box.
• Select a web location for the app 
• click Create.

From a scratch: 

• Open Access>>click on Custom web app

• Enter a name
• Select Web location for your app 
• click Create.

What NEXT?

Now you will need to add some tables in your new created app. You can either add template tables or just start a new blank table. 


To add a template table:  As shown in figure just type in search box what kind of information you want to store like tasks, employees, projects etc. Now click on Search button and select a suitable table from the list: 






To add new blank table:  

• Click on Add a new blank table.
• Now You will the newly created tables in the left pane.

Now WHAT?

Enter Data in the Tables: 

• Home tab>>click Open in Browser
• Select the table and view you want to use
• use the action bar buttons to add, edit, and delete items.

Import data from an external source:

As shown in figure, You can also import data like Access desktop database, a Microsoft Excel file, an ODBC Data, a text/CSV file, or a SharePoint list. This data will be added as a new table. 

• Start App>>open it in Access (in the browser, click Settings > Customize in Access)
• click Home > Table.
• Now you can see “Add Tables page” as clearly shown in picture. 
• At the bottom of this page, click the type of data source you want to import, and follow the instructions in the Get External Data wizard.

VERY VERY IMPORTANT:

Microsoft also add backup feature in Access web apps so that you can take a backup of your apps that can be restored to a different location. You can create web apps backup copies in App Package files and restore them by uploading them to any SharePoint 2013 site. 

Saving your App


To backup your app, save it as a SharePoint app package by clicking File > Save As > Save as Package. 






Now App Package file is saved to your system.

»»  Read More...

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!

»»  Read More...