{"product_id":"9781891762567","title":"Essentials of Access 2000: Skills and Drills Workbook","description":"There is no faster way to learn the skills necessary to     create effective Access databases. Pick up this book Monday morning, and you'll     be finished Tuesday afternoon. \"The Essentials of Access 2000\" is     written in a step-by-step tutorial format. It's the same course you can take     from a professional training company... of course, you'd have to spend up to     $600. Now the course comes to you... and for a fraction of the cost.  \u003cp\u003eEach book comes with a CD containing the lesson files necessary to complete     the book. You will need to already own Access 2000 and have the program installed     on your computer.\u003c\/p\u003e  \u003cp\u003e\u003ci\u003eThe Access Environment\u003c\/i\u003e\u003cbr\u003e    Database Objects, Toolbars and Menus, Use the Office Assistant for Help, Create     a Table by Typing in Data , Create a Primary Key, Name Fields and Add Columns,     Create a Table with the Table Wizard, Import a Table, Add, Save, Sort, and Delete     Records, Freeze and Hide Columns, Adjust Column Width and Row Height, Filter     a Table, Create a Table in Design View, Add a Lookup Column to a Table\u003c\/p\u003e  \u003cp\u003e\u003ci\u003eForms\u003c\/i\u003e\u003c\/p\u003e  \u003cp\u003eUse AutoForm to Create a Form for a Table, Work with Data in Form View, Use     the Form Wizard to Create a Form, Modify Form in Design View, Add and Format     a Label, Add a Header and Footer, View Relationships, Create a Relationship     and Enforce Referential Integrity, Test Referential Integrity and Cascade Delete,     Create a Junction Table for a Many-to-Many Relationship, Compact, Repair and     Backup a Database\u003c\/p\u003e  \u003cp\u003e\u003cbr\u003e    \u003ci\u003eQueries\u003c\/i\u003e\u003cbr\u003e    Create a Select Query with the Simple Query Wizard, Create a Summary Query,     Change Table Data and Rerun an Existing Query , Create a Summary Query in Design     View, Multiple-Table Queries, Create a Multiple-Table Query with Related Tables,     Create a Multiple-Table Query with Previously Unrelated Tables, Create a Parameter     Query Based on an Existing Query, Add a Calculated Field to a Query\u003c\/p\u003e  \u003cp\u003e\u003ci\u003eReports\u003c\/i\u003e\u003cbr\u003e    Create a Mailing Label Report Based on a Table, Change the Data Source for a     Report, Create an Autoreport with the New Object Tool, Create Formatted Autoreports,     Editing Reports in Design View, Edit a Report in Design View\u003c\/p\u003e  \u003cp\u003e\u003ci\u003eField Properties and Subdatasheets\u003c\/i\u003e\u003cbr\u003e    Explore Table Properties, Set Field Size and Explore Formats, Apply an Input     Mask, Set Caption Properties for a Field, Assign Default Values, Set a Validation     Rule and Validation Text, Required and Allow 0-Length Properties, Set a Required     Property, Set an Indexed Field, Using Display Controls in Tables, Create a Combo     Box by Setting Properties, Create a Combo Box With a Table Source, Add a Check     Box Control to a Table, Explore a Subdatasheet, Add and Remove Subdatasheets,     Create an Autoform With a Subform\u003c\/p\u003e  \u003cp\u003e\u003ci\u003eMore on Queries, Forms, and Expressions\u003c\/i\u003e\u003cbr\u003e    Create a Crosstab Query, Explore a Form Based on a Query, Create a Query as     the Basis for a Form, Create a Form Based on Queries, Use the Expression Builder\u003c\/p\u003e  \u003cp\u003e\u003ci\u003eCustomizing Forms with Graphics and Command Buttons\u003c\/i\u003e\u003cbr\u003e    Add Autoformatting to an Existing Form, Add a Static Image to a Form , Add Photos     to a Database, Add Fields to an Existing Form, Add a Command Button to Access     a Form, Create a Switchboard, Make a Switchboard the Opening Screen\u003c\/p\u003e  \u003cp\u003e\u003ci\u003eCustomizing Reports\u003c\/i\u003e\u003cbr\u003e    Create a Report with the Report Wizard, Concatenate Fields, Sort a Report, Add     Grouping Levels to a Report, Add Subtotals and a Total to a Report \u003c\/p\u003e  \u003cp\u003e\u003ci\u003eAccess 2000 and The Web\u003c\/i\u003e\u003cbr\u003e    Create a Data Access Web Page, Create a Read-Only Page, Add a Hyperlink to a     Page, Add Objects Selector Groups\u003cbr\u003e  \u003c\/p\u003e","brand":"IconLogic, Incorporated","offers":[{"title":"Default Title","offer_id":47039485575408,"sku":"9781891762567","price":38.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781891762567_p0.jpg?v=1763609751","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781891762567","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}