Design Databases

Tilde skills Design Databases – Microsoft Access 2013 contributes directly to achieving the unit of competency BSBITA401A Design databases in the Business Services Training Package (BSB07).

This book would be of interest to those seeking to design and develop a relational database.

Key features of this book include:

creating database tables, including defining and modifying field properties;
joining database tables, and applying referential integrity;
creating queries, including sorting, adding criteria, and calculations;
creating and modifying forms based on tables and queries;
creating and modifying reports based on tables and queries;
skills on importing and exporting data;
creating macros, creating command buttons on forms, customising access using the navigation pane, and adding a database password; plus
supplying 59 hands-on exercises, 6 consolidation tasks, 1 workplace scenario; 6 skills challenges; 14 Assessment tasks; plus
supplying additional appendix material on the Quick Access toolbar, saving reports as a PDF file and using Help.