APPENDIX A
Appendix
The purpose of this appendix is to cover the first steps for:
- Creating a database
- Creating a table
- Sorting a column of data in a table
- Creating relationships between tables
- Creating a query
- Creating forms and reports
- Using external data
Two database packages will be used to demonstrate these operations: MS Access 2013 and LibreOffice 5 Base. Both packages are very straightforward for beginners, as almost no knowledge of programming is required. This is not the case for all databases: for example, MySQL is a popular database package but requires a solid understanding of the SQL programming language, which is not covered here.
MS Access 2013 has been used to provide examples throughout this book. It was chosen as it is well-used ...
Get Databases for Small Business: Essentials of Database Management, Data Analysis,and Staff Training for Entrepreneurs and Professionals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
