Access Mid Term Review
Mid Term Topics/Concepts
of Databases. Flat File Databases,
Relational Databases, Types of Data, Sorts vs Indexes, and Keys; Master Keys,
Uniqueness of Keys. Arranging Data,
Tables vs Databases.
Chapter 3: Database Concepts
Database in Access, a container holding data and associated objects.
Database objects include tables, forms, queries, reports, macros and modules.
Access can only work with one Database at a time, but you can have many tables, and other modules in one database.
A table is a container for raw data or records.
Know what the following are: Records, Fields, Values, Objects, Views, Datasheet (can be part of a table), Queries, Dynasets (dynamic set of data), Data Entry and Display Forms, Reports
Chapter 4: Tour of Access
Know How to Use the mouse and keyboard in Access
Know these terms and concepts: Access Window, Object Windows, Title Bar
Control-menu button (also right clicking menu bar), How to Move, size minimize, or close
Menu Bar, Toolbar
Status Bar.. left side shows status. Right side gives key status
Database Window: object buttons, toolbar buttons, object list
View Choice: Large Icons, Small Icons, List, Details.
Design Windows: Toolbox, Color, Special Effect and Border Windows for Forms
Field List Window, Property Window
How to Use the CD in the Book and Installing Examples from the book:
Stick CD #1 in, Find Samples Folder, do setup from this folder only
Note folder name where samples are put! Then load each table in access as directed in the book.
Be able to Open the Mountain Animal Hospital Database, then Pets Table
See Pets Datasheet, Moving through…
Know how to:
Go to Design View..
Displaying a Form Click on Forms, Pets, view form then click on design view.
Do a simple Query: Click on Queries Button, select new, add, pets table,
Double Click Pet Name to add to query. Add breed and Type of animal to the query. Go to the Criteria Row for type of animal, type DOG in the cell. Click on the ! cell to run the query.
Display a Report: Click reports button, select Pet Directory, Select Preview Button
Show the zoom with the mouse on the report.
Chapter 5: Database Design
7 Step Method of Designing a Database:
Catch 22… Which comes first the chicken (report) or the egg (tables)
Finding out what the client wants and needs, and what type of data is available.
Overall System Design
Report Design (Output)
Data Design (Fields)
Table Design (Relationships)
Field Design (Validation)
Form Design (Input)
Menu Design (Automation)
Table Design and Relationships
Terms to Understand:
Scroll Boxes and Lookup Tables
Data Entry Screens
Menus and Automation
Creating Database Tables:
Creating a Database
What is an Access Database?
Using the New Database Window
Blank Database vs a Template
What are Data Access Pages? Live data forms that you publish to a corporate intranet.
Tables, Queries, Forms, Reports, Pages, Macros, Modules
Data Access Window Toolbar
Starting a Table:
Text, Memo, Number, Date/Time, Autonumber Yes/No, Ole Object, Hyperlink, LookupWizard
Problems in Converting Data Types…
Lab and Lecture Related Items:
Data Access Pages
1. Creating a Data Access Page
2. Finding and Opening the Page