# data[].attributes.body
Solution #8 - Users should experiment with the conditional formatting feature. Trying different formatting and viewing what the data looks like provides the user with direct feedback. It is important that data remains professional looking and colors fit a theme when using conditional formatting features.

# data[].attributes.body
Obstacle #8 – While sorting, filtering, or using conditional formatting, it is necessary to find the right formatting that you wish to use. If you do not use the correct conditional formatting rules, then the displayed information will be incorrect.

# data[].attributes.body
Solution #7 –  You must import the correct data into the report you are creating.  You also need to ensure all of the data you entered into the table you import is also correct.

# data[].attributes.body
Obstacle #7 - It is mandatory that you have the correct data when working with the total function. If you do not have the correct data, the total displayed will be erroneous.

# data[].attributes.body
Solution #6 - Finding and making sure you have the correct data will allow the function to work properly.

# data[].attributes.body
Obstacle #6 - When creating a query and using a function, it is mandatory to import the data that you will be using.

# data[].attributes.body
Solution #5 - The creator must understand what the functions do and what that function is going to output.

# data[].attributes.body
Obstacle #5 - Your query must be created with the correct function in order to find the data that you are searching for.

# data[].attributes.body
Solution #4 - Be sure to add a header and footer that represents what you want your form to represent. Your company name and type of form (order/invoice/customer list) should be included. Becoming familiar working in Design View will help you with this.

# data[].attributes.body
Obstacle #4 - Your header and footer needs to informer users/customers what they are looking at in a professional manner.

# data[].attributes.body
Solution #3 - Use the Layout View in Access to edit the looks and functionality of your forms. Here you can change font, add/remove columns and rows, resize columns/rows, etc.

# data[].attributes.body
Obstacle #3 - Ensure that your created forms are functional (include options for all information needed) and professional looking.

# data[].attributes.body
Solution #2 - Create a primary key that is unique, one that is never null, and one that ideally never changes. If you are unsure of what to use for a primary key, create an AutoNumber field and Access will automatically generate one for you.

# data[].attributes.body
Obstacle #2 - Creating a primary key that is unique and effective is critical to the success of the database.

# data[].attributes.body
Solution #1 - It is important to use similar terminology between the created fields and tables. Most importantly, have an understanding of the end goal of your database. Are you tracking inventory, customer information, sales, etc.?

# data[].attributes.body
Obstacle #1 - Make sure that the created fields are associated with the appropriate tables.