Master Networked visual basic SQL Server Accounting Application Programming!!

Develop An Accounting Package Using Visual Basic

ISBN: 81-901331-0-1
Price: $24.90
Weight: 2 Pounds
Pages: 453

Learn

• Client / Server Application Development with Visual Basic ( visual basic ) and SQL Server 2000.
• how to install a Network Operating system.
• SQL Server 2000 Installation on a Client / Server Network.
• how to install and setup Active Directory Services on a Client / Server Network.
• the Concept of Domain Controller in a Windows Network.
• how to Setup a Domain Model and Client / Server Model on a Network.
• how to Secure Databases in Sql Server.
• earn how to Setup and use Windows Authentication in Sql Server.
• how to Setup and use SQL Server Authentication.
• how to Create Logins in Sql Server.
• how to Define Database Roles in Sql Server.
• how to Define Server Roles in Sql Server.
• how to use the Enterprise Manager of Sql Server.
• how to use the Query Analyzer of Sql Server.
• how to Create a Database.
• how to Create a Table using SQL Script.
• how to Create Primary Keys and Foreign Keys.
• how to Create Indexes, Clustered and Non Clustered Indexes.
• how to Establish Connection with SQL Server over a Network.
• how to Create a Connection Object.
• how to Create a Command Object, its Properties and Methods.
• how to Create a Recordset Object in a Visual Basic ( visual basic ) application.
• how to Access SQL Server Database using ADO.
• how to Retreive Data From SQL Server Over a client server Network.
• how to Create Multiple Command Objects using a Single Connection.
• how to Specify a OLEDB data provider in Visual Basic ( visual basic ) for a client server application.
• how to Pass Connection Information to SQL Server over a network using Visual Basic (VB).
• how to Insert a New Record in SQL server using Visual Basic ( VB ).
• how to Update and Delete a record using the Execute Method.
• how to Execute a Stored Procedure using a Command Object.
• how to Create a Input Parameter.
• how to Create a Output Parameter.
• how to Create Dynamic Recordsets, Keyset Recordsets, Static Recordsets, Forward Only Recordsets.
• how to Create Client Side Only Recordsets.
• how to Assign a lock for Client Side Recordsets.
• how to Navigate and Bind Controls to a Recordset.
• how to Retrieve Fields of Recordsets.
• how to Manually Populate Controls.
• how to Add a new Record, Modify and Delete a Record.
• how to setup a DNS server.
• how to setup a DHCP Server.
• how to Assign IP Address in a Client Server network.
• how to setup a Network Topology.
• how to Create a Project.
• how to Create a Menu.
• about SQL Server Security.
• about Standard Security Mode.
• how to setup a Integrated Security Mode.
• how to Create Constants.
• how Relational Databases are used in a Client Server Accounting Application.
• how to implement relationships using Key Fields.
• Client/Server Architecture.
• how to Create a Class for developing a database application.
• how Object Oriented Programming is used in a visual basic/SQL Environment.
• how to use a Datagrid in a visual basic, Sql server accounting application.
• how to Create and Use Standard Modules in a database application.
• how to Design the database using SQL Server.
• the relevance of Chart of Accounts in an Accounting Application.
• how to Program the Form_Load() event procedure.
• how to Program the Form_Activate() event procedure.
• how to Program the Cancelbutton.
• how to setup and Validate the data entered in the text box control.
• how to Create and Add a Class using Visual basic ( VB ) for a client server application.
• how to write Property Procedures.
• how to write Get Property Procedure.
• how to write Let Property Procedure.
• how to use the Class_Initialize Event.
• how to Commit Transaction in a networked visual basic Sql Server Accounting Application.
• how to Rollback Transaction.