Free Essay

Clearing House Ms Access

In: Computers and Technology

Submitted By 09bshyd0795
Words 778
Pages 4
About Access databases
A database is a collection of information that's related to a particular subject or purpose, such as tracking customer orders or maintaining a music collection. If your database isn't stored on a computer, or only parts of it are, you may be tracking information from a variety of sources that you have to coordinate and organize yourself.
For example, suppose the phone numbers of your suppliers are stored in various locations: in a card file containing supplier phone numbers, in product information files in a file cabinet, and in a spreadsheet containing order information. If a supplier's phone number changes, you might have to update that information in all three places. In a database, however, you only have to update that information in one place— the supplier's phone number is automatically updated wherever you use it in the database.
[pic]Access database files
Using Microsoft Access, you can manage all your information from a single database file. Within the file, you can use: • Tables to store your data. • Queries to find and retrieve just the data you want. • Forms to view, add, and update data in tables. • Reports to analyze or print data in a specific layout. • Data access pages to view, update, or analyze the database's data from the Internet or an intranet.
[pic]
✓ Store data once in one table, but view it from multiple locations. When you update the data, it's automatically updated everywhere it appears. ✓ Display data in a query ✓ Display data in a form ✓ Display data in a report ✓ Display data in a data access page

Tables and relationships
To store your data, create one table for each type of information that you track. To bring the data from multiple tables together in a query, form, report, or data access page, define relationships between the tables.
[pic]
✓ Customer information that once existed in a mailing list now resides in the Customers table. ✓ Order information that once existed in a spreadsheet now resides in the Orders table. ✓ A unique ID, such as a Customer ID, distinguishes one record from another within a table. By adding one table's unique ID field to another table and defining a relationship, Microsoft Access can match related records from both tables so that you can bring them together in a form, report, or query.
[pic]Queries
To find and retrieve just the data that meets conditions that you specify, including data from multiple tables, create a query. A query can also update or delete multiple records at the same time, and perform predefined or custom calculations on your data.
[pic]
This query accesses separate tables to retrieve the Order ID, Required Date, Company Name, and City information for customers in London whose orders were required in April.
[pic]Forms
To easily view, enter, and change data directly in a table, create a form. When you open a form, Microsoft Access retrieves the data from one or more tables, and displays it on the screen with the layout you choose in the Form Wizard, or with the layout that you created on your own in Design view.
[pic][pic]
✓ A table displays many records at the same time, but you might have to scroll to see all of the data in a single record. Also, when viewing a table, you can't update data from more than one table at the same time. ✓ A form focuses on one record at a time, and it can display fields from more than one table. It can also display pictures and other objects. ✓ A form can contain a button that prints, opens other objects, or otherwise automates tasks. Reports To analyze your data or present it a certain way in print, create a report. For example, you might print one report that groups data and calculates totals, and another report with different data formatted for printing mailing labels.
[pic][pic]
✓ Use a report to create mailing labels. ✓ Use a report to show totals in a chart. ✓ Use a report to calculate totals.
[pic]Data access pages
To make data available on the Internet or an intranet for interactive reporting, data entry, or data analysis, use a data access page. Microsoft Access retrieves the data from one or more tables and displays it on the screen with the layout that you created on your own in Design view, or with the layout you chose in the Page Wizard.
[pic]
[pic] ✓ Click the expand indicator ✓ To display the data and record navigation toolbar for the next level of detail. ✓ Use the record navigation toolbars to move to, sort, and filter records, and to get Help.

Similar Documents

Premium Essay

I Can Win

...Report on Bangladesh Electronic Fund Transfer Network: A Study on Prospect of Payment and Settlement System in Bangladesh Prepared by Kafil Uddin Muhammad Zahid Mahmud ID: 80802062 Supervisor Professor (Dr) Khondoker Bazlul Hoque Department of International Business University of Dhaka Date of Submission: November 26, 2015 Department of International Business University of Dhaka November 26, 2015 Professor (Dr) Khondoker Bazlul Hoque Department of International Business University of Dhaka Subject: Submission of Internship Report. Dear Sir With due respect and humble submission I beg state that I want to submit my internship report consist of “Bangladesh Electronic Fund Transfer Network: A Study on Prospect of Payment and Settlement System in Bangladesh” as the study part of which you had assigned me for fulfillment of the course “Internship” of Evening MBA program. May I note here that, there will be no dearth of sincerity on my part to bring the issue under study into proper focus. However, I would like to request you to consider if any error is found in my report. Finally, I would like to request you to permit me to conduct the research on my proposed topic and submit my report on that. Thanks in advance for your kind assistance and advice in this connection. Yours obediently, Kafil Uddin Muhammad Zahid Mahmud ID. 80802062 2nd Batch, Department of International Business University of Dhaka Contact No. 01715720770 Email: kafil_uddin@yahoo.com ii | P a g e ACKNOWLEDGMENT...

Words: 13829 - Pages: 56

Premium Essay

Resume

...CURRICULUM VITAE Nijith Koodathil House # G 201, SRK SILICANA Apartment Doddathgur Village, Phase 1 Electronic city, , Email: nijisathi@gmail.com Bangalore – 560100 Phone: 91 – 09036721137 Career Objective: To be associated with a leading corporate of hi-tech environment with commitment and dedication, which will help me to explore myself fully and provide me an opportunity to work with a global group.. Professional Tenure: Employment Status: Employed Employed Company: Oracle Corporation India Private Ltd (Bangalore) Designation: Analyst, Global Order Management – North America. Duration: From January 06, 2011 till Date Description of the Assignment Oracle Corporation is the world's leading supplier of software for information management and the world's second largest independent software company. Oracle Global Financial Information Centre (GFIC) is based in Bangalore and provides services for Oracle's in-country operations across the world like Accounts Payable, Accounts Receivable, Cash Applications, Order Management, Credits and Collections, FP & A, Purchasing and all other financial services. Responsibilities include Resource Management, Process Management, Release Management, Requirement analysis, strategy formulation...

Words: 857 - Pages: 4

Premium Essay

Human Resources

...innovation and growth. Excellent team player who listens, thrives on collaborating with diversely talented team members, and integrates their divergent thoughts, opinions, and perspectives into meaningful action. Highly effective verbal and written communicator who is fluent in both English and Spanish. Energetic, competitive achiever who can inspire and motivate team members, successfully manage multiple priorities, and perform under pressure in a fast-paced, rapidly changing environment. Visionary and global thinker who is degreed in management and adept at training, developing, counseling, and coaching team members and clients. Computer-proficient performer with expertise in MS Windows 95, 98, NT, 2000 Pro, XP, MS Office 97, 2000, XP (Word, Excel, PowerPoint, Access, Outlook), MS Internet Explorer, Adobe Acrobat, and Quicken. Highlights of Professional Experience and Accomplishments All experience attained during career with Stover Martin Bank, 1993 to Present E-Commerce ~ Web Marketing Tapped emerging market of PC and Internet users by simplifying approach and training on complex electronic-payment products, persuading management, and restructuring risk parameters. Designed and changed Web sites; created interactive Web demos for...

Words: 831 - Pages: 4

Free Essay

Financial Trading and Investing

...Chapter 8: Institutions and Procedures in Secondary Markets A. Exchanges and Floor Markets The Securities and Exchange Act of 1934 defined an exchange to be: any organization, association, or group of persons, whether incorporated or unincorporated, which constitutes, maintains, or provides a market place or facilities for bringing together purchasers and sellers of securities or for otherwise performing with respect to securities the functions commonly performed by a stock exchange as that term is generally understood, and includes the market place and the market facilities maintained by such exchange. An exchange is typically a physical or virtual meeting place drawing together brokers, dealers and traders to facilitate the buying and selling of securities. Thus, exchanges include the floorbased markets as well as many virtual meeting sites and screen-based systems provided by Electronic Communications Networks (ECNs). In the United States and most other countries, exchange transactions are executed through some type of auction process. Exchanges in the United States are intended to provide for orderly, liquid and continuous markets for the securities they trade. A continuous market provides for transactions that can be executed at any time for a price that might be expected to differ little from the prior transaction price for the same security. In addition, exchanges traditionally served as self-regulatory organizations (SROs) for their members, regulating and policing their...

Words: 13751 - Pages: 56

Premium Essay

Cash Management

...comprises of is true and original as per my research and observation. ----------------------------- Signature of the Student (Name of the Student) CERTIFICATE This is to certify that Mr. Binay Roy has completed the project ‘Study of cash management at standered chartered bank’ under the guidance of Prof. Naveen Rohatgi in the academic year 2010-2011 and has submitted the same to the University of Mumbai in partial fulfillment of the requirement of the Bachelors of Management Studies courses. -------------------------------- ---------------------------------- Signature of the Principal Signature of the Project Guide (Dr. Ms. M.B.Madlani) (Prof. Naveen Rohatgi) ------------------------------------------ Signature of the External Examiner. ACKNOWLEDGEMENT I would like to acknowledge the following as being instrumental in the completion of this project: I would like to thank University Of Mumbai and L. S. Raheja College for giving me this opportunity to research and make this project. I would also like to thank my Project Guide Mr. Naveen Rohatgi for giving me the guidelines of how to work on the project and helping me out with all the problems and...

Words: 11265 - Pages: 46

Free Essay

Wenjiabao

...CMYK Late Edition Nxxx,2012-10-26,A,001,Bs-BK,E3 Today, morning fog and clouds, parToday, morning fog and clouds, parLate Edition tial clearing, high 68. Tonight, mosttial clearing, high 68. Tonight, mostToday, mild, low and clouds, parly cloudy,morning fog 56. Tomorrow, ly cloudy, tial clearing, andmild, low 56. Tomorrow, periodic cloudshigh 68. Tonight, most- Late Edition sunshine, high periodic clouds and sunshine, high 66. ly cloudy, mild, lowon Page Today, morning fog and clouds, parWeather map is 56. Tomorrow, high 68. Tonight, mostB12. 66. Weather map is on Page periodic clouds and sunshine,tial clearing, B12. high ly cloudy, mild, low 56. Tomorrow, 66. Weather map is on Pageperiodic clouds and sunshine, high B12. ORK,YORK, FRIDAY, OCTOBER 26, 2012 EW FRIDAY, . OCTOBER 26, 2012 VOL. CLXII . No. 55,936 © 2012 The New York Times NEW YORK, FRIDAY, OCTOBER 26, 2012 66. Weather map is on Page B12. $2.50 $2.50 $2.50 NEW YORK, FRIDAY, OCTOBER 26, 2012 $2.50 2 CHILDREN SLAIN Amassed in the N SLAINSLAIN Billions Amassed thethe Shadows Billions Amassed ininin the Shadows Premier Obama Campaign Endgame: AT HOME IN CITY; LDREN SLAIN BillionsAmassed Billions Shadows Shadows ILDRENGrunt Work and Cold Math the Family of China’s By IN CITY; OME IN CITY; HOMEIN CITY; ByBy the Family of China’sPremier the Family of of China’s Premier By the NANNY ARRESTED China’s Premier Family RRESTED NY ARRESTED NNYARRESTED POLITICAL MEMO ...

Words: 9384 - Pages: 38

Premium Essay

Bridging Information Systems in Business, Credit Exception Tracking System

...Abstract This report aims to identify the business value of information system in an organization. The organization that has been focused is HSBC Bangladesh. The CRM department of HSBC Bangladesh had recently incorporated a new software, namely “Credit Exception Tracking System”. This report primarily focuses on the situation of the bank prior to the incorporation of this information system in the CRM department, and it expands with a qualitative and quantitative analysis of benefits being received from the new IS . The major emphasis of these analysis has been the users of the IS, and both the analysis are subject to their response. The report also contains a brief description of the technical aspects of the IS. The hardware setup and the software support that are needed to operate the IS are described briefly. The cost of implementing the project, including the purchase of additional hardware, software and training is also mentioned. Although it is always critical to assess the amount of value addition that a particular IS brings into effect, CETS has had very lucid and prominent impact in improving the operation and efficiency of the organization. These impacts are pointed out clearly throughout this report. Introduction The pace of globalization has influenced all businesses to undergo sufficient changes in their operational procedures. Often businesses need to automate their existing operations in order to cope up with the rest of the business world...

Words: 2683 - Pages: 11

Premium Essay

Financial Performance Analysis

...Executive Summary: Any academic course of the study has a great value when it has practical application in the real life. Only a lot of theoretical knowledge will be little important unless it is applicable in the practical life. So we need proper important unless it is applicable in the practical life. So we need proper application of our knowledge to get some benefit from our theoretical knowledge to make it more fruitful. When we engage ourselves in such field to make proper use of our knowledge in our practical life only, then we come to know about the benefit of the theoretical knowledge. This report is on a study of the General Banking” of Shahjalal Islami Bank Ltd.  Uttara Branch. Sahajalal Islami Bank Limited is a private commercial bank, which is 6th Islamic Shariah based bank in Bangladesh. The Bank started its operation on 10th May 2001, during this period it could improve its image in the society as an Islamic Bank. Now it has 26 branches in Bangladesh. All branches are situated in the highly demanded areas. As a new bank, Shahjalal Islami Bank Limited has been competing with other private banks where all the banks are adopting different incentive programs to attract the customers. Accordingly, SJIBL is offering different type of deposit scheme bearing highest rate of return. Mudarabah Deposit Scheme, Monthly income scheme and Millionaire scheme, Double Benefit Scheme are the most popular offers that are completely new innovation in the banking sector and widely...

Words: 13491 - Pages: 54

Premium Essay

Fedral Tax Law

...CHAPTER 1 UNDERSTANDING AND WORKING WITH THE FEDERAL TAX LAW SOLUTIONS TO PROBLEM MATERIALS DISCUSSION QUESTIONS 1. (LO 1) When enacting tax legislation, Congress often is guided by the concept of revenue neutrality so that any changes neither increase nor decrease the net revenues raised under the prior rules. Revenue neutrality does not mean that any one taxpayer’s tax liability remains the same. Since this liability depends upon the circumstances involved, one taxpayer’s increased tax liability could be another’s tax saving. Revenue-neutral tax reform does not reduce deficits, but at least it does not aggravate the problem. 2. (LO 2) Economic, social, equity, and political factors play a significant role in the formulation of tax laws. Furthermore, the IRS and the courts have had impacts on the evolution of tax laws. For example, control of the economy has been an important economic consideration in passing a number of laws (e.g., rapid depreciation, changes in tax rates). 3. (LO 2) The tax law encourages technological progress by allowing immediate (or accelerated) deductions and tax credits for research and development expenditures. 4. (LO 2) Saving leads to capital formation and thus makes funds available to finance home construction and industrial expansion. For example, the tax laws provide incentives to encourage savings by giving private retirement plans preferential treatment. 5. (LO 2) a. Section 1244 allows ordinary loss...

Words: 5591 - Pages: 23

Premium Essay

Businessrecoverymarcvandoorenmaalen

...1. Introduction ‘Business Continuity at ABN Amro Bank’ is about implementing a successful BCM Strategy in order to reach maximum benefits against lowest possible costs, by combining internal and external relocation strategies. 2. ABN AMRO Bank ABN AMRO Bank is a multi-national bank, home based in the Netherlands with presence in 26 countries. It provides general services in the client segments Retail Banking, Private Banking and Commercial/Corporate Banking and adds specialised activities such as financing Energy, Commodities & Transport sectors, Clearing and Custody, Factoring and Lease. It stands for Corporate Values ‘Trusted’, ‘Professional’, ‘Ambitious’. The bank is a result of the merges between ‘The Netherlands parts’ of both ABN AMRO Bank and Fortis Bank, in October 2008. 3. BCM Approach ABN AMRO The BCM approach within ABN AMRO is directly related to the BCM Phases as described in the BS 25999. The subdivision of BCM phases differs from BS-25999 - and Good Practices Guideline - to emphasis several phases in the BCM-lifecycle, specifically fully integrated ‘Crisis Management’ and the various phases of BCM Response. For example: since IT Disaster Recovery requires mostly the highest investments within the full scope of BCM and disruptions often are a consequence of failures within this area, it is required to have ‘IT DRP’ as a separate reporting phase to allocate priorities adequately. The definition of phases in the BCM approach support the following BCM processes...

Words: 1276 - Pages: 6

Premium Essay

Hsbc Managment Ractice

...Assignment on Management Practices of \ ___________________________ ACKNOWLEDGEMENT First and fore mostly we would like to thank the Almighty Allah who blessed us with knowledge, understanding and ability to do this report. We are indebted to many people for providing us encouragement and support during our learning and working while making this report and we want to show our gratefulness to these people. We are very much grateful to Ms. SharminAkther, our respected course instructor of MGT101 (Principal of Management), who assigned us this challenging work. She always guided us to take and overcome this challenge successfully. Without her help in every step it was quite impossible for us to finish this report properly in time. We are also grateful to AKM Ahsan Habib, Team leader, Retail Banking and Wealth Management, and Othish Asif Rahman, Relationship Officer HSBC Select for giving us valuable information. Table of Content Topic | Pages | Chapter # I: Introduction | 01-02 | Brief History of HSBC | 01-2 | Chapter # II: Main Body | 03-17 | Management Function * Planning * Organizing * Leading * Controlling | 03-1303-0707-0910-1111-12 | Chapter # III: Conclusion | 12-15 | References | | | | Introduction The Hongkong and Shanghai Banking Corporation Limited is a prominent bank established and based in HongKong since 1865 when Hong Kong was occupied by British drug traders and made a colony of the British Empire. It...

Words: 3452 - Pages: 14

Premium Essay

A Study on Commodity Market for Share Khan Ltd

...Chapter – I INTRODUCTION 1.Introduction of Project Work : Why Commodity Futures? ADVANTAGES OF FUTURES MARKET TO ITS VARIOUS PARTICIPANTS Stockiest / Jewelers / Farmers | | Traders, Jobbers & Arbitragers | * Can hedge their underlying * Get an extensive market * Can get loan against Warehouse Receipts | | Trading Opportunity | Investment Opportunity | Corporates | | Additional Advantage | * Can hedge by offsetting product exposure * Can hedge by parking only margin amount * Can buy goods without agents with Quality Assurance | | Spread Trading Opportunity | Arbitrage Opportunity | TABLE-1.1 Why Indian Commodity Exchange? India is essentially a commodity based economy constituting of Agriculture, Energy, Precious Metals and Base Metals. Couple of unique features / advantage seen in our exchanges, which is not seen elsewhere, are: 1. Timings: Our Trade timings are well matched with Global Market timings. 2. Number of commodities: Nowhere in the world more than 8 to 10 commodities are traded in a single exchange, but our exchanges are successfully managing over 40 commodities individually. Why Sharekhan? Superior & Consistant Research Performance of…. 1. Cutting Edge Analysis of Major Commodities 2. Relevent Analysis of Market News & Information 3. Sound Technical Analysis for Short Term Trends 4. Special Reports such as… * Hedge Solutions: To offset Product Exposure...

Words: 10211 - Pages: 41

Free Essay

Brand Loyalty

...ARTICLE 1 Airport Retail Flying High By Robin Mellery-Pratt 5 September, 2013 Once a profitable but rarely discussed sideline business, airside retail is now a highly lucrative, core component of a successful luxury strategy and airport operators are innovating to take sales even higher. BoF investigates. Dior concession at London Heathrow Airport | Source: Heathrow Airport LONDON, United Kingdom — Christian Dior’s dove grey carpets and boudoir mirrors vie for the eyes of customers with Prada’s harlequin tiles. The polished hardware of Dolce and Gabbana handbags glint, not far from lustrous exotic-skinned accessories by Gucci. No, this is not the Avenue des Champs-Élysées or Bond Street, but the departure lounge of Heathrow Airport’s Terminal 5, where passengers buy over $450 million per year of perfumes, clothing, scarves, sunglasses, jewellery, watches, bags and small leather goods from brands including Alexander McQueen, Burberry and Chanel, the airport’s top performer. A similar scene plays out each day at a plethora of major international airports across the world, from Singapore’s Changhi and South Korea’s Incheon to Dubai International and Charles de Gaulle in Paris. But this wasn’t always the case. Indeed, in the last 20 years, airside retail has undergone a radical transformation. From Sideline to Strategic Priority “What you used to have at Heathrow and Gatwick, for example, was big old airport terminals, with a WH Smith and maybe a Knickerbox and...

Words: 4689 - Pages: 19

Premium Essay

Premium Banking

...Executive Summary: This is the internship report based on the three months long internship program that I had experienced in the Head Office of BRAC Bank Ltd. From May 18, 2008 to August 17, 2008 as a requirement of my BBA program under Department of School of Business, North South University. This report is divided into two broad parts: one is the organization part and another is the project part. In the organization part, I introduced the Latest and one of the largest banks of our country— the BRAC Bank Ltd. On the other hand, in the project part, I focused on the findings, graphs and analysis of the research. The topic of my report was “Premium Banking Service to the customers”. My focus of the report will be basically on the functions of Premium Banking only. The specific objective of this study was to explore the relationship between client satisfactions and the degree of consumer service delivery, the degree of CSD in context of the BRAC Bank Ltd. While discussing the different aspects and functions of the bank, priority has been given to depict the real situation as far as appraisal and management system of BRAC Bank Ltd. are concerned by employing the experience gathered during the internship program. Analysis on the findings is basically done to sort out the major aspects of the General banking system and to draw some significant inferences. At the same time for easier understanding of the report, supporting topics and terms are explained in light of textbooks and regulatory...

Words: 22347 - Pages: 90

Premium Essay

Term Paper

...Chapter -1 ABOUT THE REPORT 1.1 Introduction: Banking sector, considered as ever growing child, in any country plays a pivotal role in setting the economy in motion and in its development process, while the banking structure -the number and size distribution of banks in a particular locality and the relative market power of specific banking institutions determines the degree of competition, efficiency and performance level of the banking industry. Bangladesh’s banking sector consists of Central Bank (named as Bangladesh Bank), Commercial Banks, Development Banks and Specialized Financial Institutions. The Commercial Banks comprise of Nationalized Commercial Banks (NCB), Local Private Banks, Foreign Private Banks, and Islamic Banks. In recent years, it is observed a mushroom growth in the banking sector in Bangladesh. The very active and lively presence of private sector has stirred competition among the traditional Commercial Banks. The shadow of fierce competition in banking industry can be observed through the recent achievement of the Private Commercial Banks. The competition to pursue clients and imitate one another is so intense that one bank lures efficient staff of another bank offering higher facilities to get better edge. Private Commercial Banks often introduce new and diversified financial products to provide wider option to customers. Without having an effective customer base, it becomes difficult for any bank to compete and sustain in the competitive market...

Words: 9517 - Pages: 39