Tilde skills Create and Use Databases Plus Challenges and Assessment Tasks – Microsoft Access 2013 contributes directly to achieving the unit of competency BSBITU301A Create and use databases (Business Services Training Package BSB07). This book would be of interest to those seeking to understand, create and use a relational database. Key features of this book include:
creating database tables, including defining and modifying field properties;
joining database tables, including an introduction to referential integrity;
creating queries, including sorting, adding criteria, calculations, totals and grouping;
creating and modifying forms based on tables and queries;
creating and modifying reports based on tables and queries;
supplying 35 hands-on exercises, 4 consolidation tasks, 6 challenge tasks and 5 assessment tasks; plus
supplying additional appendix material on the Quick Access toolbar and using Help.
The Tilde Group
About the book
Table of Contents
Topic 1 - Designing your database, Topic 2 - Getting started, Topic 3 - Using database objects and exploring tables, Topic 4 - Creating database tables, Topic 5 - Querying your database, Topic 6 - Creating and working with forms, Topic 7 - Adjusting form layout, Topic 8 - Generating reports.
BSBITU301A Create and use databases
About the authors
The Tilde Group is the authoring entity for Tilde Publishing and Distribution's TILDE skills imprint.