이미 소장하고 있다면 판매해 보세요.
|
1. First Things First
What Is Access 2002? Installing and Running Access 2002 A Hand-on Tour of Access 2002 Database Concepts and Design 2. Creating the Objects Creating Database Tables Setting Relationships Between Tables Working with Information in Tables Creating and Using Simple Data-Entry Forms Understanding and Creating Simple Queries Creating and Working Working With Simple Reports 3. Using Access in Your Work Using Operators, Functions, and Expressions Creating Relations and Joins in Queries Working with Select Queries Understanding Form Controls Creating Great Looking Forms Adding Data-Validation Controls to Forms Using OLE Objects, Graphs, Pivot Tables/Charts, and ActiveX Controls Creating and Customizing Reports Presentation-Quality Reports and Printing Creating Calculations and Summaries in Reports 4. Advanced Access Database Topics Working with External Data Working with Advanced Select Queries Working with Action Queries Advanced Query Topics Working with Subforms Creating Mail Merge and Label Reports 5. Acess Application Tools Working with Macros and Events Using Macros in Forms and Reports Working with Visual Basic in Access 2002 Using Visual Basic in Forms and Reports Creating Switchboards, Command Bars, Menus, Toolbar, and Dialog Boxes 6. Access and the External World Moving from Jet to the SQL Server 2000 Desktop Engine Working with Access Projects Using and Creating Access Objects for Intranets and the Internet Building Web Applications, Data Access Pages, and XML |
|
In addition to specifying relationships between tables in an Access database, you can also set up some rules that will help in maintaining a degree of accurary. or Referential Integrity, between the tables. For example, you would not want to delete a customer record in your Customer table if there are related pet records in the pets table. If you did delete a customer record without fist deleting the customer's pets, you would have a system that has pets without an owner. This type of problem could be catastrophic
---p.177 |