If you put two or more words that are separated by a space into the lookup wizard, they need to be in quotes.

When using the lookup, the values under Row Source need to be separated by a semicolon.

To make the lookup work, you need to go to Row Source Type and click the option that says “Update …”

Design view is used to create a table from scratch. Here you can define the fields and set their properties.

The Format property only controls the way a field is displayed in a table.

The Caption property contains the text that displays in the column to identify a field in the Datasheet views.

The Default value property is used to automatically insert a specified value into a new record in a table.

• You could change this value anytime. This property only puts the specified value automatically, it doesn’t lock it.

Data validation - The process of verifying the accuracy or integrity of the data.

Data integrity rules - Ensure that the data in a database is accurate and consistent.

To import from Excel into Access, the column headings need to have the exact same name as the names in Access.

• Go to External Data and click on “New Data Source”.

• Append - Put it at the end of the sheet.

To create a new table or a new form in Access, go to the Create ribbon.

Using the form wizard creates a form for you based on the inputs on the table you already have.

To edit anything on the form, you need to go to Design View. To do this, on the Home ribbon, click View and click Design View.

To insert a logo, under Form Layout Design, click Logo.

• The logo will appear as a tiny box. To change this, double-click on the bottom-right corner; this will put the image as its actual size.

A query is a request.

• It’s a separate section of Access where you can select which fields you want to see, like a filter.

The Query Wizard is under Create.

On Query Design, you can add sort properties to organize the data on the fields. Ex. → If you only want the data of one state.

• To select the fields you want, you can drag them down or double-click them.

To create a form (entry on query), input the prompt text between brackets.

In a key field, you can’t have duplicates.

If you’re going to generate a link between the tables, the Field size must have the same name.

To create a relationship, go to the Database Tools Ribbon.

Enforced Referential Integrity - When the connections only show the fields that have the same data.