Welcome to www.paezypaezrepresentaciones.com   Click to listen highlighted text! Welcome to www.paezypaezrepresentaciones.com Powered By GSpeech

ADM - TIC - 101 - Bases de Datos (Inglés): Topics

Intro
We will look at a large database in Excel and then import it into
Access to see the different types of searching and sorting that can be
done there.

This unit will not cover relational aspects of the Access database but will look at queries and form design.
Section 1

A large database


In this unit we look at a database in Excel that has several thousand records and see how to search and sort the data.

Section 2

Is your homework diary a database?


This homework question will be debated and discussed.  We should also find time to import our My Tunes Excel sheet into MS Access.
Section 3

Information from Data


Using access queries; comparing Excel and Access for the job of finding data - which one gets the job?
Section 4

The homework diary project


In which we investigate the possibility of using MS Access to keep track of your homework (and the time it takes you to complete it).
Section 5

Extending the system


We can use forms for navigation - they don't have to have data in them.  We can also make forms based upon specific queries - such as homeworks due.
Don't have an account yet? Register Now!

Sign in to your account

Click to listen highlighted text! Powered By GSpeech