access bais

Pop Quiz Instructions

  • Go to Blackboard to access the pop quiz.
  • The quiz is meant to familiarize students with the material before the lecture.
    • It consists of questions related to the applied lesson.
  • The quiz consists of 4 questions:
    • Each question is worth half a point, totaling 2 points.
  • Important to review the questions beforehand to engage better during the lecture.

Accessing Transcript

  • Downloading Transcripts:
    • Previous lesson transcripts are available, but details about tests or assessments within that transcript should be ignored as they may not be relevant.
    • Current transcripts can be obtained from the closed captioning (CC) feature in videos.

Downloading Spreadsheets

  • Students should download multiple tables:
    • Representative table
    • Customer table
  • Instructions:
    • Save these tables on your desktop for easy access.

Creating a Database in Access

  • Start by opening Microsoft Access:
    • Use the search function to locate the application.
  • Steps to Create a Blank Database:
    1. Click on Access once to open.
    2. A prompt appears to name the database:
    • Copy the desired name to avoid spelling errors.
    • Choose the location (e.g., Desktop) to save your database.
    1. Click 'Create' to proceed.
    • Navigation Interface Introduction:
    • Title Bar: Displays the name of the current database.
    • Quick Access Toolbar: Customizable area for frequently used commands.
    • Top Level Tabs and Ribbon: Hosts various functions of Access.
    • Contextual Tabs: Appear based on selected object (e.g., Table).
    • Navigation Pane: Organizes how different objects (tables, forms, reports, etc.) are displayed.

Naming and Creating Tables

  • Naming the Table:
    • Select the default table and save it with a relevant name (e.g., ‘Customer table’).
  • Creating Fields in Datasheet View:
    • Two views: Datasheet View and Design View.
    • Steps to create fields in Datasheet View:
    1. Click ‘Click to Add’.
    2. Select data type (e.g., Short Text for names).
    3. Think critically: Would you calculate this number?
      • If yes, use a numerical data type; otherwise, use Short Text.
    4. Continue filling in the fields as needed (e.g., Customer Business Name, Last Name).

Creating Fields in Design View

  • To switch to Design View:
    1. Use the toggle button with design icons.
    2. Fields appear vertically; fill in names, types, and any necessary metadata.
    3. Ensure data types align with field usage (e.g., use Currency for monetary values).
    • Setting Primary Key:
    • Identify a field (e.g., Customer Number) as the primary key.
    • Right-click to set as primary key; a key icon will appear next to it.
    • Remove default ID field if necessary, especially if using a custom identifier.

Field Properties and Metadata

  • Adjusting Field Sizes:
    • Click on a field, access properties, and set appropriate character limits (e.g., two characters for customer number).
  • Adding Captions:
    • Help simplify field names for clear interfaces.
    • Add captions in both Design View and Datasheet View for better user interface clarity.

Importing Data

  • Importing Spreadsheets:
    • Close the table before importing.
    • Use External Data menu to navigate to data sources.
    • Select the file type (e.g., Excel), then browse to locate the file.
  • Import Options:
    1. Create a new table from sheet data (field names will be used).
    2. Append data to an existing table (aligns with existing structure).
    3. Link to data for dynamic updates (linking retains live data).
  • Check for duplicates and field alignment before finalizing import steps.

Creating Forms and Reports

  • Building Forms:
    • Go to Create tab, select Form to help users access and interact with data easily.
    • Adjust form design based on user requirements (e.g., text box sizes, labeling).
  • Building Reports:
    • Accessible through the Create tab.
    • Standardize report layouts to fit on standard pages. Adjust by selecting column headers and resizing their widths.
    • Name the report appropriately using camel casing (e.g., CustomerReport).
    • Ensure clarity for users when presenting data in print.

Summary of Learning Outcomes

  • Big focus on how to effectively manage databases using Access.
  • Importance of understanding key concepts such as:
    • Primary & Foreign keys, ER diagrams.
    • Data types and metadata utilization.
    • User interface considerations in form and report designs.
  • The engagement of real-world applications from discussions on database management leads to better handling of practical database scenarios.