Microsoft Access' advanced features allow a user to create relational databases to build queries, forms, reports, and data access pages that combine information from multiple tables. In this way, you can reap all the benefits of data normalization (deleting duplicate information).
Creating meaningful reports is a must for any business professional.
The benefits of the Switchboard in Access are extremely valuable to anyone that is knowledgeable about using Access or creates databases for other not so knowledgeable users. Creating VBA applications to help automate tasks can expand the benefits of the Switchboard.
This course will teach you to use relational databases to:
- Generate reports for summarizing information
- Create queries
- Create forms for inputs
Manage your database using Microsoft Access' switchboard.
Learn the benefits of Access' Switchboard which allows you to set up your database such that anybody can use it even without knowing the program. A switchboard is essentially a form with buttons which open forms, run queries or produce reports. All the user has to do is simply click on the buttons provided.
This course will teach you to:
Prerequisites
This course is a continutaion of the
Microsoft Access for Beginners course. Students will need to have completed that course or be comfortable with the topics covered in that course.
Requirements
Students will need a copy of Microsoft Access. A trial version is available.
Email this page