Muutke küpsiste eelistusi

E-raamat: Access 2019 Bible

4.05/5 (29 hinnangut Goodreads-ist)
(McKinney, TX),
  • Formaat: PDF+DRM
  • Sari: Bible
  • Ilmumisaeg: 20-Sep-2018
  • Kirjastus: John Wiley & Sons Inc
  • Keel: eng
  • ISBN-13: 9781119514732
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 43,88 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
  • Raamatukogudele
Access 2019 BibleSuurem pilt
  • Formaat: PDF+DRM
  • Sari: Bible
  • Ilmumisaeg: 20-Sep-2018
  • Kirjastus: John Wiley & Sons Inc
  • Keel: eng
  • ISBN-13: 9781119514732
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

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.

Introduction xxxix
Part I: Access Building Blocks 1(28)
Chapter 1 An Introduction to Database Development
3(14)
The Database Terminology of Access
3(3)
Databases
3(2)
Tables
5(1)
Records and fields
5(1)
Values
6(1)
Relational Databases
6(1)
Access Database Objects
7(2)
Tables
7(1)
Queries
8(1)
Data-entry and display forms
8(1)
Reports
8(1)
Macros and VBA
9(1)
Planning for database objects
9(1)
A Five-Step Design Method
9(8)
Step 1: The overall design-from concept to reality
10(1)
Step 2: Report design
11(1)
Step 3: Data design
11(2)
Step 4: Table design
13(3)
Step 5: Form design
16(1)
Chapter 2 Getting Started with Access
17(12)
The Access Welcome Screen
17(1)
How to Create a Blank Database
18(2)
The Access 2019 Interface
20(11)
The Navigation pane
20(4)
Custom
21(1)
Object Type
22(1)
Tables and Related Views
23(1)
Created Date
23(1)
Modified Date
23(1)
The Ribbon
24(1)
The Quick Access toolbar
25(4)
Part II: Understanding Access Tables 29(208)
Chapter 3 Creating Access Tables
31(56)
Table Types
31(1)
Object tables
31(1)
Transaction tables
32(1)
Join tables
32(1)
Creating a New Table
32(17)
Designing tables
34(5)
Using the Design tab
39(2)
Primary Key
39(1)
Insert Rows
40(1)
Delete Rows
40(1)
Property Sheet
40(1)
Indexes
41(1)
Working with fields
41(8)
Naming a field
41(1)
Specifying a data type
42(7)
Entering a field description
49(1)
Specifying data validation rules
49(1)
Creating tblCustomers
49(1)
Using AutoNumber fields
50(1)
Completing tblCustomers
50(1)
Changing a Table Design
50(18)
Inserting a new field
51(1)
Deleting a field
51(1)
Changing a field location
51(1)
Changing a field name
51(1)
Changing a field size
52(1)
Handling data conversion issues
52(1)
Assigning field properties
53(18)
Common properties
54(1)
Format
55(5)
Input Mask
60(3)
Caption
63(1)
Validation Rule and Validation Text
63(2)
Required
65(1)
AllowZeroLength
65(1)
Indexed
66(2)
Understanding tblCustomers Field Properties
68(3)
Setting the Primary Key
71(2)
Choosing a primary key
71(1)
Creating the primary key
72(1)
Creating composite primary keys
72(1)
Indexing Access Tables
73(6)
The importance of indexes
74(2)
Multiple-field indexes
76(2)
When to index tables
78(1)
Printing a Table Design
79(2)
Saving the Completed Table
81(1)
Manipulating Tables
81(3)
Renaming tables
81(1)
Deleting tables
82(1)
Copying tables in a database
82(1)
Copying a table to another database
83(1)
Adding Records to a Database Table
84(1)
Understanding Attachment Fields
84(3)
Chapter 4 Understanding Table Relationships
87(42)
Building Bulletproof Databases
88(2)
Data Normalization and Denormalization
90(12)
First normal form
90(4)
Second normal form
94(5)
Identifying entities
94(2)
Less obvious entities
96(2)
Breaking the rules
98(1)
Third normal form
99(2)
Denormalization
101(1)
Table Relationships
102(8)
Connecting the data
103(2)
One-to-one
105(2)
One-to-many
107(1)
Many-to-many
108(2)
Integrity Rules
110(3)
No primary key can contain a null value
112(1)
All foreign key values must be matched by corresponding primary keys
113(1)
Keys
113(16)
Deciding on a primary key
114(2)
Looking at the benefits of a primary key
116(1)
Designating a primary key
117(2)
Single-field versus composite primary keys
117(1)
Natural versus surrogate primary keys
118(1)
Creating primary keys
119(1)
Creating relationships and enforcing referential integrity
119(6)
Specifying the join type between tables
121(2)
Enforcing referential integrity
123(2)
Viewing all relationships
125(1)
Deleting relationships
126(1)
Following application-specific integrity rules
126(3)
Chapter 5 Working with Access Tables
129(40)
Understanding Datasheets
130(1)
Looking at the Datasheet Window
131(4)
Moving within a datasheet
132(1)
Using the Navigation buttons
133(1)
Examining the Datasheet Ribbon
133(2)
Views
134(1)
Clipboard
134(1)
Sort & Filter
134(1)
Records
134(1)
Find
134(1)
Window
134(1)
Text Formatting
135(1)
Opening a Datasheet
135(1)
Entering New Data
135(7)
Saving the record
138(1)
Understanding automatic data-type validation
138(2)
Knowing how properties affect data entry
140(2)
Standard text data entry
140(1)
Date/Time data entry
140(1)
Number/Currency data entry with data validation
141(1)
OLE object data entry
141(1)
Long Text field data entry
141(1)
Navigating Records in a Datasheet
142(4)
Moving between records
143(1)
Finding a specific value
143(3)
Changing Values in a Datasheet
146(2)
Manually replacing an existing value
146(1)
Changing an existing value
146(2)
Using the Undo Feature
148(1)
Copying and Pasting Values
148(1)
Replacing Values
149(1)
Adding New Records
150(1)
Deleting Records
150(2)
Displaying Records
152(8)
Changing the field order
152(1)
Changing the field display width
153(1)
Changing the record display height
154(1)
Changing display fonts
155(1)
Displaying cell gridlines and alternate row colors
156(2)
Aligning data in columns
158(1)
Hiding and unhiding columns
159(1)
Freezing columns
159(1)
Saving the changed layout
160(1)
Saving a record
160(1)
Sorting and Filtering Records in a Datasheet
160(5)
Sorting records
161(1)
Filtering a selection
161(3)
Filtering by form
164(1)
Aggregating Data
165(1)
Printing Records
166(1)
Previewing Records
167(2)
Chapter 6 Importing and Exporting Data
169(40)
How Access Works with External Data
169(4)
Types of external data
169(1)
Ways of working with external data
170(5)
When to link to external data
171(1)
When to import external data
172(1)
When to export data
173(1)
Options for Importing and Exporting
173(2)
Importing External Data
175(27)
Importing from another Access database
175(3)
Importing from an Excel spreadsheet
178(7)
Importing a SharePoint list
185(1)
Importing data from text files
185(7)
Delimited text files
185(3)
Fixed-width text files
188(4)
Importing and exporting XML documents
192(5)
Importing and exporting HTML documents
197(1)
Importing Access objects other than tables
198(2)
Importing an Outlook folder
200(2)
Exporting to External Formats
202(7)
Exporting objects to other Access databases
202(1)
Exporting through ODBC drivers
203(2)
Exporting to Word
205(1)
Merging data into Word
205(1)
Publishing to PDF or XPS
206(3)
Chapter 7 Linking to External Data
209(28)
Linking External Data
210(15)
Identifying linked tables
211(2)
Limitations of linked data
213(1)
Linking to other Access database tables
214(2)
Linking to ODBC data sources
216(1)
Linking to non-database data
217(8)
Linking to Excel
218(2)
Linking to HTML files
220(2)
Linking to text files
222(3)
Working with Linked Tables
225(4)
Setting view properties
225(1)
Setting relationships
226(1)
Optimizing linked tables
226(1)
Deleting a linked table reference
227(1)
Viewing or changing information for linked tables
227(1)
Refreshing linked tables
228(1)
Splitting a Database
229(10)
The benefits of splitting a database
229(3)
Knowing where to put which objects
232(1)
Using the Database Splitter add-in
232(5)
Part III: Working with Access Queries 237(116)
Chapter 8 Selecting Data with Queries
239(30)
Introducing Queries
240(1)
What queries can do
240(1)
What queries return
241(1)
Creating a Query
241(6)
Adding fields to your queries
244(3)
Adding a single field
244(1)
Adding multiple fields
245(2)
Running your query
247(1)
Working with Query Fields
247(5)
Selecting a field in the QBD grid
247(1)
Changing field order
248(1)
Resizing columns in the QBD grid
249(1)
Removing a field
249(1)
Inserting a field
249(1)
Hiding a field
250(1)
Changing the sort order of a field
250(2)
Adding Criteria to Your Queries
252(3)
Understanding selection criteria
252(1)
Entering simple string criteria
252(2)
Entering other simple criteria
254(1)
Printing a Query's Recordset
255(1)
Saving a Query
256(1)
Creating Multi-table Queries
256(5)
Viewing table names
258(1)
Adding multiple fields
258(1)
Recognizing the limitations of multi-table queries
259(1)
Overcoming query limitations
260(1)
Updating a unique index (primary key)
260(1)
Replacing existing data in a query with a one-to-many relationship
260(1)
Updating fields in queries
260(1)
Working with the Table Pane
261(1)
Looking at the join line
261(1)
Moving a table
261(1)
Removing a table
262(1)
Adding more tables
262(1)
Creating and Working with Query Joins
262(7)
Understanding joins
262(3)
Leveraging ad hoc table joins
265(1)
Specifying the type of join
266(1)
Deleting joins
267(2)
Chapter 9 Using Operators and Expressions in Access
269(42)
Introducing Operators
269(14)
Types of operators
270(12)
Mathematical operators
270(3)
Comparison operators
273(2)
String operators
275(3)
Boolean (logical) operators
278(2)
Miscellaneous operators
280(2)
Operator precedence
282(1)
The mathematical precedence
282(1)
The comparison precedence
283(1)
The Boolean precedence
283(1)
Using Operators and Expressions in Queries
283(6)
Using query comparison operators
284(1)
Understanding complex criteria
285(3)
Using functions in select queries
288(1)
Referencing fields in select queries
289(1)
Entering Single-Value Field Criteria
289(8)
Entering character (Text or Memo) criteria
289(2)
The Like operator and wildcards
291(3)
Specifying non-matching values
294(1)
Entering numeric criteria
295(1)
Entering true or false criteria
296(1)
Entering OLE object criteria
297(1)
Using Multiple Criteria in a Query
297(7)
Understanding an Or operation
297(1)
Specifying multiple values with the Or operator
298(1)
Using the Or cell of the QBD pane
299(1)
Using a list of values with the In operator
299(1)
Using And to specify a range
300(2)
Using the Between...And operator
302(1)
Searching for null data
302(2)
Entering Criteria in Multiple Fields
304(7)
Using And and Or across fields in a query
304(1)
Specifying Or criteria across fields of a query
305(2)
Using And and Or together in different fields
307(1)
A complex query on different lines
308(3)
Chapter 10 Going Beyond Select Queries
311(42)
Aggregate Queries
311(9)
Creating an aggregate query
311(4)
About aggregate functions
315(5)
Group By
315(1)
Sum, Avg, Count, StDev, Var
316(1)
Min, Max, First, Last
317(1)
Expression, Where
318(2)
Action Queries
320(16)
Make-table queries
321(2)
Delete queries
323(4)
Append queries
327(5)
Update queries
332(4)
Crosstab Queries
336(12)
Creating a crosstab query using the Crosstab Query Wizard
336(6)
Creating a crosstab query manually
342(6)
Using the query design grid to create your crosstab query
343(3)
Customizing your crosstab queries
346(2)
Optimizing Query Performance
348(7)
Normalizing your database design
349(1)
Using indexes on appropriate fields
349(1)
Optimizing by improving query design
350(1)
Compacting and repairing your database regularly
351(2)
Part IV: Analyzing Data in Microsoft Access 353(134)
Chapter 11 Transforming Data in Access
355(24)
Finding and Removing Duplicate Records
355(8)
Defining duplicate records
356(1)
Finding duplicate records
357(2)
Removing duplicate records
359(4)
Common Transformation Tasks
363(16)
Filling in blank fields
363(1)
Concatenating
364(3)
Concatenating fields
364(2)
Augmenting field values with your own text
366(1)
Changing case
367(1)
Removing leading and trailing spaces from a string
368(2)
Finding and replacing specific text
370(1)
Adding your own text in key positions within a string
370(4)
Parsing strings using character markers
374(5)
Query 1
376(1)
Query 2
376(3)
Chapter 12 Working with Calculations and Dates
379(26)
Using Calculations in Your Analyses
379(13)
Common calculation scenarios
380(4)
Using constants in calculations
380(1)
Using fields in calculations
381(1)
Using the results of aggregation in calculations
381(1)
Using the results of one calculation as an expression in another
381(1)
Using a calculation as an argument in a function
382(2)
Constructing calculations with the Expression Builder
384(4)
Common calculation errors
388(4)
Understanding the order of operator precedence
388(1)
Watching out for null values
389(2)
Watching the syntax in your expressions
391(1)
Using Dates in Your Analyses
392(13)
Simple date calculations
392(1)
Advanced analysis using functions
392(13)
The Date function
393(4)
The Year, Month, Day, and Weekday functions
397(2)
The DateAdd function
399(1)
Grouping dates into quarters
400(1)
The DateSerial function
401(4)
Chapter 13 Performing Conditional Analyses
405(20)
Using Parameter Queries
405(9)
How parameter queries work
407(1)
Ground rules of parameter queries
407(1)
Working with parameter queries
408(6)
Working with multiple parameter conditions
408(1)
Combining parameters with operators
408(2)
Combining parameters with wildcards
410(1)
Using parameters as calculation variables
411(1)
Using parameters as function arguments
411(3)
Using Conditional Functions
414(11)
The IIf function
414(6)
Using IIf to avoid mathematical errors
415(1)
Saving time with IIf
416(2)
Nesting IIf functions for multiple conditions
418(1)
Using IIf functions to create crosstab analyses
419(1)
The Switch function
420(1)
Comparing the IIf and Switch functions
421(4)
Chapter 14 The Fundamentals of Using SQL
425(20)
Understanding Basic SQL
425(5)
The SELECT statement
426(2)
Selecting specific columns
427(1)
Selecting all columns
427(1)
The WHERE clause
428(1)
Making sense of joins
428(2)
Inner joins
428(1)
Outer joins
429(1)
Getting Fancy with Advanced SQL Statements
430(8)
Expanding your search with the Like operator
430(2)
Selecting unique values and rows without grouping
432(1)
Grouping and aggregating with the GROUP BY clause
432(1)
Setting the sort order with the ORDER BY clause
433(1)
Creating aliases with the AS clause
433(1)
Creating a column alias
433(1)
Creating a table alias
433(1)
Showing only the SELECT TOP or SELECT TOP PERCENT
433(3)
Top values queries explained
434(1)
The SELECT TOP statement
435(1)
The SELECT TOP PERCENT statement
436(1)
Performing action queries via SQL statements
436(1)
Make-table queries translated
436(1)
Append queries translated
437(1)
Update queries translated
437(1)
Delete queries translated
437(1)
Creating crosstabs with the TRANSFORM statement
437(1)
Using SQL-Specific Queries
438(7)
Merging data sets with the UNION operator
438(2)
Creating a table with the CREATE TABLE statement
440(1)
Manipulating columns with the ALTER TABLE statement
440(2)
Adding a column with the ADD clause
441(1)
Altering a column with the ALTER COLUMN clause
441(1)
Deleting a column with the DROP COLUMN clause
441(1)
Dynamically adding primary keys with the ADD CONSTRAINT clause
442(1)
Creating pass-through queries
442(3)
Chapter 15 Subqueries and Domain Aggregate Functions
445(24)
Enhancing Your Analyses with Subqueries
446(13)
Why use subqueries?
447(1)
Subquery ground rules
447(1)
Creating subqueries without typing SQL statements
447(4)
Using IN and NOT IN with subqueries
451(1)
Using subqueries with comparison operators
451(1)
Using subqueries as expressions
452(1)
Using correlated subqueries
453(3)
Uncorrelated subqueries
453(1)
Correlated subqueries
454(1)
Using a correlated subquery as an expression
455(1)
Using subqueries within action queries
456(3)
A subquery in a make-table query
456(1)
A subquery in an append query
456(1)
A subquery in an update query
456(1)
A subquery in a delete query
456(3)
Domain Aggregate Functions
459(10)
Understanding the different domain aggregate functions
460(1)
DSum
460(1)
DAvg
460(1)
DCount
460(1)
DLookup
461(1)
DMin and DMax
461(1)
DFirst and DLast
461(1)
DStDev, DStDevP, DVar, and DvarP
461(1)
Examining the syntax of domain aggregate functions
461(2)
Using no criteria
461(1)
Using text criteria
462(1)
Using number criteria
462(1)
Using date criteria
463(1)
Using domain aggregate functions
463(7)
Calculating the percent of total
463(2)
Creating a running count
465(1)
Using a value from the previous record
466(3)
Chapter 16 Running Descriptive Statistics in Access
469(18)
Basic Descriptive Statistics
470(9)
Running descriptive statistics with aggregate queries
470(1)
Determining rank, mode, and median
471(6)
Ranking the records in your data set
471(1)
Getting the mode of a data set
472(3)
Getting the median of a data set
475(2)
Pulling a random sampling from your data set
477(2)
Advanced Descriptive Statistics
479(10)
Calculating percentile ranking
479(2)
Determining the quartile standing of a record
481(2)
Creating a frequency distribution
483(4)
Part V: Working with Access Forms and Reports 487(216)
Chapter 17 Creating Basic Access Forms
489(42)
Working with Form Views
489(1)
Understanding Different Types of Forms
490(13)
Creating a new form
491(5)
Using the Form command
492(1)
Using the Form Wizard
492(4)
Looking at special types of forms
496(6)
Navigation forms
496(2)
Multiple-items forms
498(2)
Split forms
500(1)
Datasheet forms
501(1)
Resizing the form area
502(1)
Saving your form
502(1)
Working with Controls
503(21)
Categorizing controls
504(2)
Adding a control
506(5)
Using the Controls group
507(1)
Using the field list
508(3)
Selecting and deselecting controls
511(2)
Selecting a single control
512(1)
Selecting multiple controls
513(1)
Deselecting controls
513(1)
Manipulating controls
513(11)
Resizing a control
513(2)
Sizing controls automatically
515(1)
Moving a control
515(2)
Aligning controls
517(2)
Modifying the appearance of a control
519(1)
Grouping controls
519(1)
Changing a control's type
520(2)
Copying a control
522(1)
Deleting a control
522(1)
Reattaching a label to a control
522(2)
Introducing Properties
524(7)
Displaying the Property Sheet
524(1)
Getting acquainted with the Property Sheet
525(1)
Changing a control's property setting
526(1)
Naming control labels and their captions
527(4)
Chapter 18 Working with Data on Access Forms
531(32)
Using Form View
532(5)
Looking at the Home tab of the Ribbon
532(4)
The Views group
534(1)
The Clipboard group
534(1)
The Sort & Filter group
535(1)
The Records group
535(1)
The Find group
535(1)
The Window group
535(1)
The Text Formatting group
536(1)
Navigating among fields
536(1)
Moving among records in a form
537(1)
Changing Values in a Form
537(7)
Knowing which controls you can't edit
538(1)
Working with pictures and OLE objects
538(2)
Entering data in the Long Text field
540(1)
Entering data in the Date field
540(2)
Using option groups
542(1)
Using combo boxes and list boxes
542(1)
Switching to Datasheet view
543(1)
Saving a record
544(1)
Printing a Form
544(1)
Working with Form Properties
545(11)
Changing the title bar text with the Caption property
546(1)
Creating a bound form
547(1)
Specifying how to view the form
548(1)
Removing the Record Selector
549(1)
Looking at other form properties
549(7)
Adding a Form Header or Footer
556(1)
Working with Section Properties
556(2)
The Visible property
557(1)
The Height property
557(1)
The Back Color property
557(1)
The Special Effect property
557(1)
The Display When property
558(1)
The printing properties
558(1)
Changing the Layout
558(4)
Changing a control's properties
558(1)
Setting the tab order
559(1)
Modifying the format of text in a control
560(1)
Using the Field List to add controls
561(1)
Converting a Form to a Report
562(1)
Chapter 19 Working with Form Controls
563(36)
Setting Control Properties
563(8)
Customizing default properties
565(1)
Looking at common controls and properties
566(7)
The Text Box control
566(2)
The Command Button control
568(1)
The Combo Box and List Box controls
568(2)
The Check Box and Toggle Button controls
570(1)
The Option Group control
570(1)
The Web Browser control
570(1)
Creating a Calculated Control
571(1)
Working with Subforms
572(1)
Form Design Tips
573(3)
Using the Tab Stop property
573(1)
Tallying check boxes
573(1)
Setting up combo boxes and list boxes
574(2)
Tackling Advanced Forms Techniques
576(7)
Using the Page Number and Date/Time controls
576(1)
Using the Image control
577(1)
Morphing a control
578(1)
Using the Format Painter
579(1)
Offering more end-user help
580(1)
Adding background pictures
580(2)
Limiting the records shown on a form
582(1)
Using the Tab Control
583(3)
Using Dialog Boxes to Collect Information
586(3)
Designing the query
587(1)
Setting up the command buttons
587(1)
Adding a default button
588(1)
Setting a Cancel button
589(1)
Removing the control menu
589(1)
Designing a Form from Scratch
589(10)
Creating the basic form
589(1)
Creating a subform
590(1)
Adding the subform
591(2)
Changing the form's behavior
593(3)
Setting the form properties
593(1)
Looking up values during data entry
594(1)
Saving the record
595(1)
Changing the form's appearance
596(3)
Chapter 20 Presenting Data with Access Reports
599(58)
Introducing Reports
599(5)
Identifying the different types of reports
600(3)
Tabular reports
600(1)
Columnar reports
601(1)
Mailing label reports
602(1)
Distinguishing between reports and forms
603(1)
Creating a Report, from Beginning to End
604(18)
Defining the report layout
604(1)
Assembling the data
604(1)
Creating a report with the Report Wizard
605(15)
Creating a new report
605(1)
Selecting the grouping levels
606(1)
Defining the group data
607(1)
Selecting the sort order
608(1)
Selecting summary options
608(1)
Selecting the layout
609(1)
Opening the report design
610(1)
Adjusting the report's layout
611(1)
Choosing a theme
612(2)
Creating new theme color schemes
614(3)
Using the Print Preview window
617(1)
Publishing in alternate formats
618(1)
Viewing the report in Design view
619(1)
Printing or viewing the report
620(2)
Printing the report
620(1)
Viewing the report
621(1)
Saving the report
622(1)
Banded Report Design Concepts
622(6)
The Report Header section
625(1)
The Page Header section
625(1)
The Group Header section
626(1)
The Detail section
626(1)
The Group Footer section
627(1)
The Page Footer section
627(1)
The Report Footer section
627(1)
Creating a Report from Scratch
628(23)
Creating a new report and binding it to a table
629(2)
Defining the report page size and layout
631(2)
Placing controls on the report
633(1)
Resizing a section
634(2)
Modifying the appearance of text in a control
635(1)
Working with Text Box controls
636(7)
Adding and using Text Box controls
636(1)
Entering an expression in a Text Box control
636(1)
Sizing a Text Box control or Label control
637(1)
Deleting and cutting attached labels from Text Box controls
638(2)
Pasting labels into a report section
640(1)
Moving Label and Text Box controls
640(2)
Modifying the appearance of multiple controls
642(1)
Changing Label and Text Box control properties
643(1)
Growing and shrinking Text Box controls
644(1)
Sorting and grouping data
645(2)
Creating a group header or footer
645(2)
Sorting data within groups
647(3)
Removing a group
648(1)
Hiding a section
648(1)
Sizing a section
648(1)
Moving controls between sections
649(1)
Adding page breaks
650(1)
Improving the Report's Appearance
651(6)
Adjusting the page header
652(1)
Creating an expression in the group header
653(1)
Creating a report header
654(3)
Chapter 21 Advanced Access Report Techniques
657(46)
Grouping and Sorting Data
658(12)
Grouping alphabetically
658(4)
Grouping on date intervals
662(3)
Hiding repeating information
665(3)
Hiding a page header
668(2)
Starting a new page number for each group
670(1)
Formatting Data
670(18)
Creating numbered lists
671(3)
Creating bulleted lists
674(3)
Adding emphasis at run time
677(2)
Avoiding empty reports
679(1)
Inserting vertical lines between columns
680(2)
Adding a blank line every n records
682(2)
Even-odd page printing
684(2)
Using different formats in the same text box
686(1)
Centering the title
687(1)
Aligning control labels
687(1)
Micro-adjusting controls
687(1)
Adding Data
688(2)
Adding more information to a report
688(1)
Adding the user's name to a bound report
688(2)
Adding Even More Flexibility
690(15)
Displaying all reports in a combo box
690(2)
Fast printing from queried data
692(1)
Using snaking columns in a report
692(7)
Exploiting two-pass report processing
699(2)
Assigning unique names to controls
701(2)
Part VI: Microsoft Access Programming Fundamentals 703(196)
Chapter 22 Using Access Macros
705(36)
An Introduction to Macros
705(4)
Creating a macro
706(2)
Assigning a macro to an event
708(1)
Understanding Macro Security
709(4)
Enabling sandbox mode
710(2)
The Trust Center
712(1)
Multi-action Macros
713(3)
Submacros
716(4)
Conditions
720(3)
Opening reports using conditions
720(3)
Multiple actions in conditions
723(1)
Temporary Variables
723(5)
Enhancing a macro you've already created
723(2)
Using temporary variables to simplify macros
725(2)
Using temporary variables in VBA
727(1)
Error Handling and Macro Debugging
728(6)
The OnError action
730(2)
The MacroError object
732(1)
Debugging macros
733(1)
Embedded Macros
734(2)
Macros versus VBA Statements
736(5)
Choosing between macros and VBA
737(1)
Converting existing macros to VBA
737(4)
Chapter 23 Using Access Data Macros
741(18)
Introducing Data Macros
742(1)
Understanding Table Events
742(3)
"Before" events
743(1)
"After" events
744(1)
Using the Macro Builder for Data Macros
745(2)
Understanding the Action Catalog
747(4)
Program flow
748(1)
Data blocks
748(1)
Data actions
749(2)
Creating Your First Data Macro
751(4)
Managing Macro Objects
755(2)
Collapsing and expanding macro items
755(1)
Moving macro items
756(1)
Saving a macro as XML
756(1)
Recognizing the Limitations of Data Macros
757(2)
Chapter 24 Getting Started with Access VBA
759(42)
Introducing Visual Basic for Applications
760(1)
Understanding VBA Terminology
761(1)
Starting with VBA Code Basics
762(1)
Creating VBA Programs
763(14)
Modules and procedures
763(7)
Modules
764(3)
Procedures and functions
767(3)
Working in the code window
770(7)
White space
770(1)
Line continuation
771(1)
Multi-statement lines
772(1)
IntelliSense
773(3)
Compiling procedures
776(1)
Saving a module
777(1)
Understanding VBA Branching Constructs
777(9)
Branching
777(6)
The If keyword
778(3)
The Select Case...End Select statement
781(2)
Looping
783(3)
The Do...Loop statement
783(1)
The For...Next statement
784(2)
Working with Objects and Collections
786(6)
An object primer
786(2)
Properties and methods
788(1)
Properties
788(1)
Methods
788(1)
The With statement
789(1)
The For Each statement
790(2)
Exploring the Visual Basic Editor
792(9)
The Immediate window
792(1)
The Project Explorer
793(1)
The Object Browser
794(1)
VBE options
794(8)
The Editor tab of the Options dialog box
795(2)
The Project Properties dialog box
797(4)
Chapter 25 Mastering VBA Data Types and Procedures
801(42)
Using Variables
802(7)
Naming variables
803(1)
Declaring variables
804(5)
The Dim keyword
807(1)
The Public keyword
807(1)
The Private keyword
808(1)
Working with Data Types
809(20)
Comparing implicit and explicit variables
811(2)
Forcing explicit declaration
813(1)
Using a naming convention with variables
813(3)
Understanding variable scope and lifetime
816(3)
Examining scope
816(1)
Determining a variable's lifetime
817(2)
Deciding on a variable's scope
819(1)
Using constants
819(3)
Declaring constants
820(1)
Using a naming convention with constants
821(1)
Eliminating hard-coded values
821(1)
Working with arrays
822(7)
Fixed arrays
822(3)
Dynamic arrays
825(1)
Array functions
826(3)
Understanding Subs and Functions
829(6)
Understanding where to create a procedure
830(1)
Calling VBA procedures
830(1)
Creating subs
831(4)
Creating Functions
835(5)
Handling parameters
836(1)
Calling a function and passing parameters
836(2)
Creating a function to calculate sales tax
838(2)
Simplifying Code with Named Arguments
840(3)
Chapter 26 Understanding the Access Event Model
843(22)
Programming Events
844(3)
Understanding how events trigger VBA code
844(1)
Creating event procedures
845(2)
Identifying Common Events
847(9)
Form event procedures
848(3)
Essential form events
848(1)
Form mouse and keyboard events
849(1)
Form data events
850(1)
Control event procedures
851(2)
Report event procedures
853(1)
Report section event procedures
854(2)
Paying Attention to Event Sequence
856(9)
Looking at common event sequences
857(1)
Writing simple form and control event procedures
858(9)
Opening a form with an event procedure
859(3)
Running an event procedure when closing a form
862(1)
Using an event procedure to confirm record deletion
862(3)
Chapter 27 Debugging Your Access Applications
865(34)
Organizing VBA Code
866(1)
Testing Your Applications
867(6)
Testing functions
868(3)
Compiling VBA code
871(2)
Traditional Debugging Techniques
873(6)
Using MsgBox
874(4)
Using Debug.Print
878(1)
Using the Access Debugging Tools
879(14)
Running code with the Immediate window
880(1)
Suspending execution with breakpoints
881(6)
Looking at variables with the Locals window
887(2)
Setting watches with the Watches window
889(2)
Using conditional watches
891(1)
Using the Call Stack window
892(1)
Trapping Errors in Your Code
893(8)
Understanding error trapping
893(3)
On Error Resume Next
893(2)
On Error Goto 0
895(1)
On Error GoTo Label
895(1)
The Resume keyword
895(1)
The Err object
896(1)
Including error handling in your procedures
897(2)
Part VII: Advanced Access Programming Techniques 899(156)
Chapter 28 Accessing Data with VBA
901(36)
Working with Data
901(3)
Understanding DAO Objects
904(13)
The DAO DBEngine object
906(1)
The DAO Workspace object
906(1)
The DAO Database object
907(1)
The DAO TableDef object
908(1)
The DAO QueryDef object
909(2)
The DAO Recordset object
911(5)
Navigating recordsets
912(2)
Detecting the recordset end or beginning
914(1)
Counting records
915(1)
The DAO Field objects (recordsets)
916(1)
Understanding ADO Objects
917(6)
The ADO Connection object
918(2)
The ADO Command object
920(2)
The ADO Recordset object
922(1)
Writing VBA Code to Update a Table
923(14)
Updating fields in a record using ADO
924(2)
Updating a calculated control
926(6)
Recalculating a control when updating or adding a record
927(2)
Checking the status of a record deletion
929(2)
Eliminating repetitive code
931(1)
Adding a new record
932(1)
Deleting a record
933(1)
Deleting related records in multiple tables
933(4)
Chapter 29 Advanced Data Access with VBA
937(18)
Adding an Unbound Combo Box to a Form to Find Data
937(8)
Using the FindRecord method
939(2)
Using a bookmark
941(4)
Filtering a Form
945(10)
Filtering with code
945(2)
Filtering with a query
947(8)
Creating a parameter query
947(3)
Creating an interactive filter dialog box
950(2)
Linking the dialog box to another form
952(3)
Chapter 30 Customizing the Ribbon
955(38)
The Ribbon Hierarchy
955(6)
Controls for Access Ribbons
956(4)
SplitButton
957(1)
Menu
957(1)
Gallery
958(1)
Button
958(1)
ToggleButton
959(1)
ComboBox
960(1)
CheckBox
960(1)
Special Ribbon features
960(6)
SuperTips
960(1)
Collapsing the Ribbon
961(1)
Editing the Default Ribbon
961(3)
Working with the Quick Access Toolbar
964(2)
Developing Custom Ribbons
966(3)
The Ribbon creation process
967(1)
Using VBA callbacks
967(2)
Creating a Custom Ribbon
969(8)
Step 1: Design the Ribbon and build the XML
969(3)
Step 2: Write the callback routines
972(1)
Step 3: Create the USysRibbons table
973(1)
Step 4: Add XML to USysRibbons
974(1)
Step 5: Specify the custom Ribbon property
975(2)
The Basic Ribbon XML
977(2)
Adding Ribbon Controls
979(10)
Specifying imageMso
979(1)
The Label control
980(2)
The Button control
982(1)
Separators
983(1)
The CheckBox control
983(2)
The DropDown control
985(2)
The SplitButton Control
987(2)
Attaching Ribbons to Forms and Reports
989(1)
Removing the Ribbon Completely
990(3)
Chapter 31 Preparing Your Access Application for Distribution
993(46)
Defining the Current Database Options
994(9)
Application options
994(5)
Application Title
994(1)
Application Icon
995(1)
Display Form
996(1)
Display Status Bar
996(1)
Document Window Options
996(1)
Use Access Special Keys
996(2)
Compact on Close
998(1)
Remove Personal Information from File Properties on Save
998(1)
Use Windows-Themed Controls on Forms
998(1)
Enable Layout View
998(1)
Enable Design Changes for Tables in Datasheet View
999(1)
Check for Truncated Number Fields
999(1)
Picture Property Storage Format
999(1)
Navigation options
999(2)
The Display Navigation Pane check box
1000(1)
The Navigation Options button
1000(1)
Ribbon and toolbar options
1001(1)
Ribbon Name
1002(1)
Shortcut Menu Bar
1002(1)
Allow Full Menus
1002(1)
Allow Default Shortcut Menus
1002(1)
Name AutoCorrect Options
1002(1)
Developing the Application
1003(6)
Building to a specification
1003(2)
Creating documentation
1005(2)
Documenting the code you write
1005(1)
Documenting the application
1006(1)
Testing the application before distribution
1007(2)
Polishing Your Application
1009(13)
Giving your application a consistent look and feel
1009(1)
Adding common professional components
1010(11)
A splash screen
1010(1)
An application switchboard
1011(1)
An About box
1012(2)
The status bar
1014(2)
A progress meter
1016(5)
Making the application easy to start
1021(1)
Bulletproofing an Application
1022(12)
Using error trapping on all Visual Basic procedures
1023(4)
Maintaining usage logs
1023(4)
Separating tables from the rest of the application
1027(1)
Building bulletproof forms
1027(1)
Validating user input
1028(1)
Using the/runtime option
1028(1)
Encrypting or encoding a database
1029(3)
Removing a database password
1031(1)
Protecting Visual Basic code
1032(2)
Securing the Environment
1034(5)
Setting startup options in code
1035(1)
Disabling startup bypass
1036(1)
Setting property values
1037(1)
Getting property values
1038(1)
Chapter 32 Integrating Access with SharePoint
1039(16)
Introducing SharePoint
1039(1)
Understanding SharePoint Sites
1040(3)
SharePoint documents
1040(1)
SharePoint lists
1041(2)
Sharing Data between Access and SharePoint
1043(9)
Linking to SharePoint lists
1043(3)
Importing SharePoint lists
1046(1)
Exporting Access tables to SharePoint
1047(2)
Moving Access tables to SharePoint
1049(3)
Using SharePoint Templates
1052(3)
Index 1055
Michael Alexander is a Microsoft Certified Application Developer (MCAD) and a Microsoft MVP with over 15 years of experience developing reporting solutions for a variety of industries. He is also the principal contributor at datapigtechnologies.com, where he shares video tutorials with the Microsoft Access and Excel communities. Mike has authored several books on advanced business analysis. Dick Kusleika is a 12-time Microsoft Excel MVP, and the principal contributor at the Daily Dose of Excel blog.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97811195147322e.html
Märksõnad: