In this BigRockDesigns’ training course learn how to build databases to store and retrieve your data more efficiently with Access 365. We will demonstrate how to use the program to sort your data and create your first table, and highlight smart strategies to edit and modify fields and records and more. We will also demonstrate how to build queries and action queries, create and design forms, use Macros, integrate Access with the rest of the Office suite, and maintain your databases over time.
This course can be successfully completed by anyone with a standard level of ICT knowledge and skills.
1. Creating Tables 2. Setting Field Properties 3. Organising Records 4. Using Queries 5. Working with Specialty Queries 6. Creating Forms 7. Designing Forms 8. Creating Reports 9. Working with Macros 10. Integrating Access with Office Suite 11. Maintaining the Database
You will have the ability to*: – create a new database – import and enter data – set up relationships and primary keys – design forms – attach Macros to buttons and tables *These are some examples of skills demonstrated. For a full list, take a look at our PDF (link below).