using excel syntax as queries in ms access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is it possible to use excel syntax for formulas as queries in ms access?
also, is it possible that for two tables that has a common field, once you
enter new record in one table, same is also recorded in the child table?i'm
lost...help! abel
 
Some Excel formulae will transfer directly to Access, some won't.
For example Excel uses If() and Access use IIf(). Try using the excel
function and if it doesn't work find the Access function that does.
Don't save the same data, other than key fields (the relationship), in two
tables that are related. The advantage of a relational db like Access as
opposed to a flat db like Excel is that you don't need to store redundant
data.
Also, you don't want to enter data directly into a table. Use forms. In a
form you can enter data in the Parent table and the Child table via a subform.
When the primary key data is filled in for the Parent the foreign key data is
filled in automatically when data is added to the subform.
 
Back
Top