- Using the Search bar
a. Search for web pages and metadata
- Click on the magnifying glass icon
at the upper right corner
- Input keywords (e.g., subject area: National Accounts; name of an indicator: Gross Domestic Product)
- Search results for web pages and metadata containing the keyword will be displayed
- Select a specific result to view the page or select ‘Search More Results’ to display the entire search results
b. Search for tables in the database
- Use the ‘Search Database’ search bar located at the main page of the OpenSTAT
- Use the name of indicators as keywords (e.g., Gross Domestic Product)
- Search results for tables containing the name of indicator will be displayed
- Select a specific result to start accessing/creating a database tabulation
- Browsing for tables in the database
a. Using the ‘Database’ page from the main menu
- Click on the link for ‘Database’ at the main menu
- Database page will be displayed; select a particular subject area
- Depending on the subject area, sub-pages for topics/sub-topics may be displayed, select a particular topic/sub-topic
- Select a particular table to start accessing/creating a database tabulation
b. Directly selecting a subject area/topic from the main page
- Below the ‘Search Database’ search bar, subject area/topic can be directly selected
- Depending on the subject area/topic, sub-pages for topics/sub-topics may be displayed, select a particular topic/sub-topic
- Select a particular table to start accessing/creating a database tabulation
- Accessing/Creating a Database Tabulation
To search for tables in the database, refer to this guide.
To browse for tables in the database, refer to this guide.
a. Selecting item/s in the list box
- To select one item in a list box, click on that particular item. At least one selection in every list box has to be made to show a result for each variable.
- To select several items in a list box that are not in order, press the Ctrl key at your keyboard simultaneously while clicking on items.
- To select all of the item click on the
button or click on the first line and hold the Shift key at your keyboard and click on the last line of the list box.
b. Deselecting item/s in the list box
- To deselect an item in the list box, press the Ctrl key simultaneously while clicking on the highlighted item.
- To deselect all of the selected items in the list box, click the
button.
c. Searching item/s in the list box
- To search for an item in the list box, type in the item name in the Search box and click the
button.
d. To generate, format and save tabulations
- After all required variables have been selected, click continue to generate the table.
- To format table (pivoting, inserting sum and percentages and other calculations), click on the different menu icons at the top of the table.
- To generate graph, click the
button. You may choose from different type of graphs applicable for the table.
- To save tabulation, click on the file format you desired.
Example: Excel (XLS), Extensible Markup Language (XML), Text (TXT), Hypertext Markup Language (HTML) or Comma Separated Values (CSV)
- To transfer file in excel, click save as then open with and find the excel program or highlight the table then copy and paste in excel.