Muutke küpsiste eelistusi

Access 97 Quick Reference [Pehme köide]

  • Formaat: Paperback / softback, 336 pages, laius x paksus: 215x19 mm, kaal: 413 g
  • Ilmumisaeg: 21-May-1997
  • Kirjastus: Que Corporation,U.S.
  • ISBN-10: 0789712121
  • ISBN-13: 9780789712127
Teised raamatud teemal:
  • Pehme köide
  • Hind: 30,91 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
  • Formaat: Paperback / softback, 336 pages, laius x paksus: 215x19 mm, kaal: 413 g
  • Ilmumisaeg: 21-May-1997
  • Kirjastus: Que Corporation,U.S.
  • ISBN-10: 0789712121
  • ISBN-13: 9780789712127
Teised raamatud teemal:
This complete Access 97 command reference provides you with key information on the most important Access 97 features. With a comprenhensive index and an exhaustive command reference, you'll have all the essential information you need to master Access 97 - at your fingertips!

Muu info

This complete Access 97 command reference provides you with key information on the most important Access 97 features. With a comprenhensive index and an exhaustive command reference, you'll have all the essential information you need to master Access 97 - at your fingertips!
Introduction 1(8)
New Ways of Working 1(1)
Expanded Coverage 2(1)
Who Should Read This Book? 2(1)
Features of the Access 97 Quick Reference 3(1)
Task Reference 5(1)
Conventions Used in This Book 5(3)
Related Books 8(1)
Database Essentials
9(28)
Correct Mistakes: AutoCorrect
9(1)
Correct Mistakes: Undo
10(1)
Data: Copy
10(1)
Data: Edit
11(1)
Data: Enter
12(1)
Data: Find
13(1)
Data: Replace
14(1)
Data: Select
14(2)
Data: Sort
16(1)
Database Open
17(1)
Database Window: View Objects
17(1)
Dates and Times: Enter
18(1)
Exit Access
19(1)
Freeze Display of a Table Field
19(1)
Help: Context Sensitive
20(1)
Help: Dialog Boxes
20(1)
Help: Help Contents and Index
21(1)
Help: Office Assistant
21(1)
Help: Print Help Information
22(1)
Help: Search for Topics
23(1)
Help: Tip of the Day
24(1)
Help: Toolbar Buttons
24(1)
Hyperlinks: Copy
25(1)
Hyperlinks: Enter
25(1)
Hyperlinks: Modify
26(1)
Navigate in a Datasheet
26(2)
Navigate in a Dialog Box
28(1)
Navigate with the IntelliMouse
29(1)
OLE Objects: Enter
29(1)
Records: Add New
30(1)
Records: Copy
31(1)
Records: Delete
32(1)
Records: Go To
32(1)
Spell Check
33(1)
Width of Column
33(1)
Window: Arrange
34(1)
Window: Hide and Unhide
34(3)
Table and Database Design
37(32)
Data: Blanks, Nulls, and Zero-Length Strings
37(1)
Data: Format
38(1)
Data Types: Changing
39(1)
Data Types: Setting Defaults
39(1)
Database: Create Blank
40(1)
Database: Create New with Wizard
40(2)
Database: Documentor
42(1)
Database: Examples
42(1)
Datasheet: Appearance Change
43(1)
Datasheet: Appearance Defaults
44(1)
Decimal Places
44(1)
Field: Caption as Alternate Name
45(1)
Field: Create
46(1)
Field: Default Value
46(1)
Field: Delete
47(1)
Field: Description
48(1)
Field: Insert
49(1)
Field: Name
49(1)
Field: Rename in Datasheet View
50(1)
Field: Set Properties
50(1)
Field: Size
51(2)
Gridlines: Turning On and Off
53(1)
Hide Column
53(1)
Hyperlinks: Create Field
53(1)
Index: Create a Composite Index
54(1)
Index: Create Based on a Single Field
55(1)
Index: Primary Key
55(1)
Index: Set Index Properties
56(1)
Input Mask: Phone Number and Other Entries
57(1)
Lookup Column: Create with Wizard
58(1)
Lookup Column: Properties
59(1)
Relationships Between Tables
60(1)
Status Bar: Display User Message
61(1)
Table: Create by Table Wizard
61(1)
Table: Create in Datasheet View
62(2)
Table: Create in Design View
64(1)
Table: Modify Design
65(1)
Table: Properties
66(1)
Validate Data: Field Validation
67(1)
Validate Data: Record Validation
67(1)
Validate Data: Required Field
68(1)
File Management
69(34)
Back Up Data
69(1)
Database Object: Copy
70(1)
Database Object: Delete
71(1)
Database Object: Description
72(1)
Database Object: Properties
72(1)
Database Object: Rename
72(1)
Database Properties
73(1)
Database: Compact
74(1)
Database: Convert
75(1)
Database: Default Folder Set
75(1)
Database: Repair Closed Database
76(1)
Database: Repair Open Database
76(1)
Excel: Convert Access Object to Excel Worksheet
77(1)
Export and Import: Installing Additional Drivers Through Setup
77(1)
Export and Import: Installing Additional Drivers Through ValuPack
78(1)
Export Data: Access to Access
79(1)
Export Data: Access to Another File Type
79(1)
Export Data: Access Object to HTML
80(2)
Export Data: Text Files
82(1)
Export Data: Word
82(1)
Import Data: 1(st) Steps
83(1)
Import Data: Access
84(1)
Import Data: Checking Data Integrity
84(2)
Import Data: HTML
86(1)
Import Data: Spreadsheet
86(1)
Import Data: Text
87(1)
Import Data: Word
88(1)
Links to External Data: 1(st) Steps
89(1)
Links to External Data: dBASE and FoxPro
89(1)
Links to External Data: Excel
90(1)
Links to External Data: HTML File
90(1)
Links to External Data: Text
91(1)
Links to External Data: Removing
92(1)
Links to External Data: Updating
92(1)
MDE File: Removing Access to Programming
93(1)
Replication: Create Replica
94(1)
Replication: Recover Design Master
94(1)
Replication: Resolve Conflicts
95(1)
Replication: Synchronize
96(1)
Replication: Using Briefcase
96(1)
Save File
97(1)
Security: Create Secure Workgroup
97(1)
Security: Database Encryption/Decryption
98(1)
Security: Database Password
99(1)
Security: Limit User Input
100(1)
Security: User-Level
101(2)
Queries and Filters
103(32)
Action Query: Append Query
103(1)
Action Query: Create
104(2)
Action Query: Delete Query
106(1)
Action Query: Make-Table
106(1)
Action Query: Update Query
107(1)
Criteria: Blanks, Nulls, and Empty
108(1)
Criteria: Date
109(1)
Criteria: Multiple
110(1)
Criteria: Numeric
111(1)
Criteria: Specify
112(1)
Criteria: Text
112(1)
Criteria: Use Another Field
113(1)
Duplicates: Find
113(1)
Duplicates: Remove
114(1)
Filter Data: Advanced Filter
115(1)
Filter Data: By Form
115(2)
Filter Data: By Selection
117(1)
Filter Data: Filter With Shortcut Menu
117(1)
Filter Data: Save as Query
118(1)
List of Values
118(1)
Query Design: Expand Column
119(1)
Query Parameters: Prompt for Input
119(1)
Query: Add Field
120(1)
Query: Add Table
121(1)
Query: Change Column Heading Names
121(1)
Query: Create with Design View
122(1)
Query: Create with Wizard
123(1)
Query: Delete Field
124(1)
Query: Description
124(1)
Query: Editing
124(1)
Query: Format Field
125(1)
Query: Hide and Show Columns
126(1)
Query: Move Column
126(1)
Query: Properties
127(1)
Query: Run
127(1)
Query: Show All Fields
128(1)
Query: Sort Columns
128(1)
SQL Statements: View
129(1)
Subqueries: Create
130(1)
Table Names: Display
130(1)
Tables: Combine with Join
130(2)
Tables: Combine with Union Query
132(1)
Tables: Create a Self Join
133(1)
Top Value Query
133(1)
Unmatched Query
134(1)
Calculations
135(28)
Blanks and Nulls in Calculations
135(1)
Calculated Fields: Forms and Reports--Create by Typing
136(1)
Calculated Fields: Forms and Reports--Edit Expression
137(1)
Calculated Fields: Queries--Create by Typing
138(1)
Calculations: Average of Values
138(1)
Calculations: Count of Items in List
139(1)
Calculations: Date
140(2)
Calculations: First and Last Values
142(1)
Calculations: Maximum and Minimum
142(1)
Calculations: Percent
143(1)
Calculations: Standard Deviation and Variance
144(1)
Calculations: Sum of Values
145(2)
Conversion Functions
147(1)
Crosstab Query: Create
147(1)
Crosstab Query: Fix Column Headings
148(1)
Expression: Operators
149(1)
Expression: Refer to Controls
150(1)
Expression: Refer to Field Names
151(1)
Expression: Using the Builder
151(1)
Expressions: Test Values
152(1)
Functions: Financial
153(2)
Functions: IIf
155(1)
Functions: User-Defined--Use
155(1)
Functions: User-Defined--View
156(1)
Grouping in Queries
157(1)
Grouping in Reports
157(1)
Pivot Table: Create
158(1)
Pivot Table: Modify
159(1)
Running Sum and Count of Records
160(1)
Text: Combining
161(1)
Text: Displaying Parts
161(2)
Forms and Reports
163(66)
Chart: Axes Modify
163(1)
Chart: Colors Display
164(1)
Chart: Create
165(1)
Chart: Data Labels
166(1)
Chart: Data Source Change
167(1)
Chart: Edit
168(1)
Chart: Grid Display
168(1)
Chart: Labels Enter
169(1)
Chart: Legend Display
169(1)
Chart: Titles Add
170(1)
Chart: Trendlines
170(1)
Chart: Type Change
171(2)
Controls: ActiveX Add
173(1)
Controls: ActiveX Register
173(1)
Controls: Add
174(1)
Controls: Align
175(1)
Controls: Bound Control Create
176(1)
Controls: Calculation Create
176(1)
Controls: Change Control Type
177(1)
Controls: Check Box Create
177(1)
Controls: Colors
178(1)
Controls: Combo Box Create
179(2)
Controls: Combo Box Not in List
181(1)
Controls: Command Button Create
182(1)
Controls: Copy
183(1)
Controls: Data Source
183(1)
Controls: Defaults Change
184(1)
Controls: Delete
184(1)
Controls: Display or Hide
185(1)
Controls: Font Size and Face
185(1)
Controls: Labels Create
186(1)
Controls: List Box Create
187(1)
Controls: Move
188(1)
Controls: Option Button Create
188(1)
Controls: Option Group Create
189(1)
Controls: Properties Change
190(1)
Controls: Select
191(1)
Controls: Size
192(1)
Controls: Space
193(1)
Controls: Text Box Create
193(1)
Controls: Toggle Button Create
194(1)
Controls: Unbound Control Create
195(1)
Data: Default Value
195(1)
Data: Validate
196(1)
Date and Time: Insert on Report
197(1)
Format: AutoFormat
197(1)
Format: Copy
198(1)
Format: Numbers and Dates
198(1)
Format: Special Effects
199(1)
Format: Text
199(1)
Forms and Reports: Data Properties
200(1)
Forms and Reports: Data Source
201(1)
Forms and Reports: Default Template
202(1)
Forms and Reports: Design View Options
203(1)
Forms and Reports: Detail Properties
204(1)
Forms and Reports: Name
205(1)
Forms: Create Hypertext Links
206(1)
Forms: Create with AutoForm
207(1)
Forms: Create with Design View
207(1)
Forms: Create with Form Wizard
209(1)
Forms: Create with New Form Dialog Box
210(1)
Forms: Dialog Box Properties
211(2)
Forms: Multiple Records on One Form
213(1)
Forms: Navigation
214(1)
Forms: Sorting
215(1)
Forms: Tab Order
216(1)
Header/Footer: Form and Report
216(1)
Header/Footer: Page
217(1)
Lines: Change Width
218(1)
Lines: Create
218(1)
Reports: Create with AutoReport
219(1)
Reports: Create with Design View
219(1)
Reports: Create with Report Wizard
220(2)
Reports: Grouping
222(1)
Reports: Modify
223(1)
Reports: Sorting
224(1)
Sections: Add and Remove
225(1)
Subform/Subreport: Create
226(1)
Toolbox: Display and Use
227(2)
Producing Output
229(18)
Mail Labels: Create in Report
229(1)
Mail Merge to Word
230(1)
Mail or Sending Data
231(1)
Page Break: Insert in Report
232(1)
Page Numbers: Insert in Report
233(1)
Page Setup: Print Data Only
234(1)
Page Setup: Setting Margins
234(1)
Page Setup: Setting the Orientation
235(1)
Print Forms
235(1)
Print Labels Using Dot Matrix Printers
236(1)
Print One Record from Form
237(1)
Print One Record from Form: Create Command Button
237(1)
Print Preview
238(2)
Print Preview: Layout
240(1)
Print Reports
240(1)
Print Selected Pages
241(1)
Print Table or Query
241(1)
Printing: Multiple Copies
242(1)
Programming Events: Print
243(1)
Web Page: Publish
244(3)
Special Features and Programming
247(30)
Events: Creating Event Response
247(1)
Hyperlink Appearance
248(1)
Locking Records
248(1)
Macros: Create in Design Window
249(1)
Macros: Create with Database Window
250(1)
Macros: Groups
251(1)
Macros: Keyboard Shortcuts
252(1)
Macros: Save as VBA Module
253(1)
Macros: Set Conditions
253(1)
Menu: Create Custom
254(2)
Menu: Startup
256(1)
Menus and Toolbars: Add to Form/Report
256(1)
Optimization: General Suggestions
257(1)
Optimization: Performance Analyzer
258(1)
Optimization: Split Database
259(1)
Optimization: Table Analyzer
260(1)
Programming: Create a Procedure
261(2)
Programming: Create Function
263(1)
Programming: Create Function from Excel
264(1)
Programming: Create Messages
265(1)
Programming: Debug with Breakpoint
266(1)
Programming: Debugging
267(2)
Programming: Find Procedures
269(1)
Programming: Printing
269(1)
Programming: Variables Setting
270(1)
Programming: View Button Wizard Results
271(1)
Programming: View Options
272(1)
Startup Options
273(1)
Toolbar: Create Custom
274(1)
Toolbars: Display
275(2)
Glossary 277(14)
Index 291