Custom cover image
Teach yourself visually Access 2010 / by Faithe Wempen
Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Series: Teach yourself visually | Visual learn less, read morePublisher: Indianapolis, Ind : Wiley Pub, c2010Edition: Online-AusgDescription: Online-Ressource (1 online resource (335 p.)) : col. illISBN:- 9781282551312
- 1282551310
- 9780470649787
- Nebent.: Umschlagt.: Microsoft Access 2010
- Microsoft Access 2010
- Teach yourself visually Microsoft Access 2010
- Teach yourself visually Access 2010
- 005.7565
- QA76.9.D3
- HF5548.4.M515
Contents:
Summary: The visual way to get up to speed on Access 2010 It's one thing to gain access to Access. It's another thing entirely to figure out how to do all the things you want to do in Access, because the software is not all that intuitive. This full-color guide clearly shows you how to get the most out of Access 2010, including how to enter new records; create, edit, and design tables and forms; organize, analyze, and share data; generate concise reports; and much more. With pages of step-by-step instructions, graphics, and helpful advice, this is the visual learner's Access book-keep this on yourPPN: PPN: 807306789Package identifier: Produktsigel: ZDB-26-MYL | ZDB-30-PQE | ZDB-38-EBR
Teach Yourself VISUALLY™ Access® 2010; Table of Contents; Chapter 1: Getting Started with Access 2010; An Introduction to Access 2010; Start and Exit Access; Create a Blank Database; Close a Database; Create a Database by Using a Template; Open a Database File; Understanding the Access 2010 Interface; Change the Navigation Pane View; Open and Close an Object; View an Object; Chapter 2: Entering and Editing Data; Enter New Records; Navigate between Records; Edit Records; Attach Files to Records; Open, Save, and Remove File Attachments; Insert an OLE Object; Open, Edit, and Remove OLE Objects
Enter Data in a Multivalued FieldDelete Records; Resize Datasheet Columns and Rows; Sort Records; Display Summary Statistics; Print a Datasheet or Form; Chapter 3: Working with Tables; Plan Effective Tables; Create a Table in Datasheet View; Save a Table; Create a Table in Design View; Open a Table in Design View; Rearrange Fields; Insert and Delete Fields; Understanding Data Types; Change a Field's Data Type; Understanding Primary and Composite Keys; Set the Primary or Composite Key; Rename a Table; Delete a Table; Copy a Table; Chapter 4: Working with Fields; Understanding Field Properties
Understanding Field SizesChange a Field Size; Set a Field Caption; Set a Field's Format; Set a Default Value; Make a Field Required; Index a Field; Apply Smart Tags; Create an Input Mask; Create a Validation Rule; Create a Record-Level Validation Rule; Chapter 5: Working with Relationships and Lookups; Understanding Relationships; Create a Relationship between Two Tables; Edit a Relationship; Remove a Relationship; Arrange the Relationships Window; Print a Relationship Report; View Object Dependencies; Document the Database; Understanding Lookups; Create a Table for Use as a Field Lookup
Create a Field Lookup Based on a TableCreate a Field Lookup with Values That You Specify; Set Up a Multivalued Field; Chapter 6: Finding and Filtering Data; Understanding Find and Replace; Find Data by Using Find and Replace; Replace Data by Using Find and Replace; Filter to Show Only Blank or Nonblank Entries; Filter by Selection; Filter for Multiple Values; Using Text Filters; Filter by Form; Save a Filter As a Query; Chapter 7: Creating Simple Queries; Understanding Queries; Create a Query with the Simple Query Wizard; Start a New Query in Query Design View
Insert, Arrange, and Remove Query FieldsSet Field Sorting; Add an Alias to a Query Field; Understanding Criteria; Filter a Query for a Specific Value; Specify a Range of Values; Specify a List of Values; Hide a Field in the Query Results; Combine Criteria; Limit the Records Returned; Chapter 8: Creating More Complex Queries; Understanding Summary Queries; Create a Summary Query with the Simple Query Wizard; Create a Summary Query in Query Design View; Understanding Calculated Fields; Create a Calculated Field; Understanding Action Queries; Run a Make Table Query; Run a Delete Query
Run an Append Query
No physical items for this record