Microsoft Office Access 2003 quicksteps / (Record no. 707)

MARC details
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
Holdings
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
Implemented & Customized by: BestBookBuddies

Powered by Koha