Course Content - Microsoft Access

Database Design

• Designing and planning a database
• Lookup fields, default values, input masks in designing a table for easier data entry
• Use database wizards

Database Relationships

• Understand the basis for creating relationships
• Create, modify a one-one, one-many relationship between tables
• Apply and use referential integrity in a relationship

Queries

• Extract information based on criteria from the database using the query, select and sort tools available
• Sort and filter data by selection and by form
• Group totals and use functions in a query

Forms and Reports

• Create and modify forms and reports
• Sub-forms and sub-reports
• Move and add new controls to forms and reports
• Calculated control fields in reports
• Integrate with other office applications

Publish on the Web

• Create static wen pages and data access page
• Publish database page on the web

For information on future Microsoft Access courses check our schedule or call your local office now!