عنوان

Access 2019 Bible /

شابک

1119514738

شابک

1119514746

شابک

1119549434

شابک

9781119514732

شابک

9781119514749

شابک

9781119549437

شابک اشتباه

1119514754

شابک اشتباه

9781119514756

عنوان اصلي

Access 2019 Bible /

نام عام مواد

[Book]

نام نخستين پديدآور

Michael Alexander, Dick Kusleika.

محل نشرو پخش و غیره

Indianapolis, IN :

نام ناشر، پخش کننده و غيره

Wiley,

تاریخ نشرو بخش و غیره

[2019]

نام خاص و کميت اثر

1 online resource

متن يادداشت

Includes index.

متن يادداشت

Cover; Title Page; Copyright; About the Authors; About the Technical Editor; Credits; Acknowledgments; Contents; Introduction; Is This Book for You?; Conventions Used in This Book; How This Book Is Organized; How to Use This Book; What's on the Website; Part I: Access Building Blocks; Chapter 1: An Introduction to Database Development; The Database Terminology of Access; Databases; Tables; Records and fields; Values; Relational Databases; Access Database Objects; Tables; Queries; Data-entry and display forms; Reports; Macros and VBA; Planning for database objects; A Five-Step Design Method.

متن يادداشت

Data Normalization and DenormalizationFirst normal form; Second normal form; Identifying entities; Less obvious entities; Breaking the rules; Third normal form; Denormalization; Table Relationships; Connecting the data; One-to-one; One-to-many; Many-to-many; Integrity Rules; No primary key can contain a null value; All foreign key values must be matched by corresponding primary keys; Keys; Deciding on a primary key; Looking at the benefits of a primary key; Designating a primary key; Single-field versus composite primary keys; Natural versus surrogate primary keys; Creating primary keys.

متن يادداشت

Primary KeyInsert Rows; Delete Rows; Property Sheet; Indexes; Working with fields; Naming a field; Specifying a data type; Entering a field description; Specifying data validation rules; Creating tblCustomers; Using AutoNumber fields; Completing tblCustomers; Changing a Table Design; Inserting a new field; Deleting a field; Changing a field location; Changing a field name; Changing a field size; Handling data conversion issues; Assigning field properties; Common properties; Format; Input Mask; Caption; Validation Rule and Validation Text; Required; AllowZeroLength; Indexed.

متن يادداشت

Step 1: The overall design-from concept to realityStep 2: Report design; Step 3: Data design; Step 4: Table design; Step 5: Form design; Chapter 2: Getting Started with Access; The Access Welcome Screen; How to Create a Blank Database; The Access 2019 Interface; The Navigation pane; Custom; Object Type; Tables and Related Views; Created Date; Modified Date; The Ribbon; The Quick Access toolbar; Part II: Understanding Access Tables; Chapter 3: Creating Access Tables; Table Types; Object tables; Transaction tables; Join tables; Creating a New Table; Designing tables; Using the Design tab.

متن يادداشت

Understanding tblCustomers Field PropertiesSetting the Primary Key; Choosing a primary key; Creating the primary key; Creating composite primary keys; Indexing Access Tables; The importance of indexes; Multiple-field indexes; When to index tables; Printing a Table Design; Saving the Completed Table; Manipulating Tables; Renaming tables; Deleting tables; Copying tables in a database; Copying a table to another database; Adding Records to a Database Table; Understanding Attachment Fields; Chapter 4: Understanding Table Relationships; Building Bulletproof Databases.

بدون عنوان

0

بدون عنوان

8

بدون عنوان

8

بدون عنوان

8

بدون عنوان

8

متن يادداشت

Master database creation and management Access 2019 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2019 has to offer. Whether you're new to Access or getting started with Access 2019, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations. Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it. Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions-but databases can be complex, and difficult to navigate. This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application.-Understand database objects and design systems objects -Build forms, create tables, manipulate datasheets, and add data validation -Use Visual Basic automation and XML Data Access Page design -Exchange data with other Office applications, including Word, Excel, and more From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2019 and build the database you need.

منبع سفارش / آدرس اشتراک

OverDrive, Inc.

شماره انبار

94867909-E990-466A-B6CE-587267C727D2

شماره استاندارد بين المللي کتاب و موسيقي

9781119514756

عنوان روي جلد

Microsoft Access 2019 Bible

موضوع مستند نشده

Microsoft Access

موضوع مستند نشده

Microsoft Access.

موضوع مستند نشده

LANGUAGE ARTS & DISCIPLINES-- Library & Information Science-- General.

موضوع مستند نشده

LAN-- 025000

شماره

ويراست

شماره رده

مستند نام اشخاص تاييد نشده

Alexander, Michael,1972-

مستند نام اشخاص تاييد نشده

Kusleika, Dick

تاريخ عمليات

20200822154435.0

قواعد فهرست نويسي ( بخش توصيفي )

pn

نام الکترونيکي

نوع ماده

[Book]

تكميل شده

Y