:: Introduction
:: Database principles
:: Tables
:: Queries
:: Data security
:: Glossary
:: Resources
:: Student Files
:: Contact
:: Back to Main Site
:: Site Map

Microsoft Access 2003 online course

			> Site Map
			Introduction
			Class I - Database principles
			Functions of a DBMS (database management system)
			Microsoft Excel versus Microsoft Access
			Microsoft Access Objects and their purpose
			Starting your design on paper
			Rules for naming fields and objects
			Data Types
			Primary, concatenated, secondary & foreign keys
			Advantages of having a primary key
			Guidelines for primary keys
			Consequences of a bad database design
			When not to use a DBMS
			Database approach over traditional file processing systems
			Key steps to designing an efficient database model
			More guidelines for designing databases
			Database properties
			Class II - Tables
			Navigation mode keyboard shortcuts
			Edit mode keyboard shortcuts
			Data backup - how to copy tables with data
			Table design structure backup copy
			Microsoft Access Table Wizard
			Database input masks
			Database indexes
			Disadvantages of using indexes
			Indexing a single field or on multiple fields
			Database index properties
			Formatting text field properties
			Size of number fields : byte, integer, long integer, single, double
			Number formats : general, currency, fixed, standard, %, scientific
			Database date & time properties
			Class III - Queries
			Queries - Introduction
			Database query design
			Query By Example
			QBE
			Sorting data by sequence or by using a criteria
			Comparison Operators
			Sorting results for different data types
			Sort keys, primary & secondary sort keys
			Query design using the asterisk
			Arithmetic operators - Addition, Subtraction, Multiplication etc.
			Logical operators - And, Or, Xor, Not
			Multiple criterias - And, Or
			"Like" operator
			"Is" and "Is Not" operators
			"In" operator
			Relational database relationship structures
			Class IV - Data Security
			Computer viruses, worms & hackers
			Spyware & adware
			Data security - Encryption, firewalls
			Data security protection measures
			Useful links
			Database Glossary
			Additional resources for database management & design
			Student Files
			Contact
			Back to main site
		^ Top