I found this video on Microsoft Access 2007.This tutorial is only for beginning Microsoft Access users or beginning users to database software in general. This tutorial shows how to open a new database, set the tables for the database, enter data into the table, and save the database.Most of the content I have covered in my previous posts.So this might be helpful for understanding it in a better way now.
Imagine you create a list of students. The list can be started with names as follows: Amanda,Ali and Tim. This type of list is considered one-dimensional because all of its items fit in one category. In order to create a more detailed list, you may want to include these people’s Last Name , Gender and probably other related information. If you include these additional pieces of information in the same category, the list may become confusing. To arrange the list, you would divide it in categories. Here is an example:
Fig 1.1 ( Click on the image to enlarge )
Fig 1.1 shows the initial stage of table creation where we create the categories/field name and the datatype. For datatype we select values from the drop down box and save the table ( CTRL+S).
So by this time we have created the frame of the table and defined the fields and the datatype .
After this we need to enter the values into the table and for that we double click on the table ( at the left side ) and start entering the values as shown below:
Fig 1.2 ( Click on the image to enlarge )
This type of display allows you to refer to a piece of information by its category. This is the basis of a table. A table is a two-dimensional list of items so that the items are arranged by categories. A complete or incomplete series of items that represent each category is called a record. Therefore, a table can be represented as follows:
In database development, a category is represented as a column. Sometimes it is also called a field. A record is represented as a row.In database development, a category is represented as a column. Sometimes it is also called a field. A record is represented as a row.
Here are some quick information on handling tables:
Opening a Table
The most regular operations you will perform on a table require that you open it first. To open a table, first locate it in the Navigation Pane then:
* — You can double-click the table
* — You can right-click the table and click Open
Any of these actions causes the table to display in Datasheet View in the central area of the screen. In the same way, you can open as many tables as necessary.
Closing a Table
After using a table, you can close it. Before closing a table, first select its tab. Then, to close a table:
* — You can click the close button Close on the right side of the tabs
* — You can press Ctrl + Shift + F4
Selecting a Table
In order to use a table, some operations require that you (or rather the user) first select(s) it:
* — To select a table in the Navigation Pane, simply click it
* — If you had opened many tables and they are displaying in the main area of the screen, to select one, click its tab or its title bar
* — If you have many tables displaying in the main area of the screen, you can press Ctrl + F6 continuously to switch from one table to the next until the desired one displays
Renaming a Table
We saw that, when or after creating a table, you must save it to make it part of your database. When saving it for the first time, you must give it a name. If the name of a table is not appropriate, you can change it. To rename a table, in the Navigation Pane, you can right-click the name of the table and click Rename.
In my last tutorial I explained about creating MS Access database. Today I will be explaining about creating Blank Database.
We create database to store information in it.The information is stored in form of Tables.In databases either be MS Access or it be MySQL , we always keep/ maintain data in a form of tables consisting of rows and columns.We name a Table and the columns as per our requirement and enter the data or the value in the rows.
Creating a Blank Database :
— Start Microsoft Access
– To start a new database, in the main section and under New Blank Database, click Blank Database
– In the right section, set the File Name as per your requirement eg Studentdb.accdb . Note – We use the .accdb extension here.
– Click Create to create the new database file
We can also use the samples available as they have the field names preset.
It is really important for Business Analyst to know Database as we have to analyze and create reports for 95% of the time. I will be posting a sequence of Microsoft Office Access tutorials.And trust me it will start on from the basic ( from non-technical point view too ). The first is to see whether you have MS Access database in your system ( duh ).
– Click on start button and click on RUN. Type msaccess and click ok. After this the following screen ( shown below) will appear.
— Here I clicked on Blank Database. After that on the right side you name the database with .accdb extension.
– You can even choose the file from the folder too. After that click on create button.
– You will see the following screen shot.
– So this screen represents the tables in the ms access database. In next post I will explain how to create table.
I really love this flower Bougainvillea. Back in time I never cared for this flower but now I feel that its quite unique and different from rest of the flowers.
A business/systems analyst solves business problems by designing information systems which execute the strategy defined by the business. These IT solutions generally achieve one of the following goals for the business: implement a new/novel business process, increase efficiency and productivity of existing business processes, or reduce operating costs of existing processes.
The business/systems analyst gathers and analyzes new business requirements and weighs them against the existing business systems and processes. Working closely with the business stakeholders, the analyst guides the process of modeling and designing new systems which implement the goals of the organization as expressed by the business requirements.
Next, they document the solution, the blueprint of the new system, by creating documents and diagrams which specify system-user interactions, describe how data should flow through the system, and spell out the logical operations the new system must perform. They present their design to the business and, once approved, they work closely with the system architects and programmers to implement the solution. Typical Work Activities
Most business and systems analysts are involved in creating, modifying, or maintaining some type of information system or software. Depending on the size and nature of the organization, work activities include, but are not limited to:
Interacting with the business organization representatives, including executive management, to understand the business process and the needs of the business.
Gathering business requirements from identified project stakeholders identifying potential solutions to the problems posed by the business needs and requirements.
Translating the business requirements into functional requirements (what features should the system have).
Creating functional specifications for new systems which solve the given business problems.
Presenting solutions to business stakeholders and facilitate the iterative refinement of the system requirements.
Working with the developers (programmers) to make sure the functional specifications are un-ambiguous.
Creating (or helping others create) test scenarios and verifying the system
How does one become an analyst?
Effective analysts have comprehensive business knowledge in addition to the systems design skills. They generally become analysts in one of the two ways:
Earn a degree in a business related discipline (such as economics, finance, or accounting) and, on the job, continue their education by learning systems design skills and by getting involved as stakeholders in IT projects. Many such business practitioners attend additional courses in software design, use cases, modeling in order to round out their modern analyst skills.
Another very common path is to earn a degree in computer science or related field (such as engineering, information systems, etc.) and begin work as programmers, web designers, etc. Slowly, on the job, they acquire business domain skills from the projects they worked on as developers. Most developers take additional courses in communication, writing, requirements elicitation to round out their modern analyst skills.
Financial Ratio Analysis is the evaluation and interpretation of a company’s financial data using standard financial ratios or accounting ratios to determine a company’s financial state or condition. A financial ratio or accounting ratio is a ratio of two values that are taken for a company financial statements (Balance Sheet, Income Statement, Statement of Cash Flows, Statement of Retained Earnings ) There are many standard financial ratios used that have been identified as critical indicators of the financial performance of a business. In addition to measuring a business’ health, they can be used for strategic planning and decision making. Financial ratios can be grouped into categories based on the financial aspect of the business that they measure. The categories are:
Leverage/ Debt Ratios – disclose to what extent debt is used in a company’s capital structure which may indicate the company’s ability to repay long-term debt.
Liquidity Ratios – reflect a company’s short term financial situation and availability of cash.
Operational Ratios – indicate a company’s operational efficiency and how well assets are utilized.
Profitability Ratios – measures the rate of return that a company achieves through the use of its assets and control of its expenses.
Solvency Ratios - measure a firm’s ability to generate cash flow by converting its non-cash assets to cash in order to honor its financial obligations.
Financial ratio analysis is commonly used to compare a company’s current financial performance to its past performance, also called trend analysis, or it can be used to compare against other businesses within the same industry. Comparison to businesses in different industries provides little value since different industries have different risks which may require different capital requirements.
