El caucho de llantas recicladas

Microsoft Access is an RDBMS by the Microsoft Corporation. It has a wide range of functions, including related searches, sorting by multiple fields, and links to external tables and databases. Thanks to the built-in VBA language, it allows you to create applications to work with your databases.

Versions of Microsoft Access:

1993. Access 2.0 for Windows (Office 4.3) 1995. Access 7 for Windows 95 (Office 95) 1997. Access 97 (Office 97)

1999. Access 2000 (Office 2000) 2001. Access 2002 (Office XP)

2003. Access 2003 (Microsoft Office 2003)

2007. Microsoft Office Access 2007 (Microsoft Office 2007) 2010. Microsoft Office Access 2010 (Microsoft Office 2010 TP)

Microsoft Access Setup

Microsoft Office Access 2007 part of the Microsoft Office 2007 package, is used as a DBMS.

The first step is to create the database. The database must be created on the computer where the Data Center component is set up and used. Accordingly, Microsoft Access must also be set up on this computer.

To create a new database, open the «File» menu (in Microsoft Office Access 2007 and later a round icon with an image of the Microsoft Office symbol is used instead of the «File» menu) and select «New». The main program window is shown in Figure 1.

61

Figure 1.

On the right-hand side of the program window, the database create window will appear (Figure 2). You must choose a path for the new database, enter a name, then click «Create».

It is recommended that you choose something simple and intuitive as the database name, for example, «Activity».

62

Figure 2.

63

Figure 3.

You can close this menu, since Data Center creates all necessary tables itself on first access of the database.

After this, Microsoft Access setup is complete.

Data Center Configuration

Once the new database is created, Data Center should be set up in order to work with it. For this, you must open the program’s management console, go to the «Configuration» page shown in Figure 4, and select «Data Storage Settings».

64

Figure 4.

65

Figure 5.

On the second tab, specify the parameters for connecting to the database (Figure 6).

To avoid the need to enter the connection string manually, the program has a special tool, to use which you simply click the button by the connection string field.

66

Figure 6.

The dialog that opens, shown in Figure 7, allows you to choose the type of OLE DB provider, through which the connection should be set up.

Choose Microsoft Office 12.0 Access Database Engine OLE DB Provider and click «Next». If another version of Microsoft Access is being used, then the name of the OLE DB provider may differ.

67

Figure 7.

On the second tab, enter the connection parameters, as shown in Figure 8, where,

C:\Users\Admnistrator\Documents\Activity.accdb – name of database file created earlier.

Attention! It is important to understand that since the connection parameters will be used in Data Center, all paths are displayed in relation to the computer on which Data Center is being used. This is especially important if Data Center and the management console are set up and used on different computers on the network.

User name – the user whose name will be used to connect to the database.

Attention! In Microsoft Office Access 2007 , protection for new file formats is not supported at user level, therefore «Admin» should be entered as the username.

Password – password of the user whose name will be used to access the database.

Blank password – means that a blank password is used to access the database (if you wish, you can protect the database with a password; in this case you should disable this option).

68

Figure 8. Click «OK» to continue.

Once you have entered all the necessary connection parameters, a connection string will be generated automatically, as shown in Figure 9. The contents of the string may change depending on the information entered earlier.

69

Figure 9.

Once you have pressed «Test Connection» the program will attempt to connect to the database, and if the connection settings have been specified correctly, the message shown in Figure 10 will appear.

Figure 10. When the connection testing is complete, click «OK».

A message will appear notifying you that Data Center must be restarted for the new parameters to be applied (Figure 11).

70

Figure 11.

Click «Yes», and Data Center will restart automatically. Once Data Center is restarted, all changes will take effect and the program will begin using the new database to store information.

To test the efficiency of the new database, simply print any document so that it prints to the database (on a virtual printer, or from a computer with an agent working in Client Side Monitoring mode installed). If the actions described above have been carried out correctly, the program will allow you to format a report displaying information about the printed text document.

The status of the database can be viewed on the «Statistics» tab of the data storage management dialog (Figure 12).

Figure 12. Conclusion:

On the one hand, Microsoft Access DBMS is the simplest system in terms of setup, whereas on the other, it is not recommended for use by medium and large-sized companies, since it is a desktop product and is unable to store and process data satisfactorily once the database reaches a certain size (comparatively small).

71