Microsoft Office Access

Lorem ipsum dolor sit amet, consetetur sadipscing elitr

MICROSOFT ACCESS

About this Course

This one-day instructor-led course provides students with an overview of the features and functions of Microsoft Access 2010.


Intended Audience

This course is intended for information workers who want to learn intermediate-level Access 2010 skills.


You Will Learn How To

• Restrict the type of data.
• Restrict the amount of data.
• Restrict the format of data.
• Restrict data by using validation rules.
• Restrict data to values in lists.
• Restrict data to values in other tables.
• Modify forms created by using a wizard.
• Add controls.
• Add subforms.
• Use e-mail forms to collect data.
• Create queries by using a wizard.
• Create queries manually.
• Use queries to summarize data.
• Use queries to perform calculations.
• Use queries to update records.
• Use queries to delete records.
• Create reports manually.
• Modify report content.
• Add subreports.

MICROSOFT ACCESS Level 2

About this Course

This one-day instructor-led course provides students with an overview of the more complex features and functions of Microsoft Access 2010.


Intended Audience

This course is intended for experienced information workers who want to learn advanced-level Access 2010 skills.


You Will Learn How To

• Import information.
• Export information.
• Copy to and from other Office programs.
• Create navigation forms.
• Create custom categories.
• Control which features are available.
• Assign passwords to databases40
• Split databases.
• Secure databases for distribution.
• Prevent database problems.
• Change default program options.
• Customize the ribbon.
• Customize the Quick Access Toolbar.

Request More Information