People well aware of how the MS Access application works, might find it a very useful tool that does not only enable them to create their own databases, but just like the other MS Office applications, also offers a variety of other uses. The database management software program created by MS Office is often used for managing corporate and consumer data. However, its other uses may involve anything from importing and linking to data to creating budgets that assist in planning out your daily routine.
Initial users may complain about MS Access not being a user friendly application, but it’s only professionals or large Corporate offices who have understood its true worth. Although it may not be applicable for all, however, the benefits of the sensitively developed tools are some things that simply cannot be ignored. One of such applications is the regular use of the Calendar facility the benefit of which can not only be applied to schedule important meetings, but can also be used in doing important daily chores. One such feature is the Calendar that is created by the robust date and time tools of the interface application.
Instructions to create a Calendar using MS Access
Calendar is a feature that is found both in MS Access and MS Excel; however the steps to follow to create a calendar are different in both scenarios. What is about to follow are the steps for creating a calendar using MS Access.
Step 1: Launch the Microsoft Access application software after accessing the MS Office program.
Step 2: Click on the ‘File’ menu and select ‘Open’; then look for the Access form or report that you want to open. Then select ‘Open’ after clicking on them and the report or form will be displayed by the application in Access Design view.
Step 3: Click on the ‘More Controls’ tool button; it resembles a hammer and wrench. After you select it, a tools menu would come up on the screen.
Step 4: In the menu, look for ‘Calendar Control 11.0’ and select it when it is found.
Step 5: Click any point in the Access report or form where you want to create a calendar. The MS Access application would generate a calendar and would insert it into your Access page at the particular point you had earlier chosen in this step.
Step 6: To open the property sheet, press the F4 key on your keyboard. Through this sheet, you can modify and edit your calendar’s times and dates.
Step 7: You now need to connect your calendar with specific data in your database, like, for example, employees’ joining dates. On the top of the Access window, click on the ‘Data’ tab and click the ControlSource property for editing the specific information to which the calendar is tied.
Close the Access window and it would automatically save any changes made to its database. The next time you open the report or database, it will display your calendar.