Microsoft Office Access 2003 quicksteps / (Record no. 707)
[ view plain ]
000 -LEADER | |
---|---|
fixed length control field | 06743nam a22002657a 4500 |
003 - CONTROL NUMBER IDENTIFIER | |
control field | MACHS |
005 - DATE AND TIME OF LATEST TRANSACTION | |
control field | 20210413150515.0 |
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
fixed length control field | 180604b2004 00| 0 eng c |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
International Standard Book Number | 9780072232295 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
International Standard Book Number | 0072232293 |
040 ## - CATALOGING SOURCE | |
Transcribing agency | MACHS |
050 14 - LIBRARY OF CONGRESS CALL NUMBER | |
Classification number | QA76.9.D3 |
Item number | C757 2004 |
100 1# - MAIN ENTRY--PERSONAL NAME | |
Relator code | Cronan, John. |
245 10 - TITLE STATEMENT | |
Title | Microsoft Office Access 2003 quicksteps / |
Statement of responsibility, etc. | John Cronan, Virginia Andersen, Brenda Bryant Anderson. |
246 3# - VARYING FORM OF TITLE | |
Title proper/short title | Access 2003 |
246 3# - VARYING FORM OF TITLE | |
Title proper/short title | Microsoft Access 2003 |
260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
Place of publication, distribution, etc. | New York : |
Name of publisher, distributor, etc. | McGraw-Hill/Osborne, |
Date of publication, distribution, etc. | 2004. |
300 ## - PHYSICAL DESCRIPTION | |
Extent | xii, 227 p. : |
Other physical details | col. ill. ; |
Dimensions | 21 x 26 cm. |
500 ## - GENERAL NOTE | |
General note | Includes index. |
505 ## - FORMATTED CONTENTS NOTE | |
Formatted contents note | Acknowledgments p. vi<br/>Introduction p. xii<br/>Conventions Used in this Book p. xii<br/>Chapter 1 Stepping into Access p. 1<br/>Start Access p. 1<br/>Starting Access p. 2<br/>Use the Start Menu to Start Access p. 2<br/>Tour the Database Window p. 3<br/>Open a Database p. 5<br/>Open Older Databases p. 9<br/>Using Task Panes p. 10<br/>Change the Default Access File Format p. 10<br/>Find a Database p. 11<br/>Personalize Access p. 12<br/>Remove the Getting Started Task Pane p. 12<br/>Select a Toolbar to Display p. 12<br/>Customize a Toolbar p. 13<br/>Using Toolbars p. 14<br/>Show Full Menus p. 14<br/>Using the Keyboard in Access p. 15<br/>View Shortcut Keys p. 15<br/>Rearrange Object Windows p. 15<br/>Using the Keyboard in Windows p. 16<br/>Using Help p. 18<br/>Get Help p. 18<br/>Open Help p. 18<br/>End Your Access Session p. 19<br/>Close a Database p. 19<br/>Close Access p. 20<br/>Chapter 2 Creating a Database p. 21<br/>Create the Database Framework p. 21<br/>Use a Database Template p. 23<br/>Get Access Samples from Microsoft's Office Online p. 28<br/>Build a Database on Your Own p. 32<br/>Build the Framework with Tables p. 34<br/>Start the Table Wizard p. 34<br/>Selecting Tables and Fields from the Table Wizard p. 36<br/>Create a Table with Data Entry p. 39<br/>Build a Table in Design View p. 41<br/>Assigning a Primary Key p. 44<br/>Add Identifying Information p. 45<br/>Identify Relationships p. 45<br/>Define Relationships p. 45<br/>Relate Tables p. 46<br/>Enforce Referential Integrity p. 48<br/>Chapter 3 Modifying Tables and Fields p. 49<br/>Make Basic Changes to Tables and Fields p. 50<br/>Delete a Table p. 50<br/>Rename a Table p. 51<br/>Change Field Names p. 51<br/>Fine Tune the Fields p. 52<br/>Switching Views p. 53<br/>Choose a Data Type p. 53<br/>Change Display of Data Through the Format Property p. 54<br/>Create a Pattern for Data Entry with Input Masks p. 57<br/>Editing and Entering Input Masks p. 58<br/>Establish a Field's Default Value p. 60<br/>Limit Field Values with a Validation Rule p. 60<br/>Require Entry but Allow a Zero Length String p. 61<br/>Use the Caption Field Property p. 62<br/>Index a Data Field p. 63<br/>Add Smart Tags p. 64<br/>Use the Lookup Wizard p. 65<br/>Display and Create Subdatasheets p. 69<br/>View a Subdatasheet p. 69<br/>Create a Subdatasheet p. 70<br/>Chapter 4 Working in the Datasheet p. 73<br/>Enter and Edit Data p. 75<br/>Enter New Data in a Datasheet p. 75<br/>Use Keyboard Shortcuts in a Datasheet p. 77<br/>Moving Through Records p. 78<br/>Selecting Records, Fields, and Columns with the Mouse p. 80<br/>Insert Pictures p. 80<br/>Copy and Move Data p. 81<br/>Delete Records and Columns p. 83<br/>Find and Replace Text p. 84<br/>Verify Spelling p. 86<br/>Acquire Data p. 88<br/>Import Data from Outside Sources p. 89<br/>Paste Data into a Datasheet p. 94<br/>Arrange the Datasheet p. 95<br/>Insert Columns p. 95<br/>Adjust Column Width p. 96<br/>Changing How the Current Datasheet Looks p. 97<br/>Move a Column p. 98<br/>Rename a Column p. 98<br/>Hide and Unhide Columns p. 98<br/>Lock and Unlock Columns p. 98<br/>Adjust Row Height p. 99<br/>Chapter 5 Retrieving Information p. 101<br/>Sort Data p. 101<br/>Sort Records in a Datasheet p. 102<br/>Sort Records in a Form p. 104<br/>Filter Data p. 105<br/>Filter by Selecting a Value p. 105<br/>Choosing a Filter p. 106<br/>Filter by Form p. 107<br/>Deleting or Removing a Filter p. 108<br/>Filter for an Input p. 108<br/>Use Operators and Wildcards in Criteria p. 109<br/>Running and Modifying a Saved Advanced Filter p. 111<br/>Use Advanced Filters p. 111<br/>Work with Queries p. 113<br/>Create a Simple Query with a Wizard p. 113<br/>Create or Modify a Query in Design View p. 115<br/>Using the Expression Builder p. 119<br/>Set Query Properties p. 119<br/>Chapter 6 Creating Forms and Using Controls p. 121<br/>Create Forms p. 121<br/>Creating a Form Using AutoForm p. 122<br/>Get a Head Start with the Form Wizard p. 122<br/>Creating a Two-Table Form p. 126<br/>Create a Form in Design View p. 126<br/>Add Fields p. 128<br/>Explore the Toolbox Tools p. 129<br/>Using the Toolbox p. 130<br/>Modify the Form Design p. 130<br/>Choosing the Control Type p. 133<br/>Use Controls p. 133<br/>Add Bound Controls p. 133<br/>Add Unbound Controls p. 137<br/>Copy or Delete a Control p. 140<br/>Rearrange Controls p. 140<br/>Modify Controls p. 144<br/>Navigating in a Data Entry Form p. 146<br/>Chapter 7 Working with Reports p. 147<br/>Create Reports p. 147<br/>Viewing Reports p. 148<br/>Use AutoReport to Create a Report p. 149<br/>Use the Report Wizard to Create a Report p. 150<br/>Create a Report in Design View p. 154<br/>Modify Reports <br/>Group Data in Reports p. 157<br/>Calculate a Value p. 158<br/>Accomplishing Common Tasks in Reports p. 159<br/>Create a Subreport p. 160<br/>Create Labels p. 162<br/>Create a Report Snapshot p. 164<br/>Distribute a Report Snapshot p. 166<br/>Chapter 8 Preparing Your Data for Presentation p. 167<br/>Improve the Data's Appearance p. 167<br/>Modify Images p. 168<br/>Add a Chart p. 170<br/>Using the Formatting Toolbar p. 173<br/>Use Graphics p. 173<br/>Modify the Form or Report Design p. 174<br/>Print Your Data p. 176<br/>Set Up the Print Job p. 176<br/>Review Data Before Printing p. 180<br/>Output the Print Job p. 183<br/>Choosing What to Print p. 184<br/>Chapter 9 Securing and Administrating Access p. 187<br/>Establish User-Level Security p. 187<br/>Deciding Who Needs What Permissions p. 188<br/>Understand the User-Level Security Model p. 188<br/>Secure the Database with the User-Level Security Wizard p. 188<br/>Keeping Data Safe p. 195<br/>Apply Global Database Protection to a Database p. 195<br/>Use a Database Password p. 196<br/>Remove Database Objects from View p. 198<br/>Back Up and Restore a Database p. 199<br/>Database Administration p. 203<br/>Document a Database p. 203<br/>Compact and Repair a Database p. 204<br/>Chapter 10 Extending Access p. 205<br/>Use Advanced Data Analysis Tools p. 205<br/>Create a Crosstab Query with a Wizard p. 205<br/>Create a PivotTable in Forms p. 208<br/>Create the PivotTable Layout p. 210<br/>Create a PivotChart p. 212<br/>Share Data p. 213<br/>Export Access Data p. 213<br/>Link Files p. 214<br/>Working with OfficeLinks p. 215<br/>Integrate Web Technology p. 217<br/>Add a Hyperlink field to an Existing Table p. 217<br/>Creating a Hyperlink to a File or Web Page p. 218<br/>Save Database Objects as Static Web Pages p. 218<br/>Create a Data Access Page with a Wizard p. 220<br/>Create a User Interface p. 221<br/>Create a Custom Dialog Box p. 222<br/>Add Command Button Controls to a Dialog Box p. 222<br/>Set Dialog Box Properties p. 222<br/>Index p. 223<br/> |
650 0# - SUBJECT ADDED ENTRY--TOPICAL TERM | |
Topical term or geographic name as entry element | Database management. |
700 1# - ADDED ENTRY--PERSONAL NAME | |
Personal name | Andersen, Virginia. |
700 1# - ADDED ENTRY--PERSONAL NAME | |
Personal name | Anderson, Brenda Bryant. |
942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
Source of classification or shelving scheme | Library of Congress Classification |
Koha item type | Books |
Withdrawn status | Lost status | Source of classification or shelving scheme | Damaged status | Not for loan | Home library | Current library | Date acquired | Total Checkouts | Full call number | Barcode | Date last seen | Bill Date | Koha item type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Library of Congress Classification | Not For Loan | Main library Nursing Buliding | Main library Nursing Buliding | 04/06/2018 | QA76.9.D3 C757 2004 | N2389 | 04/06/2018 | 04/06/2018 | Books |