Microsoft Access

xtau la kawe weii <<< gilo nate nih... baso bengong...

Yes. Filtering data allows you to see on certain parts of it, based on the criteria you have specified. It is one of the things that a database does, but Excel can also do.

Access can use a relational model of a database design.

to input data into one record at a time

MS PowerPoint is a presentation application for making presentations. MS Access is a database application for making databases.

very long

Microsoft Access, MySQL, Microsoft SQL Server, Oracle, FileMaker Pro, FoxPro, dBASE are all examples of database management systems. A DBMS, or database Management System, is a collection of programs that enables you to store, modify, and extract information from a database.

There are several types that can do it. A Delete Query, an Update Query and an Append Query can. You can also create and delete entire tables with queries.

It could be stored in a Memo field, but in reality you would not use Microsoft Access at all to store it. You would store in a Microsoft Word document.

You would use a JOIN query for this.

Access is better. It is a database application. So it is useful for cataloging anything, so it is ideal for cataloging books. You can use Excel, but it is primarily for dealing with numerical information. Access is better equipped to do the kinds of things you would do if you were cataloging books, like creating reports and queries.

Yes. The default sizes are configured by default in the database or can be specified using the CREATE TABLE or ALTER TABLE commands

It is known as the design grid.

as many as you like to!

A table stores data. Tables have fields in them, like name, address, date of birth etc. They are often likened to columns. One individual set, like your name, address and date of birth is a record. So tables have records in them. In a relational database there is more than one table and these tables are related to each other. So one table might store all your personal details and another my store all your employment details. By having at least one common field, like an employee number, these two tables can be related to each other. Access is a database application and has the capability to create relational databases.

1234.00

It has no value. For example, if it was a number field, that would be an equivalent to being zero or if it was a text field it would be blank.

Criteria determine what records can be shown, not what fields can be shown, so the AND criteria cannot be used to determine what fields to select.

Sigma

You start by creating a table.

fields

Yes.

because you smell

use some offline browsers

I am not sure Access hides anything. If you have a hidden agenda in this question, please ask another, more specific question to receive a meaningful answer.