This workshop introduces experienced Access users to issues relating to database design and the packaging of completed databases for distribution to end users. The workshop begins with an extensive lecture and discussion section on database modeling, then proceeds into a series of hands-on exercises to implement the database design and create a usable application for end users. Also provides a brief introduction to database security considerations.
What you'll learn:
define database needs
use business rules in database design
model a database before creating it
normalize imported flat file data into separate tables
create and maintain complex table relationships
package and password protect a database
compact a database
What you need to know
Understand database relationships
Create and edit relational forms and reports
Create a form-based application
If you don't have those skills, consider first taking the workshop:
IT – Informatics & Communications Technology Complex (ICTC)
535 W. Michigan St.
Indianapolis, IN 46202
There are no upcoming dates for this event.