Microsoft® Office Access 2003 step by step
This practical, hands-on tutorial expertly builds your skills with Microsoft Office Access 2003-one step at a time! With STEP BY STEP, you work at your own pace through easy-Hey, you know your way around a database-so now dig into Access 2003 and really put your information to work! This supremely o...
| Autor principal: | |
|---|---|
| Autor Corporativo: | |
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Colección: | Step by step (Redmond, Wash.)
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627874006719 |
Tabla de Contenidos:
- Microsoft® Office Access 2003: Step by Step; Getting Help; Getting Help with Microsoft Office Access 2003; More Information; Using the Book's CD-ROM; Minimum System Requirements; Installing the Practice Files; Using the Practice Files; Uninstalling the Practice Files; Conventions and Features; Taking a Microsoft Office Specialist Certification Exam; What Does This Logo Mean?; Selecting a Microsoft Office Specialist Certification Level; Microsoft Office Specialist Skill Standards; The Exam Experience; Test-Taking Tips; Certification; College Credit Recommendation; For More Information
- Microsoft Office Specialist Skill StandardsAbout the Authors; Quick Reference; Chapter 2 Creating a New Database; Chapter 3 Getting Information Into and Out of a Database; Chapter 4 Simplifying Data Entry with Forms; Chapter 5 Locating Specific Information; Chapter 6 Keeping Your Information Accurate; Chapter 7 Working with Reports; Chapter 8 Making It Easy for Others to Use Your Database; Chapter 9 Keeping Your Information Secure; Chapter 10 Working with Pages and Modules; 1. Getting to Know Microsoft Access 2003; Discovering What's Special About Access; Opening an Existing Database
- Exploring TablesExploring Queries; Exploring Forms; Exploring Reports; Exploring Other Access Objects; Macros; Modules; Previewing and Printing Access Objects; Key Points; 2. Creating a New Database; Checking the Work of a Wizard; Creating Tables the Simple Way; Refining How Data is Displayed; Manipulating Table Columns and Rows; Key Points; 3. Getting Information Into and Out of a Database; Importing Information from a Delimited Text File; Importing Information from a Fixed-Width Text File; Importing Information from an Access Database; Importing Information from Other Databases
- Importing Information from an HTML FileImporting Information from an XML File; Exporting Information to Other Programs; Linking a Database to Information in Another Database; Other Ways to Share Access Data; Key Points; 4. Simplifying Data Entry with Forms; Refining Form Properties; Refining Form Layout; Adding Controls to a Form; Using Visual Basic for Applications to Enter Data in a Form; Creating a Form by Using an AutoForm; Adding a Subform to a Form; Key Points; 5. Locating Specific Information; Filtering Information in a Table; Filtering by Form
- Locating Information that Matches Multiple CriteriaCreating a Query in Design View; Creating a Query with a Wizard; Performing Calculations in a Query; Key Points; 6. Keeping Your Information Accurate; Using Field Size Properties to Restrict Data; Using Input Masks to Restrict Data; Using Validation Rules to Restrict Data; Using Lookup Lists to Restrict Data; Updating Information in a Table; Deleting Information from a Table; Key Points; 7. Working with Reports; Modifying a Report; Creating a Report from Scratch; Adding a Subreport to a Report; Previewing and Printing a Report; Key Points
- 8. Making It Easy for Others to Use Your Database
