Download
1 / 5
50 likes | 151 Vues
A database is a structured set of data stored in a computer or online, allowing organized collection and management. Unlike Microsoft Excel, databases like Microsoft Access provide better control over data through a system of tables, columns, and rows. They are widely used in schools, hospitals, and various organizations to manage large amounts of information. Users can create queries to find specific information and generate detailed reports easily. This guide covers the basics of creating queries and reports in Access to effectively manage your data.
E N D
Databases By Danny, Tom and Sniz
Dictionary Definition – A database is a structured set of data held in a computer or online. • Wiki Definition – A database is organised collection of data. • Databases are a method of storing data like Microsoft excel or Microsoft access. They use a system of tables and coeloms and rows. What is a Database?
Access allows you to control of your data, where as on excel you have less control. • Access can be used in schools, hospitals and anywhere else that needs to keep lots of information on people, equipment or money. • If you enter a query it can help you find specific information, however excel does not include this feature. Database Information
First you press Create • Then click Query Design • Next drag the appropriate things into the top boxes • Then you should have your query How to do a Query
First create the query • Then click the report button along the top row • Then go onto page setup and change it to landscape • Then edit the colours and the design to your pleasing How to make a Report
