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

Ms. Annie

...Choose one story from the book “ An Evening in Guanima” and explain how the author arouses sympathy for the main character. Patricia Glinton, the author of Miss Annie , arouses sympathy for the main characters in her story, by sharing with us the readers the cause and effect of their action. “Miss Annie” is a story of a beautiful young woman by the name of Miss Annie. She was the wife of Mr. Andrew. When Mr. Andrew died, Ms. Annie was left all alone. Miss Annie promised Mr. Andrew that she would not remarry. However, because of a persistent and charming young bachelor, Ms. Annie was unable to keep her promise to her late husband. After Miss Annie and the young man were already wed, the man’s behavior changed. He treated Ms. Annie very poorly, which led to him getting his just deserts. The author first arouses our sympathy for Mr. Andrew, Miss Annie’s late husband. Mr. Andrew was Miss Annie’s first husband. He loved Miss Annie and treated her very well. Miss Annie was very beautiful. This led caused Mr. Andrew to be very jealous, so jealous that he made Miss Annie promise not to remarry if he died before her. Unfortunately, Mr. Andrew was the first to die. Miss Annie, however, did not keep her promise. This evokes a feeling of sympathy for Mr. Andrew because he did not get to have his last wish fulfilled after looking after Miss Annie all of his life. Next, Patricia Glinton arouses our sympathy for Mr. Andrew’s dog. When Mr. Andrew died, he left his dog to look after......

Words: 612 - Pages: 3

Free Essay

Clearing Mines

...the kidnappers' leaders would be "held to account for their actions". "The full force of the UK and US and other allied countries will bear down upon them," he said. The militants had been involved in a stand-off since Thursday after trying to occupy the remote site. Clearing mines On Friday, 573 Algerians and about 100 of 132 foreigners working at the plant were freed, Algerian officials said. At the last count about 30 foreigners remained unaccounted for, including fewer than 10 from the UK. The chief executive of BP group, which part owns the site, said 14 of its 18 staff were safe. Bob Dudley said the fate of the other four was still unknown but that the company had "grave fears" for them. The militants themselves said before the raid that they had been holding seven hostages. Shortly before reports of the final assault emerged, the leader of the hostage-takers, Abdul Rahman al-Nigeri, said the government had to choose between negotiating with the kidnappers and leaving the hostages to die. He said the area had been booby-trapped and swore to blow up the complex if the Algerian army used force. Algerian national oil and gas company Sonatrach said the army was now clearing mines planted by the militants. 'Retaliation'...

Words: 341 - Pages: 2

Premium Essay

Ms Project

...and maintained by defining the date the project begins. This includes any planning or initiation activities. By setting the start date, we can better estimate how long a project will take. Set the task type to “Fixed duration” to facilitate project schedule development and consistency. Understanding task types is very important. MS Project defines three task types. The task type determines how MS Project calculates duration, work, or hours and resource unit assignments. Setting the wrong task type will cause MS Project to recalculate schedules incorrectly. Next, uncheck the new tasks or effort-driven checkbox. When you’re just starting a project, you should always uncheck this box. It helps to facilitate planning and the initial work. Now, uncheck the split in progress tasks checkbox. Normally, task progress will either be zero or complete with no other value. It is very important to uncheck this box. Next, uncheck the box next to “Tasks will always honor their constraint dates.” Sometimes, a task is started earlier or later than originally planned. By clearing this option, tasks that are started earlier will be moved by MS Project to the earlier start date. Finally, select the “Set as default” button for the changes to take effect for all projects. Next, I’m going to select the calculation tab and make sure that the checkbox next to updating task status updates resource status has been checked. If it is not, be sure to select it. Again, select......

Words: 8020 - Pages: 33

Premium Essay

Ms Access Tutorials

...Specify the default form in Access Options This procedure assumes that you have already created the form that you want to display. 1. Click the Microsoft Office Button , and then click Access Options. 2. Click Current Database, and then in the Display Form list, select the form that you want to display when the database starts. 3. ------------------------------------------------- Click OK, and then close and reopen the database to display the startup form. 4. How to hide and unhide a MS Access object You can hide and unhide a MS Access object (Tables, Queries, Forms, Reports, Pages, Macros, Modules) in the query navigation pane. It's a similar feature like what you do in MS Excel to hide and unhide a spreadsheet. 5. There are various reasons why you want to hide and unhide an Access object. You may work on an Access database that was developed by someone else and you'd like to know if there are any hidden tables or queries and how to view them. 6. On the other hand, when you develop a MS Access database application, sometimes you may consider hiding some queries in the navigation pane and later you may want to see it back or unhide them. In this article, we are going to demo how to hide and unhide an Access query. 7. How to hide a query in Access 8. For hiding a query, it's similar across all the Access versions, Access 97, 2000, XP, 2003, 2007, etc. 9. Below are some screenshots for Access 2003 and Access 2007 for hiding the......

Words: 673 - Pages: 3

Free Essay

Ms Access 2010 for Beginers

...IT Services Microsoft Access 2010™ An Intermediate Guide (Level 2) Contents Introduction ..............................................................................................................1 Speeding up Table Creation ................................................................................2 Using Datasheet View ...........................................................................2 Using a Table Template .........................................................................3 Input Masks ...............................................................................................3 Importing Tables .....................................................................................3 Relationships .............................................................................................................4 Finding Unmatched Records ...............................................................................6 The Find Unmatched Query Wizard .................................................7 Action Queries ..........................................................................................................7 Make-Table Queries ...............................................................................7 Delete Queries .........................................................................................8 Append Queries .......................................................................................8 Update Queries ................

Words: 8701 - Pages: 35

Free Essay

Ms Oberoi and His Legecy

...LDEN/063 IBS Center for Management Research MS Oberoi and His Legacy This case was written by Nitya Iyer, under the direction of Debapratim Purkayastha, IBS Center for Management Research. It was compiled from published sources, and is intended to be used as a basis for class discussion rather than to illustrate either effective or ineffective handling of a management situation. 2009, IBS Center for Management Research. All rights reserved. To order copies, call +91-8417-236667/68 or write to IBS Center for Management Research (ICMR), IFHE Campus, Donthanapally, Sankarapally Road, Hyderabad 501 504, Andhra Pradesh, India or email: info@icmrindia.org www.icmrindia.org LDEN/063 MS Oberoi and His Legacy “My life has been achievement-oriented. I started off as a coal clerk at the Cecil Hotel in Simla. But I always had dreams and I worked my way at fulfilling those dreams.”1 MS Oberoi, the Founder of the Oberoi Group. “His [MS Oberoi’s]legacy isn’t just the hotels. His life has been a living example that nothing is impossible. Persistence brings success. His legacy is for the world to see and learn.”2 -Sanjiv Malhotra, Vice-president, Oberoi Towers, Mumbai, September 2001. “I have great respect for the professionalism of Oberoi Hotels. To me, both the hardware and software components are equally important in a complete hotel product and the Oberoi brand excels in both. P R S Oberoi stands for uncompromising quality like his late father and in this country at......

Words: 10980 - Pages: 44

Free Essay

Ms. Laughlin

...household-based, individual survey and is the first nation- ally representative sample taken across the Russian Federa- tion. Data were collected in two phases. Phase I consisted of surveys conducted in (a) September 1992 (Round 1, n¼17150), (b) February 1993 (Round 2, n¼16378), (c) August 1993 (Round 3, n¼15563), and (d) November 1993 (Round 4, n¼15429). Phase II consisted of surveys con- ducted in (a) December 1994 (Round 5, n¼11568), (b) October 1995 (Round 6, n¼10911), (c) October 1996 (Round 7, n¼10158), (d) November 1998 (Round 8, n¼9607), and (e) October 2000 (Round 9, n¼9006). Phase I (Rounds 1–4) surveyed 6000–7000 households providing 20 primary sample units (PSUs). In contrast, the second phase (Rounds 5–9) surveyed approximately 3000–4000 house- holds with a new sample with effectively 65 PSUs. While there is a longitudinal component to the survey, we use the nationally representative cross-sectional sample in each round. Since Rounds 2, 3, and 4 were all collected in 1993, we present only Rounds 1, 4, 5, 6, 7, 8, and 9. Round 4 was retained for 1993 as the data collection month (November) was seasonally comparable with the other data collection months. This minimized potential bias because of season- ality of dietary intake. 400 300 200 100 0 kg/capital/year 1950 55 60 65 70 75 80 85 89 Year Figure 1 Development of food consumption: Annual intake of selected foods, Soviet Union, 1950–1989: , milk; F, bread; , potatoes; , red meat; , sugar (reprinted with......

Words: 5853 - Pages: 24

Free Essay

Ms 13 Gang

...challenge and formed a new gang by name Mara Salvatrucha, popularly known as MS-13. “Las-Mara” is a notorious street gang that engages in violent crimes in El Salvador. Salvatruchas, refers to the members of the political entity, styled Farabundo Marti National Liberation Front. This is a group of Peasants from Salvador, trained in guerilla warfare. The number 13 refers to the California prison gang, the Mexican Mafia. A youth facing the unemployment problem, not getting support from the government and the society, when he is constantly nagged, abused, condemned and ostracized by the society, turns into a viler and bitter individual. With no authority to show heartfelt care and concern, and an understanding approach to the problems of teeming millions of refugees, the frustrated immigrant youth formed a new gang and began to engage in violent criminal acts. The founding members of the gang were guerilla warfare experts. The training and sophistication they provided to the new recruits was more advanced as compared to their rivals. The new gang topped the list of gangs that have been engaging in violent criminal activities of all sorts. The initiation procedures into the gang are as violent and inhuman, as the activities of the gang are! They become part of the gang by being “jumped in.” “In one Washington DC event, witnessed by a reporter, the inductee was an 11-year old boy - he sought membership in MS-13 so they would protect him from bullies in his neighborhood. ......

Words: 2736 - Pages: 11

Premium Essay

Ms Paper

...Identifying Resources available for Children with Multiple Sclerosis and their Families Multiple Sclerosis (MS) is an unpredictable disorder of the central nervous system. Multiple Sclerosis is an autoimmune disease in which the body, through its immune system, launches a defensive attack against its own tissues and can range from relatively benign to somewhat disabling to devastating as contact between the brain and other parts of the body is disrupted. MS affects the ability of nerve cells in the brain and spinal cord to communicate with each other effectively. The initial symptoms of Multiple Sclerosis are often blurred or double vision, poor contrast, eye pain, red-green color distortion, or even blindness in one eye. Most people with MS experience muscle weakness in their extremities and difficulty with coordination and balance. These symptoms may be severe enough to impair walking or standing. The worst cases of MS can produce partial or complete paralysis. Most people with MS also show par aesthesis, transitory abnormal sensory feelings such as numbness, prickling, or “pins and needles” sensations. Some people may also experience tremors, pain, dizziness, hearing loss and speech impediments. Many people with MS experience cognitive impairments such as difficulties with concentration, attention, memory, and poor judgment but such symptoms are usually mild and are frequently overlooked. Depression and anxiety is another common feature of multiple sclerosis. ......

Words: 773 - Pages: 4

Premium Essay

House

...Improve housing finance access for poor – study May 28, 2015 9:15 pm by VOLTAIRE PALAÑA REPORTER * * * A POLICY paper by the Philippine Institute for Development Studies (PIDS) is calling for the creation of a more favorable environment for housing finance in the country, as well as the adoption of appropriate policies and mechanisms to correct housing market dysfunctions. One of the underlying issues with housing policies in the Philippines, for instance, is the traditional perception that a housing finance system is based primarily on the provision of government subsidies, resulting in a highly-segmented and unsustainable program that does not benefit those who deserve it most. PIDS senior research fellow Dr. Marife Ballesteros noted in her latest study on urban housing subsidies that, despite policy changes through the years, the public sector housing program still does not address the problems on scale. Ballesteros explained that subsidies for housing programs, whether through upfront grants, government direct funding, low interest mortgages, tax exemptions or underpriced risk insurance, could have been put into more efficient use by the government. “Overall, direct subsidy to the low-income housing sector has been limited,” said Ballesteros, adding that in an effort to reduce losses from financial transactions, government has further restricted financing to the low-income sector through lower exposure of funders and the higher loan ceilings on......

Words: 2914 - Pages: 12

Premium Essay

Ms and Pregnancy

...MS and pregnancy The diagnosis of MS should not prevent you from becoming a parent but for this purpose it is very important to consult your doctor and your family. MS affects people who have or are planning to start a family, but more often women than men. This raises many questions about causal relationship between MS and pregnancy. Although, many years ago, women with multiple sclerosis are advised to avoid pregnancy that their condition would not worsened, but today we access different insights. Studies conducted over the past few decades have shown that the symptoms of multiple sclerosis can be alleviated or even disappear during pregnancy. The analysis of works that report about 13 144 women with MS revealed the following data: * MS has no effect on pregnancy. * No increase in negative symptoms nor for mother nor for the child. * Woman with MS can expect a normal pregnancy and normal delivery. For all these reasons, women with MS, especially those with mild neurological deficits, should be encouraged to become pregnant as soon as possible due to the progressive flow of the disease. It is important to break down some of the prejudices that exist and women provide the necessary information: 1. Does MS affect on the fertility of women? 2. Does MS affect on pregnancy and the baby's health? 3. Is it possible to apply spinal or epidural anesthesia during childbirth? 4. Is it recommended breastfeeding and is it safe? 5. Does......

Words: 911 - Pages: 4

Premium Essay

Central (Clearing) Counterparty

... Can you trust your counterparty?? That’s a risk! 3. Pricing! How would you decide on the pricing? Do you have a reference based on which your are marking the price of your share?? Why Stock Exchange? 1. Removes counterparty risk; trade obligations guaranteed. 2. All trade flow through one central place; price quoted for an instrument is always the same regardless of the size of trading entity. 3. All firms that offer exchange traded products must be members and registered with the exchange; greater regulatory, safer place for individuals trade. How Does A Stock Exchange Guarantee? Answer is through CCP: Central Counterparty Clearing House What’s CCP? CCP is the acronym for central (clearing) counterparty. In some markets, they are known as clearing houses. CCPs perform two so-called clearing functions: • • • Once a transaction has been agreed between two parties and registered with a CCP, the CCP inserts itself into the transaction (what was one contract becomes two) to become the buyer to every seller and the seller to every buyer. This is called Novation. CCPs effectively guarantee the obligations under the contract agreed between the two counterparties, both of which would be participants of the CCP. If one counterparty fails, the other is protected via the default management procedures and resources of the CCP. The CCP is AAA-rated, because it strictly collateralises its exposures; is backed by reserves, a default......

Words: 1496 - Pages: 6

Premium Essay

Access

...PPE: safety shoes, safety boots, leggings, Spat. [pic] Future Scope of Occupational Safety Occupational health and safety has come a long way from its beginnings in the heavy industry sector. It now has an impact on every worker, in every work place, and those charged with managing health and safety are having more and more tasks added to their portfolio. The most significant responsibility is environmental protection. The skills required to manage occupational health and safety are compatible with environmental protection, which is why these responsibilities are so often bolted onto the workplace health and safety professional. Future Risks Nanotechnology is another example of a new technology with few studies available that access the risks to human health. A Swiss survey of one hundred thirty eight companies using or producing nanoparticulate matter in 2006, resulted in forty completed questionnaires. Sixty five per cent of respondent companies stated they did not have a formal risk assessment process for dealing with nanoparticulate matter [11] Nanotechnology in the near future presents unique challenges for occupational health and safety professionals to anticipate and control, this will only become more difficult as nanostructures become more complex. The size of the particles renders most containment and personal protective equipment ineffective. The toxicology values for macro sized industrial substances are rendered inaccurate due to the unique nature......

Words: 2432 - Pages: 10

Free Essay

Clearing and Fowarding

...EAC CU 007 FREIGHT CLEARING AND FORWARDING PROCEDURES Course Description Explains and introduces trainees to: • Freight Forwarding services • Documents and documentation of import and export • Key legal rights, duties and responsibilities of a forwarder • Internal and external organisational environment • Forwarder relations to other parties • Warehousing, packaging and packing • Handling of dangerous goods • Cargo clearance procedures at the front office • Documentation and carriage of goods under the various transport modes • Computation of freight rates Course Objectives At the end of the course the trainees must be able to: • Identify the scope of clearing and forwarding, the field environment including rights, duties and responsibilities of a freight forwarder • Outline usage of import, export documents and associated terms in relation to C&F operations aspects of international trade • Appreciate the legal context /implication of various documents used in import-export and their sources • Demonstrate ability to perform consolidations and plan intermodal journeys for containerised and conventional cargo • Demonstrate general knowledge on the handling and classification of dangerous cargo under various transport modes • Appreciate outcomes of international conventions and their application • Identify procedures relating to clearance an forwarding cargo in international trade • Appreciate the essence of warehousing ,packaging and packing of goods •......

Words: 11668 - Pages: 47

Premium Essay

Access

...Introduction to Microsoft Access 2003 Zhi Liu School of Information Fall/2006 Introduction and Objectives Microsoft Access 2003 is a powerful, yet easy to learn, relational database application for Microsoft Windows. This tutorial is designed for users who are new or only have little experience using Access 2003. It introduces fundamental database concepts and operations and illustrates how they are performed in Microsoft Access 2003. This tutorial does not cover all of the features and functions of Microsoft Access 2003; emphasis will be on basic and frequently-used features, such as the creation of tables and queries, or importing spreadsheet into Access. Please be aware that Microsoft Access is only available for Windows users; Mac users may want to seek out a FileMaker Pro Tutorial. Objectives By using this tutorial, you will learn to perform the following operations in Access 2003: • • • • • • Launch Access and identify the parts of the screen. Define fields and field properties constructing table structures. Enter and edit records in a table. Find, sort data. Design custom queries to display data. Import and export data between Excel and Access. Definitions These words are used often in Access so you will want to become familiar with them before using the program and this tutorial. Relational Database: in relational databases such as Access, data is stored in tables made up of one or more fields (Access calls a column a field). The data stored in each 1 ...

Words: 3238 - Pages: 13