Microsoft® Office AccessTM 2007 Step by Step
Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2007. With Step By Step, you set the pace-building and practicing the skills you need, just when you need them! Build databases from scratch or from templatesExchange data with other databases and...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Colección: | Step by step
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627089106719 |
Tabla de Contenidos:
- Microsoft® Office AccessTM 2007 Step by Step; M. Dow Lambert III; Joan Lambert Preppernau; The Team; Online Training Solutions, Inc. (OTSI); Introducing Access 2007; If You Are Upgrading from Access 2002; If You Are Upgrading from Access 2000; Let's Get Started!; Information for Readers Running Windows XP; Using the Start Menu; Navigating Dialog Boxes; The Microsoft Business Certification Program; Becoming a Microsoft Certified Application Specialist-Microsoft Office Access 2007; Taking a Microsoft Business Certification Exam; Certification; More Information
- Features and Conventions of This BookUsing the Book's CD; Minimum System Requirements; Step-by-Step Exercises; Installing the Practice Files; Adding the Practice File Folder to the Trusted Locations List; Using the Practice Files; Removing and Uninstalling the Practice Files; Getting Help; Getting Help with Access 2007; More Information; Quick Reference; 2. Creating a Database; 3. Populating a Database; 4. Sharing and Reusing Information; 5. Simplifying Data Entry by Using Forms; 6. Locating Specific Information; 7. Keeping Your Information Accurate; 8. Working with Reports
- 9. Making Your Database Easy to Use10. Securing and Sharing Information; 1. Exploring Access 2007; Understanding Database Concepts; Opening an Existing Database; Exploring Tables; Exploring Queries; Exploring Forms; Exploring Reports; Exploring Other Access Objects; Modules; Previewing and Printing Access Objects; Key Points; 2. Creating a Database; Creating a Table Manually; Creating a Table from a Template; Manipulating Table Columns and Rows; Key Points; 3. Populating a Database; Importing Information from an Excel Worksheet; Importing or Linking to a SharePoint List
- Collecting Data Through E-MailImporting Information from a Text File; Importing Information from an XML File; Importing Information from an HTML File; Importing Information from an Outlook Folder; Importing Information from a dBASE File; Key Points; 4. Sharing and Reusing Information; Exporting Information to Excel; Exporting Information to a SharePoint List; Exporting Information to Word; Exporting Information to a Text File; Exporting Information to an XML File; Exporting Information to an HTML File; Copying Information to Other Office Programs; Key Points
- 5. Simplifying Data Entry by Using FormsRefining Form Properties; Changing the Arrangement of a Form; Adding Controls to a Form; Entering Data in a Form by Using VBA; Creating a Form by Using an AutoForm; Adding a Subform to a Form; Key Points; 6. Locating Specific Information; Filtering Information in a Table; Filtering Information by Using a Form; Locating Information That Matches Multiple Criteria; Creating a Query Manually; Creating a Query by Using a Wizard; Performing Calculations by Using a Query; Key Points; 7. Keeping Your Information Accurate
- Restricting the Amount of Data in a Field
