A Look at Microsoft Access
A Look at Microsoft Access
Introduction
Team A of DBM/405 has chosen to look at Microsoft Access. This paper will examine Microsoft Access and its capabilities and benefits. It should show that Microsoft Access is one of the easiest user friendly database and cost effective database applications today. This paper will also examine the use of Access for a business called Parrothead Productions. It is a small one-man operation, which is a remote disc jockey business.
The Capabilities of Microsoft Access
Microsoft Access database gives you true command of your data, enabling you to retrieve it, sort it, analyze it, summarize it, and report results in moments. It can combine data from various files, so that you never have to enter information twice. It can even make data entry more efficient and accurate. Microsoft Access creates relational databases, which mean that data is stored in various separate tables by subject or task, but the data is related and can be brought together in ways that you specify. Microsoft Access creates relational databases, which means that data is stored in various separate tables by subject or task, but the data is related and can be brought together in ways that you specify. Relationships link data between two or more tables to increase its usefulness.
Access consists of objects such as, Tables, Queries, Forms and Reports. Tables; store your data in rows and columns, Queries; retrieve and process your data. They can combine data from different tables, update your data, and perform calculations on your data. Forms; control data entry and data views. They provide visual cues that make data easier to work with. Reports; summarize and print your data. They turn the data in your tables and queries into documents for communicating ideas.
Tables store data, so they're essential building blocks of any database. Each table contains rows called records and columns are called fields. A record is a collection of facts about a
Introduction
Team A of DBM/405 has chosen to look at Microsoft Access. This paper will examine Microsoft Access and its capabilities and benefits. It should show that Microsoft Access is one of the easiest user friendly database and cost effective database applications today. This paper will also examine the use of Access for a business called Parrothead Productions. It is a small one-man operation, which is a remote disc jockey business.
The Capabilities of Microsoft Access
Microsoft Access database gives you true command of your data, enabling you to retrieve it, sort it, analyze it, summarize it, and report results in moments. It can combine data from various files, so that you never have to enter information twice. It can even make data entry more efficient and accurate. Microsoft Access creates relational databases, which mean that data is stored in various separate tables by subject or task, but the data is related and can be brought together in ways that you specify. Microsoft Access creates relational databases, which means that data is stored in various separate tables by subject or task, but the data is related and can be brought together in ways that you specify. Relationships link data between two or more tables to increase its usefulness.
Access consists of objects such as, Tables, Queries, Forms and Reports. Tables; store your data in rows and columns, Queries; retrieve and process your data. They can combine data from different tables, update your data, and perform calculations on your data. Forms; control data entry and data views. They provide visual cues that make data easier to work with. Reports; summarize and print your data. They turn the data in your tables and queries into documents for communicating ideas.
Tables store data, so they're essential building blocks of any database. Each table contains rows called records and columns are called fields. A record is a collection of facts about a