Free Essay

Microsoft Access Database Terms

In: Computers and Technology

Submitted By tjpurdin
Words 348
Pages 2
There are numerous terms used in the Access database. Some of the more common terms are, Form, Layout, Design, Table, Query & Report. If a user is not familiar with Access or has very little knowledge they would probably need to have these terms explained to them.
A Form is the easy to use screen where they enter Their data and the Layout is where they would modify the size, formatting or position of the controls. They would be able to see their data as they work to change the layout which is extremely useful on helping them to set everything up the way they want it. Design is the area where they would modify or change the Header, Footer or details of a section or the entire form. The Table is where all of their data is located in a spreadsheet-like view and they can have several tables with data that they can bring together by using a Query. The Query is the tool that allows them to select, organize and present the specific information they want on a report. The Report is the presentation of that information in whatever format they feel is the best for their needs. It could be something simple for personal use or something elaborate for a business meeting.
The knowledge base of the customer is going to determine how extensive the explanation of the terms needs to be. It’s very possible that a more detailed description of each term would need to be given to someone brand new to using Access. Someone who has more experience is going to be familiar with most of the terms and would probably only need a few things they are not overly familiar with explained.
It would be fairly easy to determine the experience level of the customer. The questions they ask would be a good indicator. Someone who is an experienced user will normally ask a more specific question, speak the language with you and in most cases probably understand what you are saying quicker than someone who is new to the system.

Similar Documents

Premium Essay

Databases in Use

...Databases in use:- 1. Mysql What is MS SQL? It is a relational web hosting database that is used to store web site information like blog posts or user information. MS SQL is the most popular type of database on Windows servers. It is not free but it has many advanced features that make it suitable for businesses. What is MS SQL capable of? In basic terms, an MS SQL database is capable of storing any type of that you want. It will let you quickly store and retrieve information and multiple web site visitors can use it at one time. You will use SQL statements to accomplish all of this. In more technical terms, most versions of MS SQL have the following features: • Buffer management • Logging and Transaction • Concurrency and locking • Replication services • Analysis services • Notification services • Integration services • Full text search service • Stored procedures • Triggers • Views • Sub-SELECTs (i.e. nested SELECTs) What is MS SQL used for? MS SQL is the database of choice for web applications on a Windows platform (using .NET or ASP). These languages make is extremely easy to connect to a MS SQL database. It is also used for many popular content management systems and other scripts. Learn more about what is MS SQL on its official website. They have comprehensive learning material. You should also check out the SQL tutorial on W3Schools and some articles on the SQL Community Server blog. If you are looking for a web host that supports MS SQL, look at...

Words: 2647 - Pages: 11

Premium Essay

It206

...i MS Access Exercise You are working at a support desk for a company providing onsite and telephone support to customers with Microsoft Access questions. On this particular day, you are presented with the following three situations: Situation 1: Jack, a veterinarian, has experienced tremendous growth within his business. All animal records are shelved in folders and are sorted alphabetically by the owner’s name. Jack is ready to rid himself of the time and space these files take and has inquired about Access. He wants to know about the key functions of using Access and how a table, query, primary key, and a report are important to his database needs. For this person exploring about the Microsoft Access and the key functions, I would start with clarifying that Microsoft Access is used to make databases for all the animal records. Microsoft Access users can make tables with the customer’s advice, forms, reports on the animals, their care, and the customer’s payment history. Microsoft Access puts all the information combined composing a relationship between all the data entered. The tables made within the Microsoft Access database can include the information on the animals, and all the records of care given to each person’s animal. Microsoft has the capability to make these reports to provide an analysis of the data. The Microsoft Access database contains a query interface that lets the data to be inserted, and reports for printing. With Microsoft Access the person can...

Words: 721 - Pages: 3

Free Essay

Week1 Solution Ciss430A

...1.2 What is the most commonly used type of database? Ans. The most commonly used type of database is Relational Database. 1.7 Define the terms data and information. Explain how the two terms differ. Ans. There is a subtle difference between data and information. Data are the facts or details from which information is derived. Individual pieces of data are rarely useful alone. For data to become information, data needs to be put into context. 1.22 Define the term database. Ans. Database is a collection of data in an organized form which allows a user for fast storage and retrieval of required data. 1.27 Is Microsoft Access a DBMS? Why or why not? Ans. Microsoft Access is not just a DBMS it is also an Application Generator. Although Microsoft Access contains a DBMS engine that creates, processes, and administers the database, it also contains form, report, and query components that are the Microsoft Access application Generator. 1.33 Name the components of an enterprise-class database system. Ans. These are the components of an enterprise-class database system: 1. Applications Running Over Corporate Network 2. E-Commerce Applications on Web Server 3. Web Portal with Reporting Applications 4. XML Web Services Applications 5. Mobile Apps 1.37 List several consequences of a poorly designed database. Ans. These are the consequences of a poorly designed database: 1. Redundancy 2. Improper Tables or Many Tables for same Object 3. Null Values...

Words: 462 - Pages: 2

Premium Essay

Party Plates

...of Party Plates Converting to Microsoft Access Party Plates is a rapidly growing institution and an outstanding plate and napkin supply pioneer, now again, newly poised to guide the direction of special event markets. The increase of company supply paired with the current high demand for said product presents the need for upgrades to the current information system software. Current software is somewhat out-of-date which could result in regression of company growth. Party Plates must acknowledge the ever-changing status of technology and invest in the implementation of new information systems, or current system upgrades. Team C suggests investing in software which will convert current data from Microsoft Excel into a relational database using Microsoft Access. The usefulness of the conversion software will improve internal communications while assisting to streamline some of the work processes for sales departments. This will also increase efficiency in both communications and sales; thus, creating a solid platform for each resulting smoother communications and an increase in sales. Sales will increase because the department can use Microsoft Access with much more facility, which permits more time to focus primarily in sales, not wasting time on dealing with outdated software issues. Systems often crash leaving employees to return to working manually and on their own until the system is restored; the employees at Party Plates using Microsoft Access, can be sure support will be......

Words: 848 - Pages: 4

Premium Essay

Rock Bottom Records Proposal

...e-business to economic infrastructure, traditional brick and mortar businesses are finding it difficult to compete with more streamlined businesses that are outsourcing their products and services via the Internet. Streamlining Rock Bottom Records by adding a relational database management system (RDMS) and a website will increase productivity and cost savings by reducing the amount of time it takes for analyzing productivity, ordering and shipping, financial, and payroll. Adding a website with a RDMS and offering digital music downloads the company will be able to compete with other companies worldwide. The most popular affordable RDMS’s that are in use today are Microsoft Access that comes with Microsoft Office (Professional) is popular with most small businesses ("Microsoft Access Database: The Pros With Less Cons When Using Microsoft Access As Your Database", n.d.)., PostgreSQL which runs on multiple operating systems and is an open source database, meaning it is free (“PostgreSQL”, 1996-2012)., MySQL is also an open source database that runs on multiple operating systems ("Advantages And Disadvantages To Using Mysql Vs Ms Sql", n.d.)., MSSQL is a closed, propriety database that works great with Microsoft programs ("Advantages And Disadvantages To Using Mysql Vs Ms Sql", n.d.)., and Fire Bird which works well with Window and is also...

Words: 1026 - Pages: 5

Premium Essay

Microsoft Access or Microsoft Sql Server: What's Right in Your Organization

...Microsoft Access or Microsoft SQL Server: What's Right in Your Organization? SQL Server Technical Article Writers: Luke Chung Technical Reviewer: Matt Nunn Published: December 2004, revised July 2006. Applies To: SQL Server 2005 Summary: This paper explains how Microsoft® Access is used within an organization. It also explains when to use Access and when to use Microsoft SQL Server™. Copyright The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. This White Paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation. Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights......

Words: 6412 - Pages: 26

Free Essay

International Trade and Finance Speech Eco 372

...with all data. In order to improve the efficiency of the current information systems used in Party Plates, the antiquated system needs to be upgraded to a much more efficient system such as Microsoft Access. The upgrade will benefit the company in terms of better data tracking and the ability of producingto produce useful reports in relation to customer sales. Microsoft Access is a database software that allows a user to manipulate large amounts of data. Unlike Excel, Access can hold more than 65 thousand records, which can be converted and viewed in various forms depending on what is needed. Microsoft Access offers two main benefits, its user friendly friendliness and its ability to hold large amounts of data without sacrificing performance. Microsoft Access functions in different ways that tie together …what? . Tables are used to store data from which queries can pull information from and perform calculations against the data. Forms can be used to enter information into tables. Reports will allow the information to be displayed in a printer-ready format. The reports can also be exported to other Microsoft Office programs, such as Excel or Word. Finally, macros allow for the automation of database tasks. Modules are an area for advanced programming language within the database. The last sentence does not support the topic - Refer to grammar guide for details on how to avoid dependent clauses and run-on sentences ......

Words: 1402 - Pages: 6

Free Essay

It 206 Week 5 Mail Merging Checkpoint

...I would start out by explaining to the customer what Microsoft Access is. Microsoft Access is software that manages databases. The database collects, organizes, and stores information about things. The second thing I would do is introduce some basic terms of Microsoft Access. A database table looks a lot like a spreadsheet. There are rows and columns like a spreadsheet, which makes it easier to convert a spreadsheet into a database. Each row and column in a table is referred to as a record. Records are where the information that you are entering is stored. The rows hold one type of information; the columns hold a different type of information. Reports are the data that is processed in the tables. Basically, if you have a datasheet made for yearly spending, you can look up a report for whatever year you’re looking for or the current year. Macros in Microsoft Access are a type of programming that helps add functionality to a database. Macros can help simplify things if you have enough experience with it. One example of how Macros can help is, when a person types a certain command, a report can open, a query can be ran, a report can be closed and so on. This programming basically makes life easier by using simple commands. The description of these would vary because depending on how much they know about technology, they may or may not be able to understand these explanations. In order to determine their experience level, one can generally tell by the way......

Words: 275 - Pages: 2

Free Essay

Counseling Management System

...Company Profile Star Wire (India) Limited, one of the leading Mini Steel Plant is engaged in the manufacturing of Alloy Steels, Stainless Steel and Special Steels for diversified engineering application in shape of castings, forging and rolled products. Plant is fully equipped with modern equipment and testing facilities which have created confidence and ability for manufacturing various sophisticated grades of steel conforming to international and National standards. It has its own research and development center to facilitate the manufacturing activities and also catering to engineering and manufacturing industries for failure analysis and other analytical activities. The plant is situated in Ballabgarh, about 37 KMs from Delhi - Capital of India on Main Mathura Road (NH No. 2). The location is at easy approach by Air, Rail and Road. ABSTRACT The project “Counseling Management system” is to exploit the computer technology with Internet Facility and all its aspects as necessity arises. The proposed project will be a web-based portal to provide support and services to the Students of participating in university counseling. The project will make available the Students care services of member colleges to its Students through the Internet. Through this proposed website the Students can register herself and take Admissions and support accordingly. The project “Counseling management system” is specially associated with online Admission procedure......

Words: 9525 - Pages: 39

Premium Essay

Information System

...Using Microsoft Access Getting Started Using Microsoft Access Microsoft Access is a computer application used to create and work with databases. In computer jargon that means it’s a Database Management System or DBMS. So what is a database? A database is basically a collection of data or pieces of information. Whether you know it or not, you use databases all of the time. Some examples of commonly used databases might be: • • • • Address book Library catalogue Telephone directory Stock list A database isn’t necessarily contained on a computer. A telephone directory is still a database even if it’s in the form of a huge book sitting next to your phone. However, for the purpose of these exercises, we will assume that the term database refers to an organised collection of information stored on a computer. Databases are intended for storing and maintaining large amounts of information. The following are examples of the sort of information that can be kept in a database: • • • • • Inventory control Payroll systems Personnel records Music collection catalogue Phone and address lists In the exercises that will follow you will create a simple database while you learn the basic features of Access. Later on, you will create a more complex database as you learn more advanced features in addition to some of the principles of database theory. In these exercises it is assumed that you are familiar with Windows use and have experience in using other applications such as Word or...

Words: 4436 - Pages: 18

Premium Essay

Inventory Control

...Abstract This plan details the components necessary to develop a low-cost inventory control system to replace a frustrating manual tracking and reordering process. The hardware and software needed to implement the system is detailed as well as the cost associated with creating it. Furthermore, administrative functions associated with operation and maintenance of the system is provided with high-level descriptions. Critical counts can be adjusted to meet business specific requirements for any product detailed in the database. The system works in a circular process, from purchase tracking to inventory monitoring to re-ordering and back around again. This design allows a simple and efficient method to produce and inventory control system with the flexibility to manage many product types and suppliers.   We all interact with inventory control systems on a daily basis. Rather it is at your local grocery stores checkout line or products purchased from your favorite online retailer, inventory control systems are at the center of our supply and demand chain. These systems ensure when we place our orders for products that the in stock, on order and committed quantities are accurate and monitored. It’s very common for large companies to use these types of systems is also becoming more common for small businesses. The following plan presents a low-cost alternative to the manual processes currently used by a small clothing store. The systems capabilities allow frustrating task such......

Words: 832 - Pages: 4

Premium Essay

Sales Director Justification Report

...evaluations along with employee knowledge base of programs should provide a good data sets for both reviewed programs. The report finds that Microsoft Excel offers the employees easier input options that perform similar tasks as Microsoft Access. This allows ABC Sales to develop the most robust data sets for the lowest cost, with minimal additional training requirements to existing staff. It is clear that ABC Sales Department needs to choose Microsoft Excel. Problem Statement The ABC Sales Department has an organizational problem. ABC Sales Department does not keep a record of annual inventory renewal schedules for their special projects. The sales department needs to start to keep these records in order to properly plan future budgets, set realistic goals for employees to reach, and be able to forecast proper pricing for renewals. The sales director needs to implement an easy to use and cost affective tracker for the managers to use. The managers need to start tracking these items in order to increase revenue so that the ABC Company can be successful in the market. Overview of Alternatives The following two alternatives considered in this report meet the ABC Company requirements: Alternative A-Microsoft Excel Spreadsheets In order to understand and track the revenue and dates of prior existing orders, databases can be exported...

Words: 2025 - Pages: 9

Premium Essay

A Comparative Investigation and Evaluation of Oracle9I and Sql Server2000 with Respect to Performance and Scalability

...Abstract: Performance and scalability are two omnipotent factors determining database availability and reliability. This is especially true for modern computer systems due to the inclusion of the Internet in Online transaction processing (OLTP) and E-commerce applications which use databases. This evolution gave birth to an enduring need for high throughput, good response time, excellent data consistency and concurrency control. This paper evaluates SQL server 2000 and Oracle 9i with respect to performance and scalability. Initial performance tests showed that at low to medium workload both database systems behaved in a similar fashion in terms of throughput and response time. At high load however Oracle 9i emerged victorious in both cases. market and use of the Internet in databases. The first point has lead to competition between commercial and open source database vendors while the second has resulted in a need for high performance database systems. This whole controversy has in the past lead database vendors to employ numerous tricks in bid to improve the processing speed of their systems during benchmarking and thus falsely prove that their databases products are superior to other competitors. Some of their tricks include using high-speed CPUs and clusters, caching up data rows and storing SQL execution plans into RAM prior to testing thus bypassing disk I/O access and tremendously increasing performance (Burleson D, 2002).AS a result......

Words: 3061 - Pages: 13

Premium Essay

Sales Director Justification Report

...evaluations along with employee knowledge base of programs should provide a good data sets for both reviewed programs. The report finds that Microsoft Excel offers the employees easier input options that perform similar tasks as Microsoft Access. This allows ABC Sales to develop the most robust data sets for the lowest cost, with minimal additional training requirements to existing staff. It is clear that ABC Sales Department needs to choose Microsoft Excel. Problem Statement The ABC Sales Department has an organizational problem. ABC Sales Department does not keep a record of annual inventory renewal schedules for their special projects. The sales department needs to start to keep these records in order to properly plan future budgets, set realistic goals for employees to reach, and be able to forecast proper pricing for renewals. The sales director needs to implement an easy to use and cost affective tracker for the managers to use. The managers need to start tracking these items in order to increase revenue so that the ABC Company can be successful in the market. Overview of Alternatives The following two alternatives considered in this report meet the ABC Company requirements: Alternative A-Microsoft Excel Spreadsheets In order to understand and track the revenue and dates of prior existing orders, databases can...

Words: 2026 - Pages: 9

Premium Essay

Deploying-Veritas-Backup-Exe

...PS Series Best Practices Deploying VERITAS™ Backup™ Exec 10 and Auto-Snapshot Manager Abstract This Technical Report describes how to back up and restore NTFS volumes, Microsoft Exchange e-mail, and SQL databases using VERITAS Backup Exec 10, the EqualLogic Auto-Snapshot Manager for Windows VSS provider, and PS Series storage arrays. Copyright © 2005 EqualLogic, Inc. August 2005 EqualLogic is a registered trademark of EqualLogic, Inc. All trademarks and registered trademarks mentioned herein are the property of their respective owners. Possession, use, or copying of the documentation or the software described in this publication is authorized only under the license agreement specified herein. EqualLogic, Inc. will not be held liable for technical or editorial errors or omissions contained herein. The information in this document is subject to change. PS Series Firmware Version 2.1 or later. ii Deploying VERITAS Backup Exec 10 and Auto-Snapshot Manager Table of Contents Technical Report and Software Revision Information......................................................... iv Introduction ............................................................................................................................1 Common Backup and Recovery Configurations ...................................................................2 Backup and Recovery Media .................................................................................................3 Backup to Disk...

Words: 9581 - Pages: 39