Access+2007+Spotlights



What is Microsoft Access? Well, first we need to learn what is a database? Quite simply, it's an organized collection of data. A database management system (DBMS) such as Access, Oracle, and SQL Server provides you with the software tools you need to organize that data in a flexible manner. It includes facilities to add, modify or delete data from the database, ask questions (or queries) about the data stored in the database and produce reports summarizing selected contents.

 (1) **To store data on and retrieve data from a disk or other peripheral device.**

 (2) **The entrance to the Internet or other online service or network.**

 (3) **In computer security, the opportunity for use of a resource.**

Do I really Need a Database?
A **database** is a place where you can **store any information** you need to any specific topic. How you intend to use the information will determine whether you need an Access database or a different program to create and manage your data. **what a database does** and **how to decide whether you need a database** to manage your information, Access 2007 is a program that allows you to **do what you need.**



**//__Some of the most important new features within the Access 2007 upgrade include:__//**
 * ===__//Column Summaries://__ ===

Database developers will appreciate the ability to add summary information to the database. Access 2007 provides the ability for developers to add a row to the data sheet in order to display summary information, meaning that forms which are displayed in data sheet view can show summaries, such as sum, min, max, etc. at the bottom of each data sheet column.

The real power of an Access 2007 database is in the ability to pull data for quick analysis, which is what happens when you run a query. **Queries** allow you to retrieve information from one or more tables based on a set of search conditions you define. Access 2007 will display your results in their very own table that you can analyze and manipulate further.
 * ===__//Using Queries to Make Data Meaningful: //__===


 * 1) **How to plan a query**
 * 2) **How to Query Design**
 * 3) **How to Hide Fields** **&** **other information in your query results**
 * 4) **How to** save **the query for later use**


 * ===<span style="color: #0000ff; font-family: Georgia,serif; font-size: 120%;">__//Better Filtering://__ ===

<span style="color: #008000; font-family: Georgia,serif;">The new Access 2007 also provides vastly improved finds and filters, including such intuitive filtering as “between yesterday and tomorrow” and similar filters. These real language filters provide a great deal of flexibility for both database developers and ordinary users.


 * ===<span style="color: #0000ff; font-family: Georgia,serif; font-size: 120%;">__//Report view lets you filter your report://__ ===

<span style="color: #008000; font-family: Georgia,serif;">Access 2007 includes a new view for reports called Report view. You get a static snapshot of your data with the traditional Print Preview, but with the new Report view, you can dynamically filter the data and drill down to print only the information you need.

<span style="color: #008000; font-family: Georgia,serif;"> Access 2007 includes enhanced Quick Create commands that help you build new forms and reports with the click of a button. These enhanced commands create new data entry forms and reports complete with controls and graphics. The commands will help you get a jump-start on adding new objects to your database.
 * ===<span style="color: #0000ff; font-family: Georgia,serif; font-size: 120%;">//__Enhanced Quick Create commands help you build tables, forms, and reports:__// ===

<span style="color: #008080; font-family: Georgia,serif;"> <span style="color: #ff00e5; font-family: Georgia,serif;">



<span style="color: #ff0028; display: block; font-family: Georgia,serif; font-size: 180%; text-align: center;">//<span style="color: #008080; font-family: Georgia,serif;">Thank you // //**<span style="color: #ff00e5; font-family: Georgia,serif;">Hiral Patel **//