Lesson 5

select *
from costs
where cost > 10
order by projects;

Lesson 4

I have a table that contains first name and last name in separate field. This is in case I need to sort by last name or use the first name as a salutation.

I created a calculation field combining First and Last with a space in the middle. This will cause reports to look better!

Lesson 3

What are indexes? What are the advantages and disadvantages of using indexes?

A. Indexes sort on certain field that you will be searching for. This enables quicker searches. A disadvantage might be that you can't index on an OLE field.

What is referential integrity and why is it important to your Access database?

A. Referential integrity helps prevent loose ends. In my database, there cannot be a Beginning Teacher without an assigned mentor.

Database Types

I was searching around the internet and found the www.databasecorner.com website. This gives a little information about a ton of databases! I've only heard about or used a handful of them. Provides for some interesting reading.

Access Help

I have found the Access help very easy to navigate in. I particularly like the templates and tutorials that are available on Microsoft Online. The templates might help with a quick start to a database!

Hello everyone! This is my first blog post! I guess I'll be learning what all the talk is about blogging!

I am taking this course since where I work, there are many related files in spreadsheets. I think they would benefit from a database.

More Later!