| Title | Decription |
|---|
| Mail merge | The report prints the contents of one letter to multiple recipients, who were elected by means of Form "Contact List" |
| Applied parameters | description |
| Telephone Book | The report contains a list of telephone numbers to persons who were elected by means of Form "Contact List" |
| Address labels | The report printing address labels with addresses of people who were elected by means of Form "Contact List" |
| Contacts details | The report contains jednostronicową information card with the details of persons who were elected by means of Form "Contact List" |
| Payment details | Form "Details of payments" contains information about the details are made to a user base of the payments. Such as: -- Who made the payment, -- For what, -- When, -- How much -- In what form, etc. |
| Invoice Outgoing (Original) | description |
| Payments list | description |
| Estimate | Valuations Construction Works |
| Leaflet | "Flyer" is a window prints. The database contains a wide variety of opportunities for printouts. Leaflet is a very intuitive tool to easily manage print-outs. At any time work it can be taken and have access to currently available prints. |
| Available Offices | Available flats |
| Available Offices | Available flats |
| Available Offices | Available flats |
| Available Offices | Available flats |
| Available Offices | Available flats |
| Notes | Notes on a note of the general and contact |
| Calendar | Notes on a note of the general and contact |
| Task | The tasks to be performed by a specific date. |
| Timetable | Statements of work or time commitment of resources over time. |
| Weight | Control of body weight. |
| Radio | The list of Internet radio stations |
| TV | Internet TV station. |
| Fixes & Errors | The Forum for reporting errors and ustarek database. |
| The Database | INTODUCTION<b> A database is a stored set of data that is logically interrelated. Typically this data can be accessed in a multiuser environment with defined rights and restrictions enforced with that access. At Professinal Database we utilise MS SQL Server and MS Access technology. SQL In June 1970 Dr. E. F. Codd published the paper “A Relational Model of Data for Large Shared Data Banks” in the Association of Computer Machinery journal Communications of the ACM. Codd’s model is now accepted as the definitive model for Relational Database Management Systems (RDBMS). The language, Structured English Query Language (SEQUEL) was developed by IBM to utilise Codd’s model. SEQUEL for legal reasons became SQL (still pronounced “sequel”). In 1979 Relational Software Inc. (now Oracle) introduced the first commercially available implementation of SQL. Today SQL is accepted as the standard RDBMS language. When our Clients require a web enabled database application with a concurrent user population of more than five we use one of two Microsoft implementations of SQL: MS SQL Server 2005 where data volumes and concurrent user populations are high – this is a licencable product. MS SQL Server Express where data volumes and concurrent user populations are moderate – this product is provided free of charge by Microsoft and is, to all intents and purposes identical to SQL Server 2005. ACCESS Microsoft Access, now known as Microsoft Office Access is actually the Microsoft Jet Relational Database Management System with a Graphical User Interface. Microsoft article Q300216 “How to keep a Jet 4.0 database in top working condition in Access 2000” has a sub – section “Additional Best Practises for Network Environments”. To quote verbatim: “Microsoft Jet is a file sharing database system. A file sharing database is one in which all of the processing of the files takes place at the client. When a file – sharing database such as Microsoft Jet, is used in a multiuser environment, multiple client processes are using file read, write and locking operations on the same shared file across a network. If, for any reason, a process cannot be completed, the file can be left in an incomplete or corrupted state. Two examples of when a process may not be completed is when a client is terminated unexpectedly or when a network connection to a server is dropped. Microsoft Jet is not intended to be used with high – stress, high concurrency, 24x7 server applications, such as Web, commerce, transactional and messaging servers. For these type of applications, the best solution is to switch to a true client/server – based database system such as Microsoft Data Engine (MSDE) or Microsoft Sequel Server. When you use Microsoft Jet in high-stress applications such as Microsoft Internet Information Server (IIS) customers have reported database corruption, stability issues such as IIS crashing or locking up, and also a sudden and persistent failure of the driver to connect to a valid database that requires re – starting the IIS service.” WHICH DO YOU NEED? With SQL Server the users do not interact with the raw data tables themselves but with an intelligent data manager which in turn writes to a transaction log. When the user signals to the Server that he/she has finished the intelligent data manager applies the data changes to the database itself. In the instance of a network problem or problem with the client machine the data manager is aware that the transaction has not been completed and does not apply the changes to the database, the database thereby retaining it’s integrity. In the instance of a server failure this transaction log can be re – applied allowing the database to be restored to the situation it was in before the failure. In the right environment this is scarcely a consideration – we have customers with 24x7 SQL Server databases running at Rackspace where no problems have been encountered since the systems went into production. With Access the story is different. Each user interacts directly with the raw data tables. If a user’s machine experiences problems these will usually have the effect of corrupting the entire underlying Jet Database. Network problems will have a similar effect. With increases in user populations and data volumes come increases in problems. To the extent that we would not develop an Access database for a customer who was planning to have more than three concurrent users for the foreseeable future. We would be delighted to review your database requirements and make a recommendation with no obligation. |
| Calendar | Calendar |
| Contact Details | "Details of contacts" to modół allowing the storage of highly differentiated data on individuals and companies. These data are introducing in a very transparent and intuitive form. Folmularz This allows you to add and edit previously entered information. |
| Contact List | "Contact List" is modółem, which allows unlimited possibilities for separating and finding data that we need. |
| Payment Details | Details of payments |
| Payment List | The list of payments. |
| Building Details | Buildings - to form with details of buildings. |
| Offices Details | Details of the offices or premises |
| Out coming Invoices Details | Details of invoices and accounts for outgoing contractors. |
| Out coming Invoices List | List of outgoing invoices and accounts for contractors. |
| Incoming Invoices List | List of incoming invoices and bills from contractors. |
| Incoming Invoices Details | Details of invoices and bills coming from the contractors. |
| Controls Payments | Controlling a form corresponding to question a long time ago, the contractor has made the last payment for the goods / service. |
| Estimates Details | Details of valuations made by the user database. |
| Estimates List | The list of valuations made by the user database. |
| Library List | The list of products and services that are offered własciciela database. |
| Library Details | Details of the products and services that are offered własciciela database. |
| Meters | Counters measuring the flow of Padu media such as electrical, gas, etc. |
| Agreements Details | Agreement details - to form resetting the details of agreements such as m. Inn. -- The name of the contractor -- Date of conclusion -- Duration -- Description, etc. |
| Agreements List | Agreement list - to form to search among a list of contracts by the user database. |
| Agreements Details | description |
| Available Offices | Controlling a form corresponding to question a long time ago, the contractor has made the last payment for the goods / service. |
| Passwords List | Kontrola płatności to Formularz odpowiadający na pytanie jak dawno dany kontrahent dokonał ostatniej płatności za dany towar/usługę. |
| Advertisement | Form resetting the text of advertising used by użtkownika database |
| Options | Options database. Setting environmental and customization of the database to their preferences. |
| Database Descriptions | INTODUCTION A database is <br>a stored set of data that is logically interrelated. Typically this data can be accessed in a multiuser environment with defined rights and restrictions enforced with that access. At Professinal Database we utilise MS SQL<b> Server and MS Access technology. SQL In June 1970 Dr. E. F. Codd published the paper “A Relational Model of Data for Large Shared Data Banks” in the Association of Computer Machinery journal Communications of the ACM. Codd’s model is now accepted as the definitive model for Relational Database Management Systems (RDBMS). The language, Structured English Query Language (SEQUEL) was developed by IBM to utilise Codd’s model. SEQUEL for legal reasons became SQL (still pronounced “sequel”). In 1979 Relational Software Inc. (now Oracle) introduced the first commercially available implementation of SQL. Today SQL is accepted as the standard RDBMS language. When our Clients require a web enabled database application with a concurrent user population of more than five we use one of two Microsoft implementations of SQL: MS SQL Server 2005 where data volumes and concurrent user populations are high – this is a licencable product. MS SQL Server Express where data volumes and concurrent user populations are moderate – this product is provided free of charge by Microsoft and is, to all intents and purposes identical to SQL Server 2005. ACCESS Microsoft Access, now known as Microsoft Office Access is actually the Microsoft Jet Relational Database Management System with a Graphical User Interface. Microsoft article Q300216 “How to keep a Jet 4.0 database in top working condition in Access 2000” has a sub – section “Additional Best Practises for Network Environments”. To quote verbatim: “Microsoft Jet is a file sharing database system. A file sharing database is one in which all of the processing of the files takes place at the client. When a file – sharing database such as Microsoft Jet, is used in a multiuser environment, multiple client processes are using file read, write and locking operations on the same shared file across a network. If, for any reason, a process cannot be completed, the file can be left in an incomplete or corrupted state. Two examples of when a process may not be completed is when a client is terminated unexpectedly or when a network connection to a server is dropped. Microsoft Jet is not intended to be used with high – stress, high concurrency, 24x7 server applications, such as Web, commerce, transactional and messaging servers. For these type of applications, the best solution is to switch to a true client/server – based database system such as Microsoft Data Engine (MSDE) or Microsoft Sequel Server. When you use Microsoft Jet in high-stress applications such as Microsoft Internet Information Server (IIS) customers have reported database corruption, stability issues such as IIS crashing or locking up, and also a sudden and persistent failure of the driver to connect to a valid database that requires re – starting the IIS service.” WHICH DO YOU NEED ? With SQL Server the users do not interact with the raw data tables themselves but with an intelligent data manager which in turn writes to a transaction log. When the user signals to the Server that he/she has finished the intelligent data manager applies the data changes to the database itself. In the instance of a network problem or problem with the client machine the data manager is aware that the transaction has not been completed and does not apply the changes to the database, the database thereby retaining it’s integrity. In the instance of a server failure this transaction log can be re – applied allowing the database to be restored to the situation it was in before the failure. In the right environment this is scarcely a consideration – we have customers with 24x7 SQL Server databases running at Rackspace where no problems have been encountered since the systems went into production. With Access the story is different. Each user interacts directly with the raw data tables. If a user’s machine experiences problems these will usually have the effect of corrupting the entire underlying Jet Database. Network problems will have a similar effect. With increases in user populations and data volumes come increases in problems. To the extent that we would not develop an Access database for a customer who was planning to have more than three concurrent users for the foreseeable future. We would be delighted to review your database requirements and make a recommendation with no obligation. |
| Conversations | Calling and trade contacts with customers. |
| Conversations List | Calling and trade contacts with customers. |
| Database Descriptions | Links to web |
