MICROSOFT ACCESS (BASIC AND INTERMEDIATE LEVEL)

INTRODUCTION FOR MICROSOFT ACCESS (BASIC AND INTERMEDIATE LEVEL)

This training is a customized training basic and intermediate users. The training will cover basic database method in Access, Relational Database technique and database management and security.

LEARNING OUTCOME

Upon successful completion of this training the trainee will be able to:

• Work with Microsoft Access’s vital features
• Create databases using tables and forms
• Create and customize reports
• Maintain data integrity
• Import and export data
• Make databases user friendly
• Protect databases

PRE-REQUISITE

• Familiar with basic database concept.

SOFTWARE VERSION

• Microsoft Access version 2013 and above

DURATION

• 2 days

COURSE CONTENT

Microsoft Access  vital features

• Identify new features of Access.
• Work in the Access user interface.
• Understand database concepts.
• Explore tables, forms, queries, and reports.
• Preview and print database objects

Create databases and simple tables

• Create databases from templates.
• Create databases and tables manually.
• Manipulate table columns and rows.
• Refine table structure.
• Define relationships between tables.

Create simple forms

• Create forms by using the Form tool.
• Format forms.
• Arrange the layout of forms.

Display data

• Create forms by using the Form tool.
• Format forms.
• Arrange the layout of forms.

Create simple reports

• Create reports by using a wizard.
• Modify report design.
• Preview and print reports.

Maintain data integrity

• Specify the type of data.
• Set the field size.
• Restrict the format of data.
• Validate the data.
• Allow only values in lists.
• Allow only values in other tables.

Create queries

• Create queries by using a wizard.
• Create queries manually.
• Summarize data by using queries.
• Calculate by using queries.
• Update records by using queries.
• Delete records by using queries.

Create custom forms

• Modify forms created by using a wizard.
• Add controls.
• Display subforms.

Create custom reports

• Create reports manually.
• Modify report content.
• Add subreports.

Import and export data

• Import information.
• Export information.
• Copy to and from other Office programs.

Make databases user friendly

• Design navigation forms.
• Create custom categories.
• Control which features are available.

Protect databases

• Assign passwords to databases.
• Split databases.
• Secure databases for distribution.
• Prevent database problems.

Work in Access more efficiently

• Assign passwords to databases.
• Split databases.
• Secure databases for distribution.
• Prevent database problems