國立虎尾科技大學 |

Introducing Microsoft Access Using Macro Programming Techniques = An Introduction to Desktop Database Development by Example /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Introducing Microsoft Access Using Macro Programming Techniques/ by Flavio Morgado.
Reminder of title:	An Introduction to Desktop Database Development by Example /
Author:	Morgado, Flavio.
Description:	XX, 597 p. 433 illus.online resource. :
Contained By:	Springer Nature eBook
Subject:	Microsoft software. -
Online resource:	https://doi.org/10.1007/978-1-4842-6555-0
ISBN:	9781484265550

Introducing Microsoft Access Using Macro Programming Techniques = An Introduction to Desktop Database Development by Example /
Morgado, Flavio.

Introducing Microsoft Access Using Macro Programming TechniquesAn Introduction to Desktop Database Development by Example /[electronic resource] :by Flavio Morgado. - 1st ed. 2021. - XX, 597 p. 433 illus.online resource.

Chapter 1: A Primer on Databases -- Chapter 2: Creating and Using Database Tables -- Chapter 3: Creating Queries -- Chapter 4: Using Forms -- Chapter 5: Using Macros -- Chapter 6: Using Reports.

Learn Microsoft Access by building a powerful database application from start to finish. Microsoft Access ships with every version of Office, from Office 2019 to Office 365 Home and Personal editions. Most people understand the value of having a reliable contact database, but few realize that Access can be an incredibly valuable data tool and an excellent gateway for learning database development. Introducing Microsoft Access Using Macro Programming Techniques approaches database development from a practical and experiential standpoint. You will learn important data concepts as you journey through each step of creating a database using Access. The example you will build takes advantage of a massive amount of data from an external source of nutritional data (USDA). You will leverage this freely available repository of information in multiple ways, putting Access to the test in creating powerful business solutions that you can then apply to your own data sets. The tables and records in this database will be used to demonstrate key relational principles in Access, including how to use the relationship window to understand the relationships between tables and how to create different objects such as queries, forms, reports, and macros. Using this approach, you will learn how desktop database development can be a powerful solution to meet your business needs. What You Will Learn Discover the relational database and how it is different from other databases Create database tables and establish relationships between them to create a solid relational database system Understand the concept and importance of referential integrity (RI) in data and databases Use different types of Access queries to extract the information you need from the database Show database information in individual, customized windows using Access Forms Present insightful information about the database using Access Reports Automate your database solutions with macros This book is for anyone who wants to learn how to build a database using Microsoft Access to create customized solutions. It is also useful for those working in IT managing large contact data sets (healthcare, retail, etc.) who need to learn the basics in order to create a professional database solution. Readers should have access to some version of Microsoft Access in order to perform the exercises in this book. Flavio Morgado is a food engineer with an MSc. degree in food science and technology, a VBA professional developer, and a professor of epidemiology, statistics, and medical informatics at UNIFESO, a health sciences university in Rio de Janeiro, Brazil. Flavio has written more than 30 books, including Programming Excel with VBA (Apress) and Microsoft Word Secrets (Apress), and has translated many technical books. He also loves animals and the exquisite nature of the surrounding rainforest, and when he is not teaching, writing, or developing, he can be found running or riding his mountain bike through the Teresopolis Mountains, followed by his eight dogs, or spending time on the stunningly beautiful beaches of Cabo Frio in Rio de Janeiro.

ISBN: 9781484265550

Standard No.: 10.1007/978-1-4842-6555-0doiSubjects--Topical Terms:

1253736
Microsoft software.

LC Class. No.: QA76.76.M52

Dewey Class. No.: 004.165

Introducing Microsoft Access Using Macro Programming Techniques = An Introduction to Desktop Database Development by Example /
LDR:04680nam a22003855i 4500 001 1051199
003 DE-He213
005 20210621173914.0
007 cr nn 008mamaa
008 220103s2021 xxu| s |||| 0|eng d
020 $a 9781484265550 $9 978-1-4842-6555-0
024 7 $a 10.1007/978-1-4842-6555-0 $2 doi
035 $a 978-1-4842-6555-0
050 4 $a QA76.76.M52
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 004.165 $2 23
100 1 $a Morgado, Flavio. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1115963
245 1 0 $a Introducing Microsoft Access Using Macro Programming Techniques $h [electronic resource] : $b An Introduction to Desktop Database Development by Example / $c by Flavio Morgado.
250 $a 1st ed. 2021.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2021.
300 $a XX, 597 p. 433 illus. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
505 0 $a Chapter 1: A Primer on Databases -- Chapter 2: Creating and Using Database Tables -- Chapter 3: Creating Queries -- Chapter 4: Using Forms -- Chapter 5: Using Macros -- Chapter 6: Using Reports.
520 $a Learn Microsoft Access by building a powerful database application from start to finish. Microsoft Access ships with every version of Office, from Office 2019 to Office 365 Home and Personal editions. Most people understand the value of having a reliable contact database, but few realize that Access can be an incredibly valuable data tool and an excellent gateway for learning database development. Introducing Microsoft Access Using Macro Programming Techniques approaches database development from a practical and experiential standpoint. You will learn important data concepts as you journey through each step of creating a database using Access. The example you will build takes advantage of a massive amount of data from an external source of nutritional data (USDA). You will leverage this freely available repository of information in multiple ways, putting Access to the test in creating powerful business solutions that you can then apply to your own data sets. The tables and records in this database will be used to demonstrate key relational principles in Access, including how to use the relationship window to understand the relationships between tables and how to create different objects such as queries, forms, reports, and macros. Using this approach, you will learn how desktop database development can be a powerful solution to meet your business needs. What You Will Learn Discover the relational database and how it is different from other databases Create database tables and establish relationships between them to create a solid relational database system Understand the concept and importance of referential integrity (RI) in data and databases Use different types of Access queries to extract the information you need from the database Show database information in individual, customized windows using Access Forms Present insightful information about the database using Access Reports Automate your database solutions with macros This book is for anyone who wants to learn how to build a database using Microsoft Access to create customized solutions. It is also useful for those working in IT managing large contact data sets (healthcare, retail, etc.) who need to learn the basics in order to create a professional database solution. Readers should have access to some version of Microsoft Access in order to perform the exercises in this book. Flavio Morgado is a food engineer with an MSc. degree in food science and technology, a VBA professional developer, and a professor of epidemiology, statistics, and medical informatics at UNIFESO, a health sciences university in Rio de Janeiro, Brazil. Flavio has written more than 30 books, including Programming Excel with VBA (Apress) and Microsoft Word Secrets (Apress), and has translated many technical books. He also loves animals and the exquisite nature of the surrounding rainforest, and when he is not teaching, writing, or developing, he can be found running or riding his mountain bike through the Teresopolis Mountains, followed by his eight dogs, or spending time on the stunningly beautiful beaches of Cabo Frio in Rio de Janeiro.
650 0 $a Microsoft software. $3 1253736
650 0 $a Microsoft .NET Framework. $3 565417
650 0 $a Database management. $3 557799
650 0 $a Computer software. $3 528062
650 1 4 $a Microsoft and .NET. $3 1114109
650 2 4 $a Database Management. $3 669820
650 2 4 $a Professional Computing. $3 1115983
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484265543
776 0 8 $i Printed edition: $z 9781484265567
856 4 0 $u https://doi.org/10.1007/978-1-4842-6555-0
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)