Access Project 3 Ashton James College

Assignments:

Complete project 3 for both the Ashton James College to Learn Today's Concepts

• -->>Update the Birds2U Database available on Blackboard (Page AC168). Note you will need to append the morebirds database into the birds2u database to get the 14 records needed. Both databases are available via the link below.  Turn in the database and all requested print files (via the pdf2printer and attach all when you submit your assignment to the Project 3 Assignment area.
  
  
• Or use the Begon Pest Control Databases that you created in Project 1 and updated in Project 2.
  
  
• Data files and Optional concept quiz available on Blackboard

Begin thinking about your own business.  Obviously you will need a database in which to store your company's information. For the "Exam Project" for this section, you will build this data base and print several reports to demonstrate your comprehension of Access, so begin thinking about this and I will provide more details on Thursday.  You will have all class period on Tuesday to work on your database, which will then be due on Tuesday Nov. 8

Concepts:

• Maintaining a database
  • adding records
    • form view
    • table or datasheet view
  • Searching for a record to update
    • ctrl F or the find button or "Edit/Find on the Menu
    • use filters (filter button or Menu Records/Filter)
      • by selection
      • by form
      • by advanced filter/sort
  • Deleting a record - select row and delete
  • Editing a record
    • Insert Mode (Function Lock/Insert Key)
    • Overtype Mode
• Restructuring a database (design view)
  • changing field properties
  • adding new fields
  • deleting fields
  • resizing columns and rows
• Formatting your datasheet view - using the Format Menu
• Print Preview
• Mass changes
  • update query
  • delete query
  • append query
  • make table query
• validation rules - finalizing your design view
  • required fields
  • specifying ranges
  • default values
  • legal values
  • format values
• Lookup fields
• Referential Integrity
• subdatasheets
• Duplicate Records
• Ordering records
• Indexing your database