Use Application Parts to quickly build tables and forms in Access

Application Parts are a quick way to partially, or completely, build specific tables and forms for your database. Using the Contacts template as an example, once used, this Application Part will create tables, queries, forms and reports. This preset functionality is useful, especially if you are not sure where to start. Even though the Application Part … Continue reading Use Application Parts to quickly build tables and forms in Access

Access – Normalizing Tables

Not sure if you separated out the fields in the tables correctly? Normalizing your database is key to building an easy to use database. Using the “Analyze Table” command, Access will make recommendations. It then allows you to keep or alter the suggestions. The steps for using this functionality is as follows: Click the Database … Continue reading Access – Normalizing Tables

Access: Normalizing your database

Not sure if you separated out the fields in the tables correctly? Normalizing your database is key to building an easy to use database. Using the “Analyze Table” command, Access will make recommendations. It then allows you to keep or alter the suggestions. The steps for using this functionality is as follows: Click the Database … Continue reading Access: Normalizing your database