Cantitate/Preț
Produs

SQL FOR MS ACCESS 2/E

Autor Cecelia L. Allison, Neal A. Berkowitz
en Limba Engleză Paperback – iun 2008
This book unlocks the power of Structured Query Language (SQL) in Microsoft Access. It guides the reader through step-by-step examples that use SQL script in Microsoft Access to create tables, add records to tables, and retrieve and manage records using simple to advanced data manipulation techniques including combined queries, joined queries, nested queries, views, and temporary tables. The reader also discovers how SQL script can be implemented within VBA and ASP code. Beginners learn about early forms of data storage, the structure of a relational database, and how to plan the design of a database. The reader will learn how to use a database design technique called normalisation, and will also encounter the ERD data model, which is used to demonstrate how to organise and document data that will be stored in the database. Examples of the one-to-one relationship, many-to-one relationship, and the many-to-many relationship are also discussed. Intermediate Microsoft Access users will learn to use the SQL View interface within Microsoft Access to create simple to advanced SQL queries. They will learn to use SQL script to create a table from the ground up that includes columns with data types, constraints, field sizes, indexes, and default values. They will also learn to use SQL script to insert records into a table and to create customized queries that retrieve records from a single table or multiple tables simultaneously. Other topics include using SQL script to create calculated fields, manipulate strings, compute dates, create temporary tables, create views, and create parameter queries that prompt the user to enter data. The advanced reader will discover how SQL script can be integrated into VBA and ASP code.
Citește tot Restrânge

Preț: 19728 lei

Preț vechi: 24660 lei
-20%

Puncte Express: 296

Preț estimativ în valută:
3780 4094$ 3241£

Carte tipărită la comandă

Livrare economică 09-23 mai

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9781598220605
ISBN-10: 1598220608
Pagini: 374
Ilustrații: b/w illus
Dimensiuni: 154 x 229 x 21 mm
Greutate: 0.52 kg
Ediția:0002
Editura: WORDWARE PUB CO