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


Introducing Microsoft Access Using Macro Programming Techniques:An Introduction to Desktop Database Development by:Example
by:Flavio Morgado
Publisher Finelybook 出版社:Apress; 1st ed. edition (December 27, 2020)
Language 语言:English
pages 页数:620 pages
ISBN-10 书号:1484265548
ISBN-13 书号:9781484265543

Book Description
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

下载地址:应版权方要求,该资源内容链接已移除!

你可以 登录 后获取帮助.

赞(0) 觉得文章有用就打赏一下
未经允许不得转载:finelybook » Introducing Microsoft Access Using Macro Programming Techniques:An Introduction to Desktop Database Development by:Example

评论 抢沙发

评论前必须登录!

 

觉得文章有用就打赏一下

支付宝扫一扫打赏

微信扫一扫打赏