knowt logo

INF-101 11/28/2023 (Access 2)

  • 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.

HC

INF-101 11/28/2023 (Access 2)

  • 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.

robot