Access - Data Base Designing Training Course

Database Fundamentals

• Analysis of the current system
• Define database items
• Normalization
• Relations between the elements
• Naming standards
• Create a database
• Methods for creating arrays (Design View, Wizard, Inputting Data)
• Data types
• Field properties

Records and operations records

• Adding and editing a record
• setting the record
• Search record
• Copying tables

Create a relational database

• Keys
• Relations tables
• Dependencies

Queries

• Create queries
• Using the Query Wizard
• Operations on the results of the query
• criteria query
• Calculations and operators in queries

Forms and controls

• Types of controls
• Using AutoForm
• Using the wizard forms (Form Wizard)
• Properties of controls and forms
• Printing forms.
• Create a subform (Subform)
• Headers and footers

Reports

• Create reports.
• Using AutoReport
• Using the Report Wizard (Report Wizard)
• Sections
• Properties reports

Additional tools for forms and reports

• AutoFormat
• Special Effects
• Open a form at runtime database
• Adding graphics, spell check
• Switchboards

Exporting, importing and linking data

Security

• Passwords
• Database encryption
• Security Wizard

Backups