0
What Microsoft program is frequently used to develop pictorial representations of a database's logical relationships?
Wiki User
∙ 8y agoWant this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
The relationships between users database applications DBMS and database?
The relationships between database applications DBMS and databases is as follows: Databases can be simple or complex. simple databases can be kept in a Microsoft Excel spreadsheet or they can be maintained in a user generated Microsoft Access database which can be programmed to query certain data that has been entered into that database over a period of time. Microsoft Excel and Microsoft Access are also applications that are used to build databases that can be incorporated into DBMS or Database Management Systems. These systems can be extremely complex or they can be simple meaning that maintenance to these systems is not demanding. If the DBMS is complex it may require an entire team of technicians and in some cases engineers.The relationship between users, database applications, databases, and Database Management Systems can be simplified even further - Users can access a database that has been created with a database application to query managed data that is a part of a uniform Database management system.
Is there any other software available to create a database than Microsoft Excel?
While you can create them with it, Microsoft Excel's main use is not for creating databases, but for creating spreadsheets. Microsoft Access is the main Microsoft product for creating databases. There are also many other applications that you can create databases with too, like Oracle, Open Office, or MySQL
Example of ralational databases?
Microsoft Access is a relational database.
How is Access different from other Microsoft Office applications?
Each of the Microsoft Office applications are completely different to each other. Microsoft Access is for creating databases. Microsoft Excel can do some databases, but it is not designed to do them, as it is a spreadsheet application. Microsoft Access has many facilities to create databases. Those things are not present in the other applications, which are each designed for their own tasks. Microsoft Access allows you create tables, queries, forms and reports as the main elements of its functionality.
How do you access Microsoft Access databases with PHP?
ODBC / System DSN
What is filename.mdb in computers?
It is the databases that Access creates. It stands for Microsoft DataBase.
Can database information be exported in an electronic format to allow other applications to import it?
Yes, they can. Microsoft Access for Instance can export to Excel, comma sep value lists, etc. These can be imported by databases like SQL & MySQL. Furthermore simple databases without many<==>many relationships can also be eported from Oracle.
Is Microsoft Access compatible with PHP?
Yes. PHP supports an API called ODBC that allows it to interact with Microsoft Access databases.
What can be a data source for a mail merge?
Databases and spreadsheets make good data sources for mail merge.
How do you create relationships in databases?
first you be friends with the person and when you get closer your crush will like you and then you will be in a relationship
Which database is better when we are going to have millions of records?
The mainly used databases are Microsoft SQL Server, Oracle, and MySQL. All three of these are relational databases and could easily handle databases containing millions of records.
Where can one find information on DB No?
One can find information on DB No by going to the Microsoft website. The Microsoft website has information about databases and how it is that they operate.
