Preview

Access Lessons

Good Essays
Open Document
Open Document
3746 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Access Lessons
Key Terms
Access Lesson 6: Integrating Access

Comma-separated values (CSV): File format where commas separate the field values of each record in the data source. (AC 142)
Data source: The place where the form letter goes to get its data, such as a Word document or
Access database. (AC 150)
Delimited data: When data is formatted using comma separators, it is called delimited data.
(AC 142)
Delimiter: When data is formatted using comma separators, the commas are called delimiters.
(AC 142)
Export: When you save database data in another file format. (AC 140)
Form letter: A document that includes codes that print information from a data source. (AC
150)
Import: When you copy data from another Access database or other file format into an existing or new table in the current database. (AC 140)
Main document: When you merge data with a form letter, the form letter is the main document.
(AC 150)
Merge field: When you insert a codes into the main document, it is called a merge field. (AC
150)
I. Mission and Vision

Mission

As a wholesaler and retailer of automotive spare parts, the company aims to serve the needs and requirement of various type of automobile. It aims to provide high quality parts and materials for the proper maintenance and repairs of the vehicle.

Vision
The business envisions itself to become the number automotive parts supplies in the Cavite region.

II. Organizational Chart

III. Historical Background:

The Golden Key Auto Supply is a Filipino business. Based in Dasmariñas, Cavite, the auto supply was founded by Salvador E. Young in June 1999. The Young's family was in the automotive parts dealer for almost forty years. It started at Sorsogon, Sorsogon in 1976 and had established branches at Samar, Tabaco Albay and in Makati. As the family migrated to Cavite, they decided to put up the Golden key Auto Supply at Dasmarinas, Cavite. In 2008, they renamed the business to saviour Auto supply.

IV. Background of the Study

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Analyzing Data Checkpoint

    • 359 Words
    • 2 Pages

    The first step is to determine exactly what analyzes you want to perform and ensure that you gather all that is needed. Keep in mind to import into Access it has to be formatted properly as an excel document. The second step is to create a database. This can be done by opening Access and creating a blank database (file, new, blank database). You will be prompted to name the database and where you would like to save it. Step three is to edit and validate all data. Be sure to have a primary key and that all data is valid. If the data were imported without, identifying a primary key or the data is “dirty” or not valid these issues can be addressed by using the utility queries in Access. The fourth step is to connect data files. When multiple data files have been imported into tables, edited, and validated, you need to connect the tables by creating relationships. Typically, a relationship connects a primary key in one table to a regular field in another table. For example, the Customer Number in the Customers table (a primary key) can be connected to the Customer Number field in the Sales table. You also need to establish a relationship between the matching fields in original tables and their validating tables. In our example, you would establish a relationship between the Customer Type field in the Customers table and the Customer Type field in the Customer Types table. Repeat this step for all validating tables.…

    • 359 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Positioned as a premium sports car manufacturing company providing best features and latest technology as well as best in class sporty driving experience…

    • 6010 Words
    • 22 Pages
    Good Essays
  • Good Essays

    Honda B Analysis

    • 1365 Words
    • 5 Pages

    Honda Motor Co. founded by a hardworking yet exploiting and known figure called Soichiro Honda post WWII. It is a story of a company that started from scratch with no significant scientific nor management bases. Despite the small start, luck and opportunity together with hard work and perseverance led to one of the most successful business journeys in the world and for the purposes of this paper the US in particular.…

    • 1365 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Free Cash Flow and Butler

    • 4148 Words
    • 17 Pages

    First we focus on the future outlook for AD in the auto market. In 1962 AD started as an automotive parts purchasing association controlled by independently owned affiliates. By the 1980s, AD began to acquire wholesales and the purchasing power of AD grew. In 1976 the network of AD expanded abroad, through an international subsidiary of AD (AD International). At the end of 1998 AD was the largest independent wholesaler of automotive parts in France and even in Europe.…

    • 4148 Words
    • 17 Pages
    Powerful Essays
  • Satisfactory Essays

    Itgs Ia

    • 432 Words
    • 2 Pages

    Word Document|Is for creating documents such as letters, brochures, learning activities, tests, quizzes and students ' homework assignments.|…

    • 432 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    - 1 -company produces a large range of vehicles which are highly regarded for their quality, engineering, and value; their designs set global standards for safety, reliability and ease of maintenance.…

    • 2034 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    Auto Parts, Inc., is a distributor of automotive replacement parts. With no manufacturing capability, all the products it sells are purchased, assembled, and repackaged. Auto Parts, Inc., does have extensive inventory and assembly facilities. Among its products are private-label carburetor and ignition kits. The company has been experiencing difficulties for the last 2 years. First, profits have fallen considerably. Second, customer-service levels have declined, with late deliveries now exceeding 25% of orders. Third, customer returns have been rising at a rate of 3% per month.…

    • 685 Words
    • 3 Pages
    Powerful Essays
  • Good Essays

    Data Flow

    • 952 Words
    • 4 Pages

    ▪ Data flow - pipeline which represents the movement of data from one point to another…

    • 952 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Describe who and what the information is for, where it will be used e.g. on screen or hard copy and where it is needed.…

    • 420 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Long-term strategy in order to transform itself from an automobile manufacturer into the world’s leading provider of additional services related to automobile business. The company’sgoal was to strengthen its financial services, retail businesses and Internet fields, etc.…

    • 2311 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Mehta Automobiles

    • 1115 Words
    • 5 Pages

    During his service at Standard Automobiles, Mr. Mehta had come to know very well some wholesalers of service materials, such as tools, stores and spare parts. This helped him in buying such material on credit.…

    • 1115 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Jazz My Ride Case Study

    • 700 Words
    • 3 Pages

    It was founded with a vision of aiding car owners to personalize their machines hence permitting them to travel more with effortlessness and style while helping them establish a unique identity for themselves. It is based in Delhi with 30 employees and has operations all around India. It offers 6500+ best quality Accessories best with matchless customer service to its clients. It has also got exclusive e-commerce selling rights for India from the international leading brands like Turtle Wax (USA), ABRO (USA) and XENOS…

    • 700 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Intro to Database Systems

    • 8189 Words
    • 33 Pages

    The term data may be defined as known facts that could be recorded and stored on Computer Media. It is also defined as raw facts from which the required information is produced.…

    • 8189 Words
    • 33 Pages
    Powerful Essays
  • Powerful Essays

    Culinary Arts Report

    • 1358 Words
    • 6 Pages

    APPENDICES (as needed)- below are examples A1: Forms A2: Event orders A3: Photographs A4: Sample of standardized recipe from each department.…

    • 1358 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    Indian Auto Industry

    • 1821 Words
    • 8 Pages

    •Easy Auto finance •Manufactures diversifying into related activities: finance lease, fleet management, insurance and used car market…

    • 1821 Words
    • 8 Pages
    Powerful Essays