Microsoft® Office AccessTM 2007 Inside Out
You're beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2007-and...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Colección: | Inside out
Inside Out |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627077106719 |
Tabla de Contenidos:
- Microsoft Office® Access 2007 Inside Out; About the CD; Sample Applications; System Requirements; Support Information; Conventions and Features Used in This Book; Design Conventions; Syntax Conventions; Introduction; About This Book; 1. Understanding Microsoft Access; Database Capabilities; Access as an RDBMS; Data Manipulation; Data Control; Access as an Application Development System; Deciding to Move to Database Software; 2. Exploring the New Look of Access 2007; Getting Started-A New Look for Access; Exploring the Microsoft Office Button; Taking Advantage of the Quick Access Toolbar
- Understanding Content SecurityUnderstanding the Trust Center; Enabling Content by Defining Trusted Locations; Understanding the New Ribbon Feature; Create Tab; External Data Tab; Database Tools Tab; Understanding the New Navigation Pane; Working with Custom Categories and Groups; Creating and Modifying a Custom Category; Creating and Modifying Groups in a Custom Category; Creating Object Shortcuts in Custom Groups; Hiding Custom Groups in a Category; Hiding and Renaming Object Shortcuts; Revealing Hidden Shortcuts; Sorting and Selecting Views in the Navigation Pane
- Manually Sorting Objects in the Navigation PaneSearching for Database Objects; Using the Single-Document vs. Multiple-Document Interface; Modifying Global Settings via the Access Options Dialog Box; 3. Microsoft Office Access 2007 Overview; Exploring a Desktop Database-Housing Reservations; Table Window in Datasheet View; Queries; Query Window in Datasheet View; Forms; Form Window in Layout View; Form Window in Form View; Reports; Report Window in Print Preview; Report Window in Layout View; Report Window in Report View; Macros; Modules; Exploring a Project File-Conrad Systems Contacts
- Views, Functions, and Stored ProceduresThe Many Faces of Access; 2. Building an Access 2007 Desktop Application; Creating a New Empty Database; Creating Your First Simple Table by Entering Data; Creating a Table Using a Table Template; Creating a Table in Design View; Defining Fields; Setting Field Properties; Completing the Fields in the Companies Table; Defining Simple Field Validation Rules; Defining Input Masks; Defining a Primary Key; Defining a Table Validation Rule; Understanding Other Table Properties; Defining Relationships; Creating a Relationship on Multiple Fields; Adding Indexes
- Multiple-Field IndexesSetting Table Design Options; Creating a Default Template for New Databases; Printing a Table Definition; Database Limitations; 5. Modifying Your Table Design; Checking Object Dependencies; Deleting Tables; Renaming Tables; Changing Field Names; Moving Fields; Inserting Fields; Copying Fields; Deleting Fields; Changing Data Attributes; Changing Data Lengths; Dealing with Conversion Errors; Changing Other Field Properties; Reversing Changes; Using the Table Analyzer Wizard; Taking a Look at Lookup Properties; Working with Multi-Value Lookup Fields
- Changing the Primary Key
