home

= MYP Question: What is database? 14/01/10 =

It´s a collection of information that is organized and easily accessed.

= Definition of: =

Table: Is a way to organize information based on rows and columns.

Query: It requests specific types of information that can either be showed in their natural form or create a report using that information.

Forms: Is the visual appearance of something.

Reports: It presents information from a query or table in a more attractive manner.

What is Access? 18/01/10

 * It´s a very useful database management system and it functions on widows. **

What are the Key features of Access?
Data entry and update: Access provides the mechanisms to add, change or delete data.

Queries: Access let you ask questions about any topic concerning data in access with a quick answer.

= MYP Question: What are different objects in Access? 2201/2010 =

The different objects in Access are: Tables, Queries, Forms, Reports, Macros and Modules.

= How to create a blank database? = When you click on the Microsoft office botton it lets you create a new file, open an existing one and other tasks so this way you may create a new or blank database.

= How to import data from excel into Access? =

> > > []
 * //Make sure the Excel data is in// //list// //format: each column has a label in the first row and contains similar facts, and there are no blank rows or columns within the list.//
 * //Close the Excel workbook that contains the data you want to use in Microsoft Access.//
 * //In Access, open the database where you want to copy the Excel data.//
 * //On the Access// //File// //menu, point to// //Get External Data////, and then click// //Import////.//
 * //In the// //Import// //dialog box, click// //Microsoft Excel// //in the// //Files of type// //box.//
 * //In the// //Look in// //list, locate the file you want to import, and then double-click the file.//
 * //Follow the directions in the Import Spreadsheet Wiza//rd.

MYP Question: How can I Manage data? 27/01/10
Data is organized to make it more useful and easier to understand.

= MYP Question: How to create forms 29/10/10 = You select the create tab then you make a click on form.

When you have a data base you then click on create and click on report wizard and select the fields you want to work with. After that you can sort fields by birthdays, name or others.