Topics of the article on informatics at school. A personal computer is not a luxury
Access 2010, despite its popularity and ease of use, remains a mystery for most users. This program, published for the first time in 1992 for Windows 3.0, was included in the Microsoft Office package and became widespread due to its convenient usability and the ability to write applications based on Access itself to work with complex databases.
Although at the first encounter with Microsoft Access 2010 it seems that only advanced users, computer scientists and programmers use such a program, in practice it can greatly simplify the life of any working person.
Access 2010 in Russian free download:
To understand the meaning of using Access, it is enough to imagine a simple notebook in which a table is kept with a list of work performed, their dates, costs and results. Such a notebook can also be kept manually, even if there are several types of work at different rates. In this case, the results are knocked down using a simple calculator.
How to install Access 2010
Run the installer click "Setting"
Mark in the list do not install everything except Access and funds office
Click install, wait for the installation to complete.
If the problem is with the download:
Organize and organize
But what if the calculations need to be made immediately for a dozen workers performing 2-3 types of work? For a whole month, about a hundred different tables can accumulate, the results of which will have to be recalculated regularly. One single table with linked data of workers, types of work, their cost and any other necessary information in Access can replace thousands of single plates. The convenience also lies in the fact that editing data in any linked database will be done automatically in the main table and wherever the changed information is mentioned.
Everyone needs it
Even if you do not own a business, do not count money and do not organize someone's work, this program will help you manage your family budget, pay utilities, registration of addresses and telephone numbers, etc.
Features of working with the program
Access is a relational database management system, that is, a set of tools for managing a set of two-dimensional tables. To get started, you can use the standard template: faculty, marketing projects, tasks, contacts, and others.
The most convenient is the ability to quickly obtain the necessary information by creating queries, and reports generated from tables optimize the data in a form convenient for printing. In practice, it is very useful to be able to create web pages with data available on the Internet. It helps to coordinate the work of people working from home in different places city or even in different cities.
Microsoft Access 2010 is perfectly suited not only for homework, but also for programming databases with subsequent demonstration of the result to the customer. Applications derived from it, written in Visual Basic for Applications, help coordinate even fairly large-scale accounting calculations, and the ability to create macros makes this job even easier.
application program Microsoft Access 2007 designed to create Database. Access 2007 uses logically related tables. DBMS Microsoft Access 2007 provides convenient and reliable management of data stored in tables.
The essence of creating a database in Microsoft Access 2007 is that you first need to create a database structure (create a table structure and establish relationships between them), and then you need to fill in the tables of the new database.
In addition, it is desirable to create forms to enter data into tables, requests to search for information in the database and reports to display the necessary information from the database in a convenient form on the screen, print or file.
The database can be created either manually (a new empty database) or based on templates. Templates do not always correspond to the required database, but with their help you can quickly create a database close to what is required, and then you can modify it and fill it with your data.
At startup application program Access 2007, the screen will display the new "Getting Started with Microsoft Access 2007" welcome page, shown in Figure 1-1. one.
Rice. 1. New start page
When creating a database based on templates, you can select the required template on the Getting Started with Microsoft Access 2007 page from the Template Categories or the From Microsoft Office Online templates. When you select, for example, the Faculty template in the Local templates category, a description of the database will appear on the right side of the application window. Below, in the text field, the file name is indicated: Faculty.accdb and a folder icon with which you can save the file to the desired directory (the default folder is My Documents).
The file name and directory for storing the file can be changed. Then you need to click on the Create button. As a result, the database window Faculty: database (Access 2007) - Microsoft Access will appear. The Editing Area will display the Faculty List to be completed. If the Navigation Pane is closed, it must be opened by pressing the F11 key or by clicking on the "Open/Close Navigation Pane Border" button.