Microsoft® Office AccessTM 2007 Plain & Simple
Here's WHAT You'll Learn Easily navigate the new user interfaceDesign and build your own databaseBuild forms that help you collect informationCreate charts and reportsExchange data with other databases and documentsHelp prevent unauthorized data access Here's HOW You'll Learn...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627098306719 |
Tabla de Contenidos:
- Microsoft® Office AccessTM 2007 Plain & Simple; 1. Introduction: About This Book; ...And the Easiest Way to Do Them; A Quick Overview; A Few Assumptions; A Final Word (or Two); 2. What's New in Access 2007; Formatting Database Objects Using New AutoFormats; Creating New Types of Fields; Collecting Data from E-mail Messages; 3. Introducing Access 2007; Storing Data on the Computer; Storing Data in a Database; Starting Access; Create a Shortcut for Access; Surveying the Access Window; Opening a Database; Open a Recently Used Database; Viewing Multiple Database Objects
- Scroll within a Database ObjectClosing a Database and Exiting Access; Exit Access; Displaying and Managing Database Objects; Control Object Display in the Navigation Pane; Using the Access Help System; Get Microsoft Access Help; Get Help on the Web; 4. Getting to Know Access Databases; Working with Database Objects; Open an Object; View an Object in Design View; Save an Object; Delete an Object; Examining a Table; Navigate in a Table; Examining a Form; Enter Data Using a Form; Navigating Using a Switchboard; Open a Switchboard; Move Using a Switchboard; Examining a Query; Examining a Report
- Using the Database TemplatesFind Database Templates Online; Frequently Used Object Views; 5. Creating a Database; Give Every Table a Primary Key; Include Foreign Keys; Creating a New Database; Create a New Database Based on Another Database; Creating a New Table in Design View; Creating a New Table by Typing; Adding Existing Fields to a Table; Add Fields from Existing Tables; Setting a Primary Key; Getting Data from Other Access Tables; Relationships Explained; Many-to-Many Relationships; Creating Relationships between Tables; Enforcing Referential Integrity; 6. Customizing Fields
- Add a FieldArrange Fields; Assigning a Data Type; Viewing or Changing Field Properties; Introducing the Expression Builder; Formatting Field Contents; Creating Input Masks; Edit an Input Mask; Assigning Required Fields and Requiring Data Entry; Disallow Zero-Length Strings; Setting Default Values; Indexing Field Values; Validating Data Entry; Set Validation Text; Creating a Lookup Field; Allow Multiple Selections from a Lookup Field; Draw Lookup Values from a Data List; Creating an Append-Only Memo Field; Creating an Attachment Field; 7. Customizing Tables; Replace Text
- Entering Data Using AutoCorrectTurn AutoCorrect On or Off; Add AutoCorrect Values; Adding and Editing Text; Delete Text; Undoing Operations; Copy and Paste Text; Copy and Paste Items with the Office Clipboard; Manipulating Columns; Insert a Column; Rename a Column; Copy a Column; Modifying Columns and Rows; Change Column Width; Viewing a Subdatasheet; Create a Subdatasheet; Filtering Table Records; Filter by Form; Remove a Filter; Filter Records by the Contents of More than One Column; 8. Creating Forms; Creating a Form Using the Form Wizard; Creating a Form in Design View
- Creating a Multiple Items Form
