Overview of How to Create a Navigation Form in Access You can quickly and easily create a navigation form in Access. A navigation form performs the same function as a switchboard form does within your database. A navigation form in Access contains buttons you click to open other database objects, like reports and forms.
Overview of How to Set a Password on an Access Database You can set a password on an Access database to prevent unauthorized access to the database file. To set a password on an Access database, you must first open the database using the “Open Exclusive” command. To do this, open Access and then
Overview of Assigning Macros to Events in Access You can manually assign macros to events in Access forms by using the “Property Sheet” pane. This is an alternative to using the “Command Button Wizard.” This is most often used with command button controls in forms. However, you can also run macros for events that
Overview of Adding Macros to Buttons in Access Forms You can add a macro to a button in Access forms to run the macro when a user clicks the form’s button. To run macros in Access forms, you often assign a macro to an “event” associated with a command button control in a form.
Overview of Standalone Macros in Access Standalone macros in Access are programs you create in a visual environment. In Access, standalone macros run a series of actions in a specified order. Unlike embedded macros, standalone macros in Access appear as separate objects under the “Macros” category in the database’s Navigation Pane. Standalone macros
Overview of Creating Input Masks in Access You can create input masks in Access for table fields to dictate a pattern to use for data entry in the fields. You can manually create input masks for most text, date, and number data type fields in Access, except the “Long Text” data type. Access also
Overview of Exporting Data from Access You can easily export data from Access to a wide variety of formats that are available. You can also export other database objects, like forms and reports. However, there are more limitations on the formats to which these types of objects can be exported. To export data
Overview of How to Create Tables in Access This lesson shows you how to create tables in Access. A table is an organized structure that holds information. It consists of fields of information into which you enter the records of the table. A field is a single column within a table, consisting of one