Microsoft® Office Access 2003 inside out
dc:abstract """""" Hey, you know your way around a database-so now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer...
| Autor principal: | |
|---|---|
| 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/alma991009627895906719 |
Tabla de Contenidos:
- Microsoft® Office Access 2003 Inside Out; We'd Like to Hear from You!; About the CD; Sample Applications; Using the CD; 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; Microsoft Access as an RDBMS; Data Manipulation; Data Control; Microsoft Access as an Application Development System; Deciding to Move to Database Software; 2. The Many Faces of Microsoft Access; Exploring a Desktop Database-Housing Reservations
- The Table Window in Datasheet ViewQueries; The Query Window in Datasheet View; Forms; The Form Window in Form View; Reports; The Report Window in Print Preview; Data Access Pages; The Data Access Page Window in Page View; Macros; Modules; Organizing Your Objects; Exploring a Project File-LawTrack Contacts; Views, Functions, and Stored Procedures; The Many Faces of Microsoft Access; 3. Designing Your Database Application; Step 2: Charting Task Flow; Step 3: Identifying Data Elements; Step 4: Organizing the Data; Step 5: Designing a Prototype and a User Interface
- Step 6: Constructing the ApplicationStep 7: Testing, Reviewing, and Refining; An Application Design Strategy; Selecting the Data; Organizing Tasks; Data Analysis; Mapping Subjects to Your Database; Database Design Concepts; Normalization Is the Solution; Primary Keys; Functional Dependence; Field Independence; Efficient Relationships Are the Result; One-to-Many and One-to-One Relationships; Creating Table Links; When to Break the Rules; Capturing Point-In-Time Data; Creating Report Snapshot Data; 2. Building a Microsoft Access Desktop Application; Creating a New Empty Database
- Creating Your First Simple Table by Entering DataCreating a Table Using the Table Wizard; 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 Indexes; Setting Table Design Options; Printing a Table Definition; Database Limitations; 5. Modifying Your Table Design
- Checking Object DependenciesDeleting 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; Changing the Primary Key; Compacting Your Database; 6. Importing and Linking Data; Importing vs. Linking Database Files; Importing Data and Databases; Importing Paradox Files; Importing SQL Tables; Importing Access Objects
- Importing Spreadsheet Data
