Microsoft Office Access Training Course

Structuring a Database

• Define data needs and types
• Define and print table relationships
• Add, set, change, or remove primary keys
• Split databases

Creating and Formatting Database Elements

• Create databases
• Create tables
• Modify tables
• Create fields and modify field properties
• Create forms
• Create reports
• Modify the design of reports and forms

Entering and Modifying Data

• Enter, edit, and delete records
• Navigate among records
• Find and replace data
• Attach documents to and detach from records
• Import data

Creating and modifying queries

• Create queries
• Modify queries

Presenting and Sharing Data

• Sort data
• Filter data
• Create and modify charts
• Export data
• Save database objects as other file types
• Print database objects

Managing and Maintaining Databases

• Perform routine database operations
• Manage Databases