James L.

Structuring Databases Create Access databases Create and modify tables Define and modify field types Modify field properties Create and modify one-to-many relationships Enforce referential integrity Create and modify queries Create forms Add and modify form controls and properties Create reports Add and modify form controls and properties Create reports Add and modify report control properties Create a data access page Entering Data Enter, edit, and delete records Find and move among records Import data to Access Organizing Data Create and modify calculated fields and aggregate functions Modify form layout Modify report layout and page setup Format datasheets Sort records Filter records Managing Databases Identify object dependencies View objects and object data in other views Print database objects and data Export data from Access Back up a database Compact and repair databases

Creating Content Create new presentations from templates Insert and edit text-based content Insert tables, charts, and diagrams Insert pictures, shapes, and graphics Insert objects Formatting Content Format text-based content Format pictures, shapes, and graphics Format slides Apply animation schemes Apply slide transitions Customize slide templates Insert objects Collaborating Track, accept, and reject changes in a presentation Add, edit, and delete comments in a presentation Compare and merge presentations Managing and Delivering Presentations Organize a presentation Set up slide shows for delivery Rehearse timing Deliver presentations Prepare presentations for remote delivery Save and publish presentations Print slides, outlines, handouts, and speaker notes Export a presentation to another Microsoft Office program