This course will focus on how to create a powerful and effective Microsoft Access database from a basic Microsoft Excel spreadsheet. The course starts with learning how to convert a Microsoft Excel spreadsheet into an Access database and the advantages of doing so, how to customize a Microsoft Access table, how to create queries, macros, execution forms, and reports. The make-up of the database are these 6 areas and this course focuses on utilizing these areas to properly analyze data. To conclude the course, students will be able to implement the material learned in this course by creating their own database.
- Have basic knowledge of data management and how to enter data in a Microsoft Excel spreadsheet (Minimum)